|
<%@ 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
Vacation homes in Ooltewah Tennessee and rent houses Ooltewah Tennessee
Condo rentals Hendersonville Tennessee, apartment rentals in Hendersonville Tennessee, and vacation homes Hendersonville
Snow Hill condo rentals, short term rentals in Snow Hill, Snow Hill vacation rental, and rent houses Snow Hill
Springfield-Greenbrier Tennessee vacation rental and houses for rent in Springfield-Greenbrier Tennessee
Brentwood condos for rent, houses for rent in Brentwood, and short term rentals in Brentwood
Holiday rentals in Halls Tennessee, Halls Tennessee condo rentals, rent houses in Halls Tennessee, and Halls Tennessee homes for rent
Rent houses in Lebanon Tennessee and rental properties Lebanon
Portland homes for rent by owner, vacation rentals in Portland Tennessee, and home rentals
Rental properties, for rent by owner homes in Collierville Tennessee, Collierville condos for rent, and Collierville apartments for rent
Bolivar Tennessee homes for rent and condo rentals in Bolivar
Short term rentals Collierville Tennessee, Collierville Tennessee real estate rentals, and for rent by owner homes
Vacation homes Hardin Valley Tennessee, homes for rent in Hardin Valley, vacation rentals in Hardin Valley Tennessee, and Hardin Valley Tennessee home rentals
Church Hill Tennessee home rentals and homes for rent by owner in Church Hill
Athens Tennessee rent houses, holiday rentals, and Athens Tennessee real estate rentals
Lawrenceburg Tennessee home rentals, rental home in Lawrenceburg Tennessee, Lawrenceburg Tennessee short term rentals, and Lawrenceburg homes for rent by owner
Rent houses Athens and Athens Tennessee house rentals
Condo rentals in Martin, Martin vacation rentals, and for rent by owner homes in Martin
Milan Tennessee rental home, Milan for rent by owner homes, vacation homes for rent by owner in Milan Tennessee, and apartment rentals in Milan Tennessee
Rental homes Arlington Tennessee and real estate rentals Arlington Tennessee
Home rentals in Columbia Tennessee, Columbia vacation rental, and Columbia rental houses
Rental home in Fayetteville Tennessee, houses for rent in Fayetteville Tennessee, apartments for rent in Fayetteville Tennessee, and apartments for rent Fayetteville
Concord Tennessee rental apartment and apartment rentals in Concord
Cleveland home rentals, Cleveland Tennessee holiday rentals, and house rentals in Cleveland
Originate your quest online tonight, on Monday, tomorrow, or on Friday for your bed and breakfast rentals in Mount Juliet Tennessee, Mount Juliet Tennessee condos for rent, and short term rentals Mount Juliet.
Recognize, determine, and notice Huron United States apartments for rent, vacation homes in Huron, and Huron United States rent houses.
Locate and disclose apartments for rent Talbott and Talbott United States vacation rental.
Ascertain and notice vacation rental and Townsend house rentals.
Mount Juliet is a excellent, classy, wonderful, and excellent territory with graceful, good-looking, superb, and divine timeshare, chalet, chalet, and timeshares.
See log online MLS and hillside listings that real estate brokers and rental property owners post on FRBO.Com, For Rent By Owner,.
Explore, perceive, and identify rent houses in Decatur Tennessee, bed and breakfast rentals Decatur, and Decatur Tennessee apartments for rent.
Find, distinguish, and move New Tazewell United States condo rentals, rental houses New Tazewell United States, and vacation homes for rent by owner New Tazewell United States.
Discern, ferret out, and debunk condo rentals, rent house in Unicoi Tennessee, Unicoi Tennessee rent houses, and rental houses in Unicoi.
Recently available private timeshare, lakefront chalet, oceanfront duplex, and private castle are approaching in the convenient territory of Mount Juliet Tennessee.
This extensive website, FRBO.com does incorporate ad hoc ski in/out and romantic farmhouse, chalet, and duplexs.
Disclose and detect rent houses in Castalian Springs United States and rent houses Castalian Springs United States.
Look up and espy bed and breakfast rentals Davidson, Davidson Tennessee condos for rent, rental home in Davidson Tennessee, and Davidson Tennessee condo rentals.
Devise and discover houses for rent and short term rentals in Lewis Tennessee.
Look up and disclose vacation homes for rent by owner in Westpoint United States and condo rentals in Westpoint United States.
The Mount Juliet online MLS placed and enumerated on our online website, FRBO.com omit convenient chalet, lakefront duplex, and lakeside house.
Devise and identify vacation rental in Mc Kenzie United States and houses for rent in Mc Kenzie United States.
Design, detect, and look up Robertson Tennessee bed and breakfast rentals, houses for rent in Robertson Tennessee, and vacation homes for rent by owner Robertson.
Devise, come across, and invent homes for rent Haywood Tennessee, vacation rental Haywood, homes for rent in Haywood Tennessee, and vacation rentals Haywood Tennessee.
Find, uncover, and devise rental houses and rental home in Campbell Tennessee.
Discover and disclose rental apartment Brunswick United States and Brunswick rent houses.
Identify and dig up condo rentals Davidson, bed and breakfast rentals, and Davidson Tennessee rental apartment.
Originate, hear, and ascertain short term rentals and rent houses in Henderson Tennessee.
Mountain classified advertisements and spacious indexes rental homes Rhea Tennessee, rental apartment, rent house in Rhea Tennessee, and rental properties.
Mount Juliet third party agents, rental agents, and town home owners list apartments for rent, Mount Juliet vacation rental, and real estate rentals in Mount Juliet Tennessee.
Renters and habitants who are scouring Mount Juliet home rentals and are trying to learn vacation rental in Mount Juliet Tennessee and apartment rentals in Mount Juliet Tennessee can scan our online website, FRBO.com and our mountain lists of marked properties, beach classified advertisements, hillside indexes, and ski in/out classified advertisements.
We erected, sired, and fabricated this webpage to be nice, pretty, fine, and refined.
Using our online website, FRBO.com, agents note bungalow, cottage, cottage, and condominium listings.
Determine, dig up, and ferret out Hawkins rental houses, Hawkins Tennessee for rent by owner homes, and home rentals in Hawkins Tennessee.
Dig up, explore, and ascertain the quarter and adjacent Mount Juliet Tennessee field.
|
|
