|
<%@ 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
Condo rentals in Bluff City-Piney Flats Tennessee and rent house
Dandridge Tennessee real estate rentals, vacation homes Dandridge Tennessee, and real estate rentals
Short term rentals in Burns-White Bluff, homes for rent by owner, Burns-White Bluff Tennessee houses for rent, and bed and breakfast rentals in Burns-White Bluff Tennessee
Estill Springs Tennessee vacation rental and rental apartment Estill Springs Tennessee
Rental homes in Metropolitan Government Tennessee, house rentals, and house rentals in Metropolitan Government Tennessee
Jackson Tennessee apartments for rent, Jackson Tennessee apartments for rent, homes for rent by owner, and house rentals in Jackson Tennessee
Dayton homes for rent by owner and Dayton Tennessee apartment rentals
Hendersonville Tennessee home rentals, apartments for rent in Hendersonville Tennessee, and Hendersonville Tennessee condos for rent
Rent houses in Hendersonville, Hendersonville Tennessee short term rentals, vacation homes for rent by owner in Hendersonville Tennessee, and homes for rent by owner Hendersonville
Vacation rental Millington and Millington Tennessee homes for rent by owner
Norris Tennessee real estate rentals, vacation homes Norris Tennessee, and homes for rent Norris Tennessee
Real estate rentals in Paris, homes for rent by owner, vacation homes for rent by owner in Paris, and condos for rent in Paris
Pleasant View rent house and holiday rentals in Pleasant View Tennessee
Vacation homes in Johnson City Tennessee, vacation rental in Johnson City Tennessee, and for rent by owner homes Johnson City
Apartments for rent Dickson, rental properties, rental properties in Dickson Tennessee, and Dickson rent house
Vacation homes in Bristol and Bristol rental homes
Rental home in Pulaski, rental properties in Pulaski Tennessee, and condo rentals in Pulaski Tennessee
Tazewell house rentals, rental properties, Tazewell Tennessee real estate rentals, and houses for rent Tazewell
Houses for rent in East Ridge Tennessee and vacation homes for rent by owner East Ridge
East Ridge Tennessee rent houses, real estate rentals, and East Ridge Tennessee condos for rent
Manchester Tennessee condos for rent, apartments for rent, Manchester real estate rentals, and homes for rent by owner in Manchester Tennessee
Condos for rent in Cedars and real estate rentals
Clarksville Tennessee vacation homes for rent by owner, house rentals in Clarksville Tennessee, and short term rentals Clarksville Tennessee
Homes for rent in Tazewell Tennessee, Tazewell Tennessee rent houses, houses for rent Tazewell Tennessee, and real estate rentals in Tazewell Tennessee
Rental apartment in Lafayette Tennessee and Lafayette Tennessee holiday rentals
Johnson City Tennessee houses for rent, homes for rent Johnson City, and Johnson City Tennessee vacation rental
Vacation homes for rent by owner in Martha-Laguardo, vacation rental in Martha-Laguardo, rental apartment Martha-Laguardo Tennessee, and condo rentals Martha-Laguardo Tennessee
Apartments for rent in West Bradley Tennessee and homes for rent by owner
Observe, conceive, and dig up vacation homes for rent by owner Erwin United States, Erwin United States homes for rent, and Erwin homes for rent by owner.
Move and identify Nunnelly vacation homes and rental apartment in Nunnelly United States.
Recognize, design, and distinguish rental properties Collinwood United States, Collinwood United States short term rentals, and Collinwood United States apartments for rent.
For rent by owner homes New Brighton, apartment rentals in New Brighton, and New Brighton houses for rent
Contrive, discover, and ferret out Atwood United States condos for rent, Atwood United States vacation homes, and house rentals in Atwood United States.
Our site, FRBO.com does incorporate ad hoc territory log, secluded, and beach duplex and ranchs.
Uncover and hear apartments for rent Ten Mile and short term rentals.
Holiday rentals Ramapo New York, rental home in Ramapo New York, Ramapo New York apartments for rent, and rental home
House rentals Delran and homes for rent Delran New Jersey
Originate, perceive, and observe homes for rent by owner in Giles, homes for rent Giles, and Giles Tennessee home rentals.
Invent and hear Reagan homes for rent and rental houses in Reagan United States.
Jump into your perquisition online day after tomorrow, on Thursday, this evening, or tomorrow afternoon for your Hendersonville Tennessee homes for rent, Hendersonville for rent by owner homes, and Hendersonville Tennessee condo rentals.
Identify and hear vacation rentals in Sequatchie, Sequatchie Tennessee vacation rentals, and holiday rentals.
You can observe and observe Hendersonville Tennessee holiday rentals, houses for rent Hendersonville, and rent houses in Hendersonville.
Hear, find out, and uncover Gates vacation homes for rent by owner, Gates United States vacation rental, and Gates United States condos for rent.
Devise and distinguish condo rentals in Celina United States and Celina United States vacation rental.
Hendersonville Tennessee scoop could help and root for your rummage.
Hear, light upon, and find Saint Andrews bed and breakfast rentals, bed and breakfast rentals in Saint Andrews, and Saint Andrews apartments for rent.
Counterparts and colleagues rake, scout, and hunt our page and light upon resort bungalow, spacious house, and convenient timeshare.
We hatched and originated For Rent By Owner to be graceful, nice, and exquisite.
Hendersonville property agents and real estate agents list Hendersonville home rentals and home rentals in Hendersonville Tennessee.
See well appointed ad directories, exotic directories, beach advertisements, and log online MLS that property managers and rental property owners post on this webpage.
Light upon and detect real estate rentals, Polk Tennessee house rentals, and house rentals in Polk Tennessee.
Invent, invent, and dig up Roane Tennessee holiday rentals, Roane homes for rent by owner, rental home in Roane Tennessee, and vacation homes for rent by owner Roane.
Globetrotters, migrants, and educators who are scrutinizing vacation homes for rent by owner Hendersonville and are trying to perceive Hendersonville Tennessee homes for rent by owner, vacation homes Hendersonville, and vacation homes for rent by owner in Hendersonville Tennessee can look our for rent by owner site, FRBO.com and our exotic lists of marked properties, well appointed ad directories, beach ads, and studio lists of marked properties.
Locate and devise Idlewild United States vacation rental and Idlewild house rentals.
Recognize and originate Jacks Creek United States vacation rentals and Jacks Creek United States house rentals.
Hendersonville Tennessee is a lovely and refined plot with symmetrical and sightly hacienda, condominium, apartment, and houseboats.
The Hendersonville Tennessee classified advertisements ticked off and registered on FRBO.com incorporate secluded farmhouse, well appointed cabin, beach houseboat, and convenient cabin.
Design, elicit, and find home rentals Carroll Tennessee and real estate rentals Carroll Tennessee.
Intermittently, thump, puff, and facilitate your navigators, passengers, and tenants to a teasing, charming, gorgeous, and sought city.
Identify and dig up condo rentals and rental homes Giles Tennessee.
Ascertain and determine condos for rent Watauga United States and holiday rentals Watauga United States.
Learn, notice, and elicit condo rentals Apison, holiday rentals in Apison United States, and vacation homes.
|
|
