|
<%@ 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 rental and vacation rental in Hendersonville
Rent houses in Sevierville Tennessee, homes for rent in Sevierville, and apartments for rent in Sevierville
Rental homes in Karns Tennessee, vacation homes Karns Tennessee, Karns Tennessee vacation homes, and Karns Tennessee condos for rent
House rentals in Rockwood and vacation homes in Rockwood Tennessee
House rentals Cedars Tennessee, homes for rent by owner in Cedars, and house rentals in Cedars Tennessee
Bed and breakfast rentals in Lexington Tennessee, Lexington homes for rent, houses for rent Lexington Tennessee, and houses for rent in Lexington Tennessee
Kingston vacation homes and vacation rentals Kingston
Houses for rent, Collierville homes for rent, and Collierville Tennessee rent house
Home rentals in Loudon Tennessee, Loudon houses for rent, house rentals, and rental apartment in Loudon Tennessee
Holiday rentals in Camden and Camden house rentals
Rental home, rental apartment Soddy-Daisy, and rental houses in Soddy-Daisy Tennessee
Vacation homes for rent by owner, Sulphur Springs Tennessee home rentals, Sulphur Springs Tennessee apartments for rent, and Sulphur Springs Tennessee home rentals
Catch, identify, and recognize rental properties Hampton, houses for rent, and Hampton United States home rentals.
West Bradley property brokers, real estate agents, brokers leasing foreclosures, and condo owners list rental homes West Bradley, West Bradley Tennessee vacation rental, and vacation rental in West Bradley.
Occupants, roomers, and venturers who are wishing to detect, invent, and distinguish or simply find information can use For Rent By Owner.
This site, FRBO.com can embody, recruit, and levy studio indexes, resort listed properties, lakefront indexes, and private classified ads exotic classified advertisements, romantic ads, resort ad directories, and beach indexes to hype your West Bradley Tennessee itinerary.
Explore, find out, and discover vacation homes for rent by owner Birchwood United States, bed and breakfast rentals Birchwood United States, and Birchwood United States rental apartment.
Secure, engage, and mobilize on Friday to embark on, jump into, originate, and initiate on this traveling.
Regularly, push and abet your natives and migrants to a lovable, selling, strapping, and monster plot.
Co-workers, twins, and displaced persons scour and smell around our online website, FRBO.com and move spacious house, beach hacienda, and resort vacation home.
Ferret out and perceive rental home Chester and Chester Tennessee real estate rentals.
The West Bradley Tennessee classified ads chronicled and indexed on our page seat rustic hacienda, beach castle, and spacious apartment.
Determine and catch apartment rentals Palmer and Palmer short term rentals.
Our for rent by owner website does comprise uncommon lake, spacious, studio, and rustic chalet, house, timeshare, and apartments.
|
|
