|
<%@ 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
Apartment rentals in Burns-White Bluff and Burns-White Bluff Tennessee vacation homes for rent by owner
House rentals in Portland, vacation rentals Portland, and Portland Tennessee rental homes
Rental apartment in Columbia Tennessee, rent houses Columbia, bed and breakfast rentals, and vacation homes for rent by owner Columbia Tennessee
Bed and breakfast rentals in Smithville Tennessee and vacation homes in Smithville Tennessee
Vacation rentals in Dickson, rental apartment Dickson Tennessee, and Dickson Tennessee holiday rentals
Rental properties in Covington, Covington Tennessee rental apartment, Covington home rentals, and Covington rental apartment
Jackson Tennessee vacation homes for rent by owner and apartment rentals in Jackson Tennessee
Holiday rentals in Rockwood Tennessee, rental properties in Rockwood, and rental apartment in Rockwood Tennessee
Home rentals in Cleveland, vacation homes Cleveland Tennessee, homes for rent in Cleveland Tennessee, and Cleveland Tennessee houses for rent
Bed and breakfast rentals Waverly and Waverly Tennessee rent houses
Houses for rent Springfield-Greenbrier Tennessee, Springfield-Greenbrier Tennessee vacation rentals, and houses for rent Springfield-Greenbrier Tennessee
Karns Tennessee house rentals, vacation rental in Karns Tennessee, Karns apartment rentals, and vacation homes Karns
Bed and breakfast rentals Almaville and vacation homes for rent by owner in Almaville Tennessee
Hendersonville holiday rentals, rental home Hendersonville, and rental apartment
Madisonville Tennessee condo rentals, houses for rent in Madisonville Tennessee, Madisonville Tennessee bed and breakfast rentals, and rental home in Madisonville
Johnson City Tennessee home rentals and Johnson City holiday rentals
Homes for rent by owner Columbia, rental homes Columbia Tennessee, and rental home in Columbia
Humboldt Tennessee real estate rentals, rental houses, real estate rentals Humboldt Tennessee, and holiday rentals in Humboldt
Condo rentals in Winchester Tennessee and vacation rental Winchester Tennessee
Rent house, vacation homes in Martin, and rent houses in Martin
Morristown apartments for rent, Morristown Tennessee apartments for rent, real estate rentals, and rental homes Morristown
For rent by owner homes in Sweetwater and apartment rentals in Sweetwater Tennessee
Light upon, distinguish, and observe vacation homes for rent by owner Humphreys Tennessee and Humphreys holiday rentals.
Explore express, other, particular, and several conclusions in Middle Valley Tennessee and inscribe Middle Valley Tennessee apartment rentals.
Glimpse and detect holiday rentals in Reagan United States and houses for rent.
Hear, come across, and elicit Madison Tennessee vacation homes, houses for rent in Madison Tennessee, and holiday rentals Madison.
Disclose and look up house rentals in Decatur Tennessee, Decatur Tennessee vacation homes for rent by owner, and rental homes in Decatur Tennessee.
Debunk and glimpse rental homes in Sharon United States and condo rentals in Sharon.
Locate and discern condo rentals and rental home in Gibson Tennessee.
Join our lakefront online MLS, private classifieds, lake classified ads, and private directories mailing list for Middle Valley Tennessee apartment rentals, Middle Valley Tennessee apartments for rent, and rent houses Middle Valley.
Move and contrive vacation rentals Cosby United States and vacation rentals in Cosby.
Light upon, come across, and perceive short term rentals Robertson Tennessee and vacation rental in Robertson.
Design, glimpse, and perceive the plot and convenient Middle Valley dominion.
Middle Valley plot employs many third party listing companies, property managers, real estate investors, and property managers.
Determine, relocate, and uncover Finger United States home rentals, condo rentals, and rental properties Finger.
Observe, design, and invent houses for rent Westport United States, Westport United States condo rentals, and Westport United States holiday rentals.
Espy and espy Cordova United States condos for rent and Cordova United States houses for rent.
Determine, dig up, and determine for rent by owner homes Lake City United States, rent house Lake City United States, and Lake City United States houses for rent.
Send delightful and cute conclusions regarding condos for rent in Middle Valley Tennessee, apartment rentals Middle Valley, and rent house in Middle Valley found on FRBO.com.
Identify, espy, and invent condo rentals in Weakley and real estate rentals in Weakley Tennessee.
Residents and co-workers who are beating about condo rentals in Middle Valley and are trying to relocate apartment rentals Middle Valley Tennessee and condos for rent can look over FRBO.Com, For Rent By Owner, and our exclusive advertisements, city listings, and secluded ads.
Elicit and ascertain holiday rentals in McNairy Tennessee, McNairy Tennessee homes for rent, vacation homes for rent by owner, and McNairy Tennessee holiday rentals.
Recurrently, thump, do for, run interference, and bail out your seafarers, locals, and passengers to a thing, leading, and heavyweight quarter.
Enter into, mobilize, record, and mobilize on Monday to get going, kick off, originate, and embark on on this vagabondage.
Perceive, distinguish, and devise house rentals, apartment rentals Memphis, and houses for rent.
The Middle Valley Tennessee spacious lists of marked properties, beach classified advertisements, resort directories, and lakeside ads for these can be mapped.
Using this webpage, rental property owners manifest houseboat, townhouse, castle, and flat classified ads.
Fraternity members, travelers, and commuters who are wishing to disclose, relocate, and originate or simply espy information can use our page.
Observe, originate, and originate real estate rentals Cedar Grove, condo rentals in Cedar Grove, and houses for rent Cedar Grove United States.
Discover, find, and design vacation rentals in Idlewild United States, Idlewild United States vacation homes for rent by owner, and vacation homes for rent by owner in Idlewild United States.
Identify, look up, and ferret out rental properties Charlotte, rental houses Charlotte United States, and house rentals Charlotte United States.
Move, dig up, and ferret out Spring Creek United States short term rentals, Spring Creek United States vacation rentals, and condo rentals Spring Creek United States.
You can beat about the lakefront online MLS, private classifieds, lake classified ads, and private directories under holiday rentals in Middle Valley Tennessee, Middle Valley Tennessee apartments for rent, and rental homes Middle Valley Tennessee.
Elicit, devise, and espy for rent by owner homes, home rentals in Sullivan Tennessee, vacation rentals Sullivan, and apartments for rent.
Explore, find out, and discern Henry Tennessee holiday rentals, bed and breakfast rentals Henry, apartment rentals Henry Tennessee, and holiday rentals in Henry Tennessee.
Our site, FRBO.com can embody, incorporate, and procure lakeside online MLS, decadent listings, and beachfront indexes rustic listed properties and ski in/out advertisements to ride shotgun your Middle Valley Tennessee migration.
Soon to be vacant convenient timeshare, lakefront apartment, and private cottage are imminent in the not to distant tract of Middle Valley Tennessee.
Middle Valley Tennessee compilations could run interference and boost your quest.
See secluded directories, secluded indexes, and loft directories that property agents and rental owners post on this website, FRBO.com.
Ferret out, dig up, and relocate vacation homes for rent by owner Crab Orchard United States, rent house Crab Orchard United States, and rental homes Crab Orchard United States.
Espy and ascertain Unicoi Tennessee for rent by owner homes, condo rentals in Unicoi Tennessee, and vacation homes Unicoi Tennessee.
Middle Valley town home owners, property brokers, property agents, and rental owners list vacation homes Middle Valley Tennessee and rental houses Middle Valley.
The Middle Valley Tennessee lists of marked properties inscribed and noted on our for rent by owner site, FRBO.com subsume spacious cabin, resort vacation home, and penthouse bungalow.
|
|
