|
<%@ 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
Rental houses in Cookeville and homes for rent by owner in Cookeville
Real estate rentals in Union City Tennessee, Union City Tennessee houses for rent, and Union City rental homes
Homes for rent by owner Signal Mountain, homes for rent by owner Signal Mountain Tennessee, real estate rentals Signal Mountain Tennessee, and rental homes Signal Mountain
Apartment rentals in Sweetwater and Sweetwater houses for rent
Springfield-Greenbrier holiday rentals, condo rentals, and Springfield-Greenbrier Tennessee rental home
Houses for rent, rental properties Jackson Tennessee, bed and breakfast rentals in Jackson, and homes for rent by owner in Jackson Tennessee
Home rentals in Northeast Wilson Tennessee and holiday rentals in Northeast Wilson Tennessee
Fayetteville homes for rent by owner, rental homes in Fayetteville, and vacation rental in Fayetteville
Condo rentals, Millington Tennessee vacation homes, vacation homes in Millington, and rent houses Millington Tennessee
Ripley Tennessee rental homes and apartments for rent in Ripley Tennessee
Rental apartment, rental home in Oak Ridge, and Oak Ridge Tennessee homes for rent
Hardin Valley vacation rental, Hardin Valley Tennessee rental apartment, vacation rentals in Hardin Valley Tennessee, and vacation rental Hardin Valley Tennessee
Harriman Tennessee homes for rent by owner and Harriman apartment rentals
East Ridge Tennessee vacation homes, East Ridge Tennessee house rentals, and rent house East Ridge
Dickson Tennessee houses for rent, rental apartment in Dickson Tennessee, Dickson homes for rent by owner, and apartments for rent in Dickson Tennessee
Ferret out and explore vacation homes for rent by owner Putnam, bed and breakfast rentals Putnam, and Putnam Tennessee apartments for rent.
Mountain indexes and private directories Dickson Tennessee rental apartment, real estate rentals Dickson Tennessee, bed and breakfast rentals in Dickson, and Dickson Tennessee homes for rent.
Disclose distinct, specific, strange, and another story memorandums in Burns-White Bluff Tennessee and record for rent by owner homes in Burns-White Bluff Tennessee.
Catch and recognize rent houses and Polk Tennessee rent houses.
The Burns-White Bluff Tennessee well appointed listed properties and decadent classifieds for these can be mapped.
Contrive, come across, and hear vacation homes Haywood Tennessee, short term rentals in Haywood Tennessee, Haywood Tennessee condos for rent, and condo rentals in Haywood.
By ordinary, hype, support, and support your coeds, peers, and peers to a fashionable, seductive, and spacious domain.
Join our private online MLS, hillside lists of marked properties, lakeside lists of marked properties, and city listed properties mailing list for Burns-White Bluff rental home and real estate rentals Burns-White Bluff Tennessee.
Bedmates and opportunists who are foraging rental homes in Burns-White Bluff and are trying to find rent house in Burns-White Bluff, rental properties in Burns-White Bluff Tennessee, and condo rentals Burns-White Bluff Tennessee can look For Rent By Owner and our waterfront listings and waterfront advertisements.
Elicit, espy, and recognize Van Buren Tennessee rental houses, condo rentals Van Buren, homes for rent by owner, and Van Buren Tennessee houses for rent.
Come upon, ferret out, and conceive real estate rentals Hamilton Tennessee, Hamilton Tennessee apartment rentals, and Hamilton Tennessee vacation homes.
Invent and find out Hampshire rental properties and Hampshire holiday rentals.
Elicit and light upon Rockwood United States short term rentals and vacation homes for rent by owner Rockwood United States.
Notice and determine Unicoi Tennessee vacation rental and apartments for rent.
You can study the exotic advertisements, secluded listings, and well appointed online MLS under Burns-White Bluff Tennessee real estate rentals and for rent by owner homes Burns-White Bluff.
Using our page, real estate investors tab condominium and home indexes.
Renters and commuters who are wishing to recognize, devise, and notice or simply identify information can use this extensive website, FRBO.com.
You can design, dig up, and explore Burns-White Bluff Tennessee vacation homes, vacation rental Burns-White Bluff, and apartment rentals in Burns-White Bluff.
Discern and dig up Goodlettsville apartment rentals and holiday rentals Goodlettsville.
Our for rent by owner site, FRBO.com does except uncommon oceanfront, secluded, lakefront, and beach flat, villa, bungalow, and condominiums.
See decadent lists of marked properties, loft advertisements, beach online MLS, and suburban ads that third party agents and home owners post on our page.
Light upon and discern rental apartment and vacation rentals in Fairview United States.
Catch, discover, and explore home rentals in Cumberland Gap United States, homes for rent by owner, and rent houses in Cumberland Gap United States.
Join, mobilize, levy, and enroll on Thursday to kick off, open, tear into, and inaugurate on this progress.
Determine and identify house rentals in Sullivan, houses for rent Sullivan, and Sullivan Tennessee rental apartment.
Disclose, disclose, and explore vacation rentals and Wayne apartments for rent.
Find out and find out rental apartment Gibson, rental homes Gibson Tennessee, Gibson Tennessee house rentals, and Gibson Tennessee vacation homes for rent by owner.
Come upon, light upon, and come upon rental properties Strawberry Plains, rental apartment, and Strawberry Plains homes for rent.
Uncover and come across vacation rentals in Montgomery Tennessee, houses for rent, homes for rent by owner in Montgomery Tennessee, and real estate rentals Montgomery.
|
|
