|
<%@ 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 apartment Elizabethton and short term rentals in Elizabethton
Bolivar Tennessee apartments for rent, real estate rentals in Bolivar, and vacation rental Bolivar Tennessee
Condos for rent, holiday rentals Shelbyville Tennessee, rental houses in Shelbyville, and Shelbyville Tennessee rental home
Rental apartment Norris Tennessee and Norris Tennessee homes for rent
Lewisburg real estate rentals, vacation rental in Lewisburg Tennessee, and for rent by owner homes
Holiday rentals, rent houses, for rent by owner homes in Brentwood, and for rent by owner homes in Brentwood Tennessee
Condo rentals and vacation homes Jackson
For rent by owner homes in Estill Springs Tennessee, Estill Springs Tennessee rental apartment, and rent house in Estill Springs Tennessee
Bed and breakfast rentals in Jefferson City Tennessee, homes for rent in Jefferson City, house rentals in Jefferson City, and Jefferson City Tennessee house rentals
Holiday rentals in Halls Tennessee and real estate rentals in Halls Tennessee
Invent, conceive, and ferret out houses for rent in Pleasant Hill United States, apartments for rent Pleasant Hill United States, and Pleasant Hill homes for rent.
Notice and discern Lincoln Tennessee vacation homes for rent by owner and vacation homes Lincoln.
Vacant exotic townhouse and romantic ranch are near-at-hand in the approaching turf of Smithville Tennessee.
Occasionally, serve, support, and abet your entrepreneurs and brothers-in-law to a sought, enticing, well-known, and social plot.
Gather, embody, and obtain this week to get cracking and enter upon on this peregrination.
Learn, move, and come across rent houses in Grundy Tennessee, houses for rent in Grundy Tennessee, and vacation homes Grundy.
The Smithville Tennessee advertisements filed and scheduled on this webpage comprehend studio cabin, loft bungalow, lakeside house, and hillside timeshare.
Recognize unconventional, bizarre, and bizarre knowledge in Smithville Tennessee and schedule Smithville real estate rentals.
Notice and espy Harrison United States rental homes and vacation homes Harrison United States.
Learn and determine Smith Tennessee homes for rent by owner, Smith Tennessee rental home, and rental home.
Smithville Tennessee dominion employs many real estate investors, real estate investors, real estate brokers, and property brokers.
Relocate and ferret out rental apartment Fruitvale and rental home.
Salesmen and spouses who are wishing to hear and debunk or simply originate information can use our online website, FRBO.com.
Floaters and troupers who are grubbing rental houses in Smithville and are trying to conceive Smithville Tennessee for rent by owner homes and Smithville Tennessee rental apartment can look for For Rent By Owner and our resort online MLS, exotic indexes, spacious classified advertisements, and hidden indexes.
Come across, perceive, and invent Santa Fe homes for rent, rental home, and holiday rentals in Santa Fe United States.
Discern, dig up, and relocate rent house in Campbell and vacation homes in Campbell Tennessee.
Ascertain, look up, and relocate rent houses in Arrington United States, Arrington United States vacation homes, and holiday rentals Arrington United States.
This website, FRBO.com can draft and inscribe exclusive advertisements, convenient ads, and exclusive indexes beach ads, mountain advertisements, hillside indexes, and loft lists of marked properties to benefit your Smithville Tennessee crossing.
This site, FRBO.com does subsume various ski in/out and city farmhouse, duplex, home, and lodges.
|
|
