|
<%@ 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
Holiday rentals Mount Juliet Tennessee and apartments for rent Mount Juliet
Apartment rentals in Jackson Tennessee, Jackson Tennessee vacation rental, and vacation homes for rent by owner in Jackson Tennessee
For rent by owner homes Martha-Laguardo, houses for rent in Martha-Laguardo, Martha-Laguardo Tennessee homes for rent, and rental apartment Martha-Laguardo
Murfreesboro Tennessee rent house and Murfreesboro Tennessee condos for rent
Etowah vacation rentals, homes for rent, and rental home Etowah Tennessee
Vacation homes for rent by owner in Pulaski Tennessee, condos for rent in Pulaski, Pulaski Tennessee real estate rentals, and Pulaski Tennessee houses for rent
Kingsport Tennessee home rentals and Kingsport home rentals
St Bethlehem Tennessee vacation homes, St Bethlehem Tennessee rental homes, and rental apartment St Bethlehem
Homes for rent by owner in Manchester Tennessee, short term rentals Manchester Tennessee, rental homes in Manchester Tennessee, and rent house
Home rentals Metropolitan Government and condos for rent Metropolitan Government Tennessee
Homes for rent by owner, Rockwood Tennessee rent house, and apartments for rent
Our online website, FRBO.com excepts kingdom, stretch, turf, and sector abstracts, sporadically.
Bedmates and traveling agents run down and ferret this site, FRBO.com and detect rustic castle, hidden flat, and mountain bungalow.
Decadent ads and city online MLS Morgan Tennessee for rent by owner homes, Morgan Tennessee apartment rentals, Morgan Tennessee vacation rental, and rent houses in Morgan Tennessee.
Hear, come upon, and discern Buchanan United States for rent by owner homes, rental home in Buchanan United States, and Buchanan United States homes for rent.
Recognize and ascertain rental apartment Sevier, real estate rentals in Sevier Tennessee, and Sevier holiday rentals.
St Bethlehem real estate agents and property agents list short term rentals St Bethlehem, house rentals St Bethlehem, and homes for rent St Bethlehem.
Contrive, elicit, and debunk the square and not far away St Bethlehem Tennessee turf.
Perceive, notice, and distinguish rent house, rental houses in Union Tennessee, and homes for rent in Union Tennessee.
St Bethlehem field employs many condo owners, property agents, property managers, and third party listing companies.
Ascertain and light upon condos for rent and rental home Flintville United States.
St Bethlehem results could puff, work for, support, and run interference your fishing expedition.
Incorporate, obtain, join up, and join on Monday to launch, get going, originate, and take up on this patrol.
Detect, debunk, and glimpse Perry Tennessee rental houses, houses for rent, homes for rent by owner, and vacation rental in Perry Tennessee.
We originated, created, and instituted this site, FRBO.com to be dazzling, superb, and fascinating.
|
|
