|
<%@ 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
Millington Tennessee rent house and holiday rentals in Millington Tennessee
Rental properties in Athens, Athens vacation rentals, and Athens Tennessee homes for rent
Tazewell Tennessee bed and breakfast rentals, Tazewell Tennessee houses for rent, apartment rentals Tazewell Tennessee, and homes for rent in Tazewell Tennessee
Vacation homes Columbia and rent house in Columbia Tennessee
Rental home in Waverly Tennessee, apartments for rent, and vacation rentals in Waverly Tennessee
For rent by owner homes Smyrna, Smyrna Tennessee rental properties, holiday rentals Smyrna Tennessee, and rental homes Smyrna
Blountville real estate rentals and real estate rentals in Blountville Tennessee
Vacation rentals Cedars Tennessee, vacation rental Cedars Tennessee, and rental apartment in Cedars Tennessee
Madisonville Tennessee houses for rent, apartment rentals in Madisonville Tennessee, short term rentals Madisonville Tennessee, and homes for rent by owner Madisonville Tennessee
Springfield-Greenbrier Tennessee houses for rent and Springfield-Greenbrier Tennessee rental houses
Maryville-Alcoa Tennessee vacation homes for rent by owner, rental home in Maryville-Alcoa Tennessee, and vacation homes in Maryville-Alcoa
Rockwood Tennessee homes for rent, rent house Rockwood Tennessee, house rentals in Rockwood Tennessee, and vacation homes in Rockwood Tennessee
Apartment rentals in Covington and vacation homes in Covington
Vacation homes for rent by owner Charleston, bed and breakfast rentals Charleston, and Charleston Tennessee real estate rentals
House rentals Dickson Tennessee, Dickson Tennessee vacation rentals, vacation rentals in Dickson Tennessee, and Dickson Tennessee vacation rental
For rent by owner homes Kingsport and Kingsport vacation rentals
Vacation rental, rental properties in Pulaski Tennessee, and vacation homes for rent by owner in Pulaski Tennessee
Short term rentals in Mountain City, Mountain City Tennessee vacation rental, Mountain City Tennessee homes for rent by owner, and apartments for rent in Mountain City
Harriman Tennessee real estate rentals and rental properties in Harriman Tennessee
Vacation homes for rent by owner in Bluff City-Piney Flats, real estate rentals in Bluff City-Piney Flats Tennessee, and Bluff City-Piney Flats Tennessee house rentals
Elizabethton rental properties, homes for rent by owner in Elizabethton, bed and breakfast rentals in Elizabethton Tennessee, and vacation rental
Apartments for rent in Sweetwater Tennessee and rental homes in Sweetwater
Memphis apartment rentals, Memphis Tennessee vacation rental, and vacation rental in Memphis Tennessee
For rent by owner homes in Hendersonville Tennessee, Hendersonville Tennessee vacation homes for rent by owner, vacation rental Hendersonville Tennessee, and Hendersonville Tennessee condos for rent
Snow Hill Tennessee home rentals and Snow Hill Tennessee house rentals
St Bethlehem Tennessee rental home, house rentals St Bethlehem Tennessee, and rent house St Bethlehem Tennessee
Chilhowee houses for rent, rental home in Chilhowee, Chilhowee Tennessee apartments for rent, and homes for rent by owner in Chilhowee
Camden Tennessee rental properties and Camden vacation homes
Vacation homes for rent by owner Covington, house rentals in Covington Tennessee, and real estate rentals in Covington Tennessee
Homes for rent by owner in Brownsville Tennessee, short term rentals Brownsville, vacation rentals in Brownsville Tennessee, and condos for rent in Brownsville
Glimpse, find, and light upon for rent by owner homes in Claiborne, Claiborne rent houses, and rental apartment in Claiborne Tennessee.
Identify, ascertain, and debunk Bradley Tennessee home rentals, rent houses in Bradley Tennessee, and home rentals in Bradley Tennessee.
Condos for rent and vacation homes
Dig up, explore, and design Paris rental apartment, rental home Paris, and rental properties in Paris.
Debunk, learn, and locate rental apartment in Lyles, Lyles United States apartments for rent, and vacation rental in Lyles United States.
Elicit and move apartments for rent in Dresden United States and rent house.
Avon Illinois rental home, rental homes Avon, and houses for rent in Avon Illinois
Tazewell Tennessee reports could boost, serve, reinforce, and boost your witch hunt.
We invented, occasioned, and actualize our for rent by owner website to be comely, cute, and exquisite.
Find out, elicit, and uncover rental homes in Buchanan United States, condo rentals, and apartment rentals in Buchanan.
Invent and relocate Weakley Tennessee rental apartment and Weakley apartment rentals.
Come across and learn homes for rent by owner in Warren, rental houses in Warren, and short term rentals in Warren Tennessee.
Light upon and determine rental apartment and homes for rent in Belfast United States.
Identify and debunk house rentals and rental properties in Springfield United States.
Elicit, determine, and discover rental homes, Johnson City apartment rentals, and homes for rent by owner in Johnson City United States.
Notice, identify, and ascertain Five Points United States rental properties, short term rentals in Five Points, and short term rentals.
Rental homes in Ennis and Ennis Texas vacation homes for rent by owner
Find out, locate, and devise apartments for rent in Chester, apartments for rent Chester, and vacation homes for rent by owner Chester Tennessee.
Contrive and ferret out bed and breakfast rentals in Gibson Tennessee, rent houses in Gibson Tennessee, rental properties in Gibson Tennessee, and Gibson Tennessee rental properties.
Hillside online MLS and suburban listings houses for rent in Moore Tennessee, rent house Moore Tennessee, for rent by owner homes in Moore Tennessee, and Moore Tennessee holiday rentals.
Come across, design, and ferret out Bledsoe Tennessee home rentals and Bledsoe apartments for rent.
The Tazewell Tennessee advertisements census and manifested on our page subsume city lodge, ski in/out lodge, private flat, and exclusive vacation home.
Ferret out and relocate the territory and not far Tazewell tract.
Disclose and find rental houses, Marshall Tennessee home rentals, and condos for rent in Marshall.
Perceive and identify Lavinia bed and breakfast rentals and rent houses.
Tazewell third party listing companies, property owners, land owners, and real estate brokers list bed and breakfast rentals Tazewell Tennessee, houses for rent, apartment rentals, and rental homes Tazewell.
Ferret out, disclose, and dig up Philadelphia United States home rentals, rental home, and rental properties in Philadelphia.
Intermittently, puff, push, and benefit your explorers, householders, and comrades to a fascinating, big man, massive, and societal tract.
East Leon homes for rent by owner, vacation homes for rent by owner in East Leon Florida, East Leon rent house, and East Leon Florida bed and breakfast rentals
Send lovely, cute, superb, and bewitching knowledge regarding rental properties Tazewell and short term rentals in Tazewell Tennessee found on our website, FRBO.com.
See spacious ads, suburban advertisements, loft classified advertisements, and lake advertisements that rental owners and third party listing companies post on this site, FRBO.com.
Roomers and traveling sales representatives poke into and scrutinize our website, FRBO.com and disclose suburban villa, studio cabin, and ski in/out house.
|
|
