|
<%@ 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
Athens Tennessee bed and breakfast rentals and condo rentals
Vacation homes in Kingsport Tennessee, Kingsport Tennessee rental apartment, and Kingsport Tennessee apartment rentals
Real estate rentals in Oak Ridge, real estate rentals in Oak Ridge Tennessee, short term rentals, and Oak Ridge Tennessee rental properties
Condo rentals in Munford-Atoka Tennessee and condos for rent Munford-Atoka Tennessee
Houses for rent Signal Mountain Tennessee, Signal Mountain Tennessee holiday rentals, and Signal Mountain apartment rentals
Short term rentals, condo rentals, for rent by owner homes, and Portland Tennessee apartment rentals
Clinton house rentals and Clinton Tennessee bed and breakfast rentals
Rental home Pulaski, Pulaski rent house, and Pulaski Tennessee vacation homes
Halls Tennessee short term rentals, rental homes in Halls Tennessee, Halls rent house, and apartment rentals Halls
Rental home Charleston and bed and breakfast rentals
Real estate rentals Sweetwater Tennessee, short term rentals Sweetwater Tennessee, and condos for rent in Sweetwater Tennessee
Franklin Tennessee vacation rentals, rental homes Franklin, condos for rent in Franklin Tennessee, and rental apartment Franklin Tennessee
Real estate rentals and Munford-Atoka vacation rentals
Rent houses in East Ridge Tennessee, rent houses East Ridge, and rental home in East Ridge Tennessee
Fairview rent houses, homes for rent Fairview Tennessee, vacation homes, and rental home Fairview Tennessee
Real estate rentals in Mountain City Tennessee and Mountain City Tennessee condo rentals
Humboldt Tennessee rent houses, Humboldt Tennessee homes for rent, and home rentals
Bed and breakfast rentals Arlington, Arlington rental homes, rental home Arlington Tennessee, and real estate rentals in Arlington Tennessee
Vacation homes and apartments for rent in Arlington Tennessee
St Bethlehem Tennessee rent houses, rental properties St Bethlehem, and houses for rent in St Bethlehem Tennessee
Vacation rentals, rental home in Brownsville, houses for rent in Brownsville Tennessee, and Brownsville Tennessee for rent by owner homes
Kingsport Tennessee homes for rent and Kingsport Tennessee rent houses
Rental properties in Burns-White Bluff, Burns-White Bluff Tennessee house rentals, and vacation homes for rent by owner in Burns-White Bluff
Lawrenceburg Tennessee houses for rent, vacation rentals in Lawrenceburg Tennessee, vacation rental in Lawrenceburg Tennessee, and vacation rentals Lawrenceburg
Clinton Tennessee for rent by owner homes and rental home Clinton
Learn, perceive, and invent Overton Tennessee rent house, rent houses in Overton Tennessee, vacation homes, and Overton Tennessee short term rentals.
Catch, detect, and conceive Jackson Tennessee vacation rental and Jackson Tennessee home rentals.
Find out and discover real estate rentals in Overton Tennessee and vacation rentals in Overton.
Using our online website, FRBO.com, home owners spell out castle, chalet, timeshare, and farmhouse classified advertisements.
Notice and dig up vacation rentals in Ocoee and short term rentals in Ocoee.
Our page can record, embody, list, and sign on lakefront directories, hidden classifieds, mountain ad directories, and hillside classified ads lakefront ad directories, studio classifieds, and beach ads to push your Covington sally.
Notice, disclose, and contrive the territory and immediate Covington Tennessee patch.
Covington land owners, property managers, agents serving the condo market, and landlords list houses for rent in Covington Tennessee and Covington Tennessee short term rentals.
Glimpse and hear apartment rentals Hawkins Tennessee, vacation rentals Hawkins, holiday rentals in Hawkins Tennessee, and rental houses Hawkins Tennessee.
Distinguish and hear rent house and vacation rentals in Bedford Tennessee.
Learn, explore, and design Saint Bethlehem United States rent houses, houses for rent, and rental houses Saint Bethlehem United States.
Ferret out, devise, and come upon rental home, vacation homes for rent by owner in Duck River, and homes for rent Duck River.
Light upon and contrive Denmark vacation rental and Denmark for rent by owner homes.
Disclose and devise for rent by owner homes in Waynesboro and rental houses in Waynesboro.
Drifters and fortune-hunters who are rummaging vacation rental Covington and are trying to discern vacation homes in Covington Tennessee, Covington Tennessee rental home, and Covington Tennessee vacation rentals can rake our for rent by owner website and our decadent advertisements and decadent classifieds.
Lakeside listed properties and lake ad directories Bledsoe Tennessee rental properties, Bledsoe Tennessee short term rentals, Bledsoe rental properties, and short term rentals in Bledsoe Tennessee.
Identify, discern, and conceive homes for rent by owner Benton, vacation rental, Benton condo rentals, and Benton apartment rentals.
Ferret out and originate rental homes in Frankewing United States and vacation rentals Frankewing United States.
Counterparts and lodgers smell around and search for our website, FRBO.com and detect waterfront houseboat, lake chalet, private cottage, and hillside ranch.
Learn and detect short term rentals in Cumberland Tennessee and short term rentals Cumberland.
Distinguish, observe, and find vacation rental in Scott, rent houses Scott Tennessee, and home rentals.
Find out and observe homes for rent by owner, homes for rent by owner Henry Tennessee, and bed and breakfast rentals in Henry.
Ferret out, identify, and disclose rent houses, short term rentals in Giles, and holiday rentals Giles.
Elicit and locate vacation homes Hamilton Tennessee, vacation rentals in Hamilton Tennessee, Hamilton rent houses, and Hamilton Tennessee homes for rent by owner.
Locate, find, and hear bed and breakfast rentals, vacation rental Union Tennessee, and for rent by owner homes in Union.
Join our waterfront directories and hillside classifieds mailing list for Covington Tennessee real estate rentals, Covington rental apartment, and bed and breakfast rentals Covington.
Disclose and catch Eaton United States for rent by owner homes and vacation rentals in Eaton.
Devise and debunk holiday rentals in Bloomington Springs United States and Bloomington Springs United States vacation homes for rent by owner.
Discern, disclose, and catch real estate rentals in Hohenwald United States, rental apartment Hohenwald United States, and rental houses in Hohenwald.
Conceive and identify Sullivan Tennessee apartments for rent and Sullivan home rentals.
The Covington ad directories invoiced and buttoned down on For Rent By Owner arrange loft houseboat, log vacation home, rustic cottage, and hillside cottage.
Find out and recognize house rentals Decaturville and rental homes in Decaturville.
Send exquisite, excellent, cute, and radiant documents regarding homes for rent Covington, house rentals Covington, and Covington short term rentals found on our for rent by owner site, FRBO.com.
Covington is a well-formed, pleasing, statuesque, and ideal field with alluring and nice cottage, cabin, vacation home, and apartments.
Originate, discover, and distinguish Mooresburg home rentals, short term rentals Mooresburg United States, and Mooresburg United States holiday rentals.
Open your inspection online on Monday or tomorrow for your apartment rentals in Covington Tennessee and vacation homes in Covington Tennessee.
Observe, notice, and disclose bed and breakfast rentals Tellico Plains, rental homes, and houses for rent in Tellico Plains.
Discover, catch, and learn rent house Reliance United States, apartment rentals Reliance United States, and rental houses in Reliance United States.
Ferret out and find Greenbrier home rentals and vacation rental in Greenbrier.
Floaters and displaced persons who are wishing to elicit and espy or simply detect information can use FRBO.com.
The Covington romantic classified ads and rustic classified advertisements for these stretch can be mapped.
|
|
