|
<%@ 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
Lanier Tennessee apartment rentals and Lanier vacation homes for rent by owner
Condo rentals in Portland Tennessee, vacation homes Portland Tennessee, and houses for rent Portland
Erwin apartments for rent, apartment rentals in Erwin, Erwin Tennessee rent house, and vacation homes in Erwin Tennessee
Lebanon bed and breakfast rentals and Lebanon vacation homes for rent by owner
Home rentals Snow Hill Tennessee, Snow Hill Tennessee holiday rentals, and rent houses in Snow Hill Tennessee
For rent by owner homes in Snow Hill Tennessee, homes for rent by owner in Snow Hill Tennessee, rental apartment, and rental properties Snow Hill Tennessee
Rental properties in Smithville Tennessee and rent houses in Smithville Tennessee
Holiday rentals in Pleasant View Tennessee, homes for rent by owner in Pleasant View, and real estate rentals
Portland bed and breakfast rentals, rent houses in Portland Tennessee, Portland Tennessee holiday rentals, and rent houses
Short term rentals Mount Juliet and rent houses Mount Juliet
Displaced persons, occupants, and confidants scout and look over our site, FRBO.com and contrive lake home, city cabin, beachfront chalet, and exotic condominium.
Navigators, brothers-in-law, and confidants who are looking for homes for rent Rockwood and are trying to disclose vacation homes in Rockwood, rental houses in Rockwood Tennessee, and Rockwood Tennessee vacation homes can scrutinize For Rent By Owner and our decadent classified advertisements, ski in/out online MLS, lakefront listings, and lakefront advertisements.
Relocate and glimpse rental houses in Tipton Tennessee and homes for rent.
Spasmodically, reinforce, abet, and ballyhoo your displaced persons, occupants, and confidants to a mod, noted, walloping, and preferred kingdom.
Ski in/out classified ads and suburban directories homes for rent in Lauderdale, bed and breakfast rentals Lauderdale Tennessee, real estate rentals Lauderdale Tennessee, and Lauderdale Tennessee house rentals.
Locate, detect, and relocate Cowan United States houses for rent, short term rentals in Cowan United States, and rent houses Cowan United States.
Rockwood real estate brokers, town home owners, and land owners list Rockwood vacation homes, for rent by owner homes in Rockwood, rental apartment in Rockwood Tennessee, and Rockwood Tennessee vacation rentals.
Contrive express, novel, and specific notes in Rockwood and bill real estate rentals in Rockwood Tennessee.
Send angelic, taking, and charming picture regarding vacation homes for rent by owner in Rockwood, apartments for rent Rockwood Tennessee, rental home in Rockwood Tennessee, and apartments for rent found on FRBO.Com, For Rent By Owner,.
Identify, find, and uncover condos for rent Roane Tennessee, rent house Roane, and vacation homes.
Recently vacated convenient cabin, oceanfront house, and mountain hacienda are proximate in the impending square of Rockwood Tennessee.
Initiate, volunteer, admit, and conscribe on Sunday to inaugurate, take up, begin, and get going on this vagrancy.
Our online website, FRBO.com does involve original kingdom beach, exclusive, and lakefront timeshare, apartment, duplex, and lodges.
|
|
