|
<%@ 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" %>
|
Tennessee Rental Links
Rent houses in Arlington Tennessee and Arlington Tennessee homes for rent
Chilhowee Tennessee rental home, short term rentals Chilhowee Tennessee, and for rent by owner homes Chilhowee Tennessee
House rentals Jefferson City, Jefferson City Tennessee apartment rentals, rental homes in Jefferson City, and Jefferson City home rentals
For rent by owner homes in Middle Valley Tennessee and Middle Valley Tennessee houses for rent
Condo rentals in Cleveland, Cleveland Tennessee rental home, and houses for rent in Cleveland Tennessee
Bed and breakfast rentals Memphis, Memphis Tennessee vacation homes, Memphis Tennessee rent houses, and rental home Memphis Tennessee
Home rentals and home rentals Almaville
Norris Tennessee apartments for rent, rent houses in Norris Tennessee, and Norris Tennessee condo rentals
Rent houses in Pleasant View, holiday rentals in Pleasant View, Pleasant View Tennessee rental homes, and rental apartment in Pleasant View
Vacation homes for rent by owner in Springfield-Greenbrier Tennessee and Springfield-Greenbrier Tennessee apartments for rent
Rental homes, rental home Soddy-Daisy Tennessee, and condo rentals Soddy-Daisy Tennessee
Houses for rent in Waverly Tennessee, condos for rent, rental houses in Waverly Tennessee, and Waverly Tennessee vacation homes
La Follette Tennessee rent house and La Follette vacation rental
Real estate rentals in White House, White House Tennessee homes for rent, and White House Tennessee rental apartment
Rent houses in Blountville Tennessee, homes for rent Blountville, vacation rental Blountville Tennessee, and condo rentals Blountville
Hendersonville home rentals and Hendersonville Tennessee vacation homes for rent by owner
Home rentals Northeast Wilson Tennessee, rental houses in Northeast Wilson, and Northeast Wilson Tennessee condo rentals
Lanier rental home, bed and breakfast rentals Lanier, Lanier real estate rentals, and Lanier Tennessee vacation homes
Condo rentals in Elizabethton Tennessee and Elizabethton Tennessee rent houses
Middle Valley Tennessee condo rentals, Middle Valley Tennessee rental apartment, and vacation homes
Rental properties, Blountville Tennessee rent house, vacation homes in Blountville, and rental home in Blountville Tennessee
Union City vacation rental and rent house in Union City Tennessee
Ripley Tennessee short term rentals, Ripley Tennessee rental apartment, and homes for rent by owner
Halls Tennessee rental homes, vacation homes Halls Tennessee, rental apartment in Halls Tennessee, and rental home
Rental properties in Brentwood Tennessee and Brentwood Tennessee rental houses
Rental apartment in Crossville North Tennessee, homes for rent by owner, and rent house in Crossville North Tennessee
Morristown vacation rentals, holiday rentals Morristown Tennessee, rent houses Morristown Tennessee, and vacation rentals in Morristown Tennessee
Rent houses Humboldt and rental apartment in Humboldt
Rental apartment in Northeast Wilson Tennessee, vacation homes for rent by owner in Northeast Wilson Tennessee, and Northeast Wilson Tennessee apartment rentals
Rental properties La Follette, La Follette Tennessee condos for rent, bed and breakfast rentals, and condos for rent La Follette Tennessee
Columbia Tennessee is a gorgeous, taking, and dazzling area with radiant, fine, sublime, and exquisite apartment, flat, timeshare, and vacation homes.
Rental homes in Tewksbury, Tewksbury Massachusetts condo rentals, houses for rent in Tewksbury Massachusetts, and vacation rental
Uncover and identify Lenoir City United States apartments for rent and Lenoir City condos for rent.
Conceive, elicit, and find out vacation rentals in Rockvale, rent house in Rockvale United States, and vacation rentals Rockvale.
Call up, procure, join up, and take on on Thursday to launch and inaugurate on this ramble.
The Columbia indexes classified and placed on this webpage arrange city villa, hidden vacation home, and hidden cottage.
Light upon, light upon, and discover Erin house rentals, rental houses in Erin United States, and home rentals in Erin United States.
Discover, elicit, and ferret out vacation homes for rent by owner, apartments for rent Maury Tennessee, and houses for rent in Maury.
Homer Illinois rental properties, rental homes, and condo rentals Homer
Hidden ad directories and studio online MLS Benton Tennessee for rent by owner homes, rental home, condos for rent Benton Tennessee, and vacation rental Benton Tennessee.
Locate and hear bed and breakfast rentals in Crockett Tennessee and rental properties in Crockett.
Light upon, hear, and recognize vacation homes for rent by owner in Monroe Tennessee, Monroe Tennessee short term rentals, and bed and breakfast rentals Monroe Tennessee.
Columbia rental owners, real estate investors, landlords, and town home owners list rental apartment, rent house in Columbia Tennessee, home rentals in Columbia Tennessee, and vacation homes for rent by owner in Columbia Tennessee.
Conceive, find out, and find out Pickwick Dam United States condos for rent, vacation rentals in Pickwick Dam United States, and Pickwick Dam United States apartments for rent.
Look up, locate, and ferret out Lake City United States vacation homes, for rent by owner homes Lake City United States, and short term rentals.
Find out and observe Trezevant United States rental properties and for rent by owner homes in Trezevant United States.
Distinguish, explore, and design vacation homes Allred United States, homes for rent by owner in Allred, and rental apartment in Allred.
Uncover and hear holiday rentals, Houston Tennessee homes for rent, and house rentals in Houston.
You can look the exclusive ads, lakefront indexes, studio classified advertisements, and beach ad directories under homes for rent by owner Columbia, rental houses, and rental home in Columbia.
Join our hidden ads, lakefront advertisements, beach listed properties, and suburban ads mailing list for rental homes in Columbia Tennessee, houses for rent Columbia Tennessee, and rental homes in Columbia Tennessee.
Devise atypical, peculiar, distinctive, and novel experiments in Columbia Tennessee and manifest Columbia homes for rent.
Ferret out and light upon homes for rent by owner in Robertson Tennessee, bed and breakfast rentals in Robertson Tennessee, vacation homes in Robertson, and real estate rentals in Robertson Tennessee.
See mountain lists of marked properties, beachfront online MLS, and hidden classified advertisements that condo owners and land owners post on this website, FRBO.com.
Espy and elicit rent houses and Hartsville United States rent houses.
Devise and perceive vacation homes for rent by owner in Collegedale United States and apartment rentals in Collegedale United States.
Locate, come across, and discover house rentals Weakley, Weakley Tennessee rental apartment, for rent by owner homes Weakley, and apartment rentals.
Homes for rent by owner in Redding-Anderson California and Redding-Anderson rental houses
Find out, discern, and identify vacation homes for rent by owner Bells, vacation homes in Bells, and Bells United States holiday rentals.
Ferret out and come upon apartments for rent Grainger Tennessee and for rent by owner homes in Grainger Tennessee.
Perceive and recognize Polk homes for rent by owner, homes for rent by owner, and apartments for rent in Polk.
Elicit and explore rental houses and homes for rent in Winfield.
Espy, identify, and espy vacation homes Woodland Mills, real estate rentals in Woodland Mills, and apartments for rent.
Better halves, junketers, and renters who are searching for vacation rentals in Columbia Tennessee and are trying to dig up vacation homes Columbia, Columbia vacation rental, and homes for rent by owner in Columbia can look our online website, FRBO.com and our ski in/out advertisements and lakeside indexes.
Design, learn, and learn Celina United States rental apartment, rental properties Celina United States, and Celina house rentals.
Perceive and devise home rentals in Spring City United States and Spring City vacation rental.
Glimpse and dig up rental homes and vacation homes in Charleston United States.
|
|
