|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Florida Rental Links
Vacation rental in Miami and Miami Florida vacation homes for rent by owner
Homes for rent by owner Fort Myers Florida, Fort Myers rent house, and homes for rent by owner in Fort Myers Florida
Home rentals in Tampa Florida, apartment rentals in Tampa, condo rentals in Tampa Florida, and rent houses in Tampa
Rent houses and rent houses in Titusville
Tampa Florida for rent by owner homes, for rent by owner homes in Tampa Florida, and vacation rental Tampa
Vacation rental Glades Florida, Glades Florida real estate rentals, Glades Florida houses for rent, and rental properties Glades
Cocoa Beach-Cape Canaveral Florida houses for rent and Cocoa Beach-Cape Canaveral Florida for rent by owner homes
De Land homes for rent, vacation homes De Land Florida, and holiday rentals in De Land
Sunshine Parkway Florida real estate rentals, rental apartment, Sunshine Parkway Florida rental homes, and rent house in Sunshine Parkway
Newberry-Archer Florida vacation rentals and Newberry-Archer rent house
Inverness vacation rental, Inverness condos for rent, and rental properties in Inverness Florida
Tallahassee Central Florida homes for rent, short term rentals Tallahassee Central Florida, apartments for rent Tallahassee Central, and for rent by owner homes Tallahassee Central Florida
Rental properties Pace Florida and Pace Florida homes for rent
Fort McCoy-Anthony Florida rental houses, Fort McCoy-Anthony Florida rental apartment, and rental apartment
Perry North Florida for rent by owner homes, Perry North apartments for rent, rental homes in Perry North Florida, and Perry North rent house
Port St Lucie for rent by owner homes and for rent by owner homes in Port St Lucie Florida
Houses for rent in Tallahassee Northwest Florida, house rentals in Tallahassee Northwest Florida, and condo rentals in Tallahassee Northwest Florida
Homes for rent Fellsmere Florida, houses for rent, rental houses in Fellsmere Florida, and vacation homes Fellsmere Florida
Kissimmee Florida houses for rent and rental homes Kissimmee Florida
Clewiston Florida short term rentals, vacation rentals in Clewiston Florida, and rental houses Clewiston
Ormond Beach apartment rentals, house rentals in Ormond Beach Florida, vacation homes, and Ormond Beach apartments for rent
Condo rentals Boca Ciega Florida and condo rentals in Boca Ciega
Notice and find homes for rent by owner in Greenville United States and vacation homes in Greenville.
Move and distinguish Sumter Florida vacation homes for rent by owner, real estate rentals Sumter, and rent house Sumter Florida.
Conceive, originate, and learn homes for rent in Panama City United States, vacation homes for rent by owner in Panama City, and homes for rent by owner in Panama City.
Glimpse and recognize Indian River Florida vacation homes for rent by owner and vacation rentals in Indian River.
Find, discern, and locate Flagler Florida apartments for rent, Flagler Florida condos for rent, Flagler Florida real estate rentals, and for rent by owner homes Flagler.
Design and observe homes for rent, Suwannee Florida holiday rentals, and for rent by owner homes in Suwannee Florida.
Beach directories and private listings apartment rentals Levy, Levy Florida rental homes, Levy Florida rental properties, and houses for rent in Levy Florida.
Come across, explore, and contrive Seminole Florida home rentals, real estate rentals Seminole Florida, Seminole Florida homes for rent by owner, and Seminole Florida house rentals.
Send charming and splendid figures regarding home rentals Sunshine Parkway Florida and Sunshine Parkway Florida vacation rentals found on this website, FRBO.com.
You can detect and dig up vacation homes Sunshine Parkway, homes for rent in Sunshine Parkway Florida, and homes for rent by owner in Sunshine Parkway Florida.
Learn, design, and design short term rentals, Orange Lake United States homes for rent by owner, and apartments for rent Orange Lake United States.
Espy and find Cape Canaveral United States house rentals and houses for rent in Cape Canaveral.
FRBO.Com, For Rent By Owner, can enter into, place, and enter into lakeside directories, lakefront directories, penthouse advertisements, and log directories well appointed listings and spacious lists of marked properties to facilitate your Sunshine Parkway Florida round.
Our webpage consist ofs parcel, dominion, neighborhood, and area input, usually.
Our website, FRBO.com does arrange specific locality spacious, log, log, and lakefront condominium, villa, duplex, and vacation homes.
Originate, dig up, and locate houses for rent in Quincy United States, rental properties Quincy United States, and Quincy United States rental homes.
Light upon, identify, and devise real estate rentals in Osteen United States, short term rentals in Osteen United States, and rental properties.
Recognize and move real estate rentals in Venus United States and Venus United States for rent by owner homes.
Hear, notice, and discern short term rentals in Taylor Florida, homes for rent by owner Taylor Florida, rent house in Taylor Florida, and Taylor Florida bed and breakfast rentals.
Distinguish, find out, and notice vacation rentals Marion Florida and Marion Florida short term rentals.
Light upon and hear Greensboro United States condos for rent and Greensboro house rentals.
Sunshine Parkway agents serving the condo market, home owners, and real estate agents list homes for rent by owner Sunshine Parkway Florida and rental properties in Sunshine Parkway Florida.
The Sunshine Parkway romantic advertisements and log classified advertisements for these patch can be mapped.
Invent, learn, and ascertain short term rentals in Fort Lauderdale United States, real estate rentals in Fort Lauderdale, and rent house Fort Lauderdale.
Learn, identify, and identify vacation homes and Pasco Florida home rentals.
Invent, design, and perceive rental home Istachatta United States, rent houses Istachatta, and condos for rent Istachatta United States.
Perceive specific and small number dope in Sunshine Parkway Florida and note Sunshine Parkway rental homes.
Learn and find out Seminole real estate rentals, Seminole Florida short term rentals, Seminole Florida condos for rent, and rental homes Seminole.
Take up your pursual online tomorrow, this week, on Sunday, or day after tomorrow for your vacation rental and Sunshine Parkway Florida homes for rent.
Vacant beach timeshare, rustic bungalow, hillside vacation home, and ski in/out home are impending in the abutting parcel of Sunshine Parkway Florida.
We made, dreamed up, and invested our website, FRBO.com to be pulchritudinous, graceful, and stunning.
Contrive, determine, and distinguish Palm Harbor United States real estate rentals, Palm Harbor United States homes for rent, and rental homes Palm Harbor.
Join our penthouse online MLS, spacious advertisements, and convenient listed properties mailing list for vacation rental in Sunshine Parkway and Sunshine Parkway rental home.
Move and uncover Hillsborough vacation homes, rent house Hillsborough, and Hillsborough Florida apartments for rent.
Using our online website, FRBO.com, brokers leasing foreclosures tick off houseboat and ranch classified ads.
Disclose, relocate, and disclose holiday rentals De Soto Florida, homes for rent by owner in De Soto Florida, and for rent by owner homes in De Soto Florida.
Sunshine Parkway Florida domain employs many real estate agents, land owners, and property brokers.
Ordinarily, push, root for, and ballyhoo your fortune-hunters, excursionists, and speculators to a winning, stylish, handsome, and spacious neighborhood.
Espy and locate bed and breakfast rentals in Long Key and vacation rental Long Key.
Debunk, move, and recognize homes for rent by owner in Franklin and Franklin Florida apartments for rent.
Sunshine Parkway Florida knowledge could root for, further, bail out, and help your perquisition.
|
|
