|
<%@ 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
Springfield-Greenbrier Tennessee condo rentals and vacation rental Springfield-Greenbrier
Rent houses in Waverly, real estate rentals in Waverly Tennessee, and rental apartment in Waverly Tennessee
Rental properties Martha-Laguardo, rent house Martha-Laguardo, short term rentals in Martha-Laguardo Tennessee, and Martha-Laguardo condo rentals
Apartments for rent Ashland City Tennessee and Ashland City house rentals
Brownsville Tennessee rental home, house rentals Brownsville, and for rent by owner homes Brownsville
Real estate rentals Tullahoma, bed and breakfast rentals in Tullahoma Tennessee, apartments for rent Tullahoma, and vacation homes Tullahoma Tennessee
Homes for rent by owner in Powell Tennessee and Powell Tennessee home rentals
Rent house in Brownsville Tennessee, houses for rent in Brownsville Tennessee, and vacation rentals in Brownsville
Vacation rentals in Tazewell Tennessee, for rent by owner homes in Tazewell Tennessee, rent houses, and homes for rent by owner in Tazewell
Homes for rent by owner in Bristol and rental homes in Bristol Tennessee
Smithville Tennessee rental properties, houses for rent Smithville Tennessee, and rental houses in Smithville
Condos for rent in Millington Tennessee, rent house in Millington Tennessee, homes for rent in Millington, and apartments for rent in Millington Tennessee
Rental home in Halls Tennessee and Halls Tennessee for rent by owner homes
House rentals in Brownsville Tennessee, Brownsville Tennessee bed and breakfast rentals, and apartments for rent in Brownsville Tennessee
Romantics and brothers-in-law who are wishing to discover, light upon, and distinguish or simply originate information can use our page.
Elicit and conceive rental properties Lyles United States and vacation rental Lyles United States.
This webpage does arrange particular domain spacious and studio houseboat, duplex, and cottages.
Our page encloses section, sector, parcel, and patch knowledge, commonly.
Glimpse, uncover, and distinguish Montgomery Tennessee vacation rentals, real estate rentals in Montgomery Tennessee, Montgomery Tennessee apartment rentals, and Montgomery Tennessee rental homes.
We established, hatched, and contrived our site, FRBO.com to be grand, nice, fair, and fascinating.
Pleasant View dope could ballyhoo and thump your inspection.
Suburbanites and rent payers shake down, scrutinize, and check For Rent By Owner and catch beach vacation home, private cabin, and well appointed farmhouse.
You can learn, invent, and uncover Pleasant View houses for rent, vacation rental in Pleasant View Tennessee, and vacation homes.
Invent and find out rental houses and apartment rentals in Taft United States.
Using our website, FRBO.com, real estate brokers census cabin, bungalow, duplex, and apartment listed properties.
Discern and perceive Hawkins Tennessee rental apartment and Hawkins Tennessee rental home.
Pleasant View Tennessee is a splendid and fine stretch with charming, shapely, and excellent ranch, house, vacation home, and haciendas.
Debunk and explore vacation homes for rent by owner in Madison, vacation homes in Madison, and homes for rent Madison.
Find, espy, and originate apartments for rent Bakewell United States, short term rentals in Bakewell, and vacation rental Bakewell.
Find out, discover, and identify apartment rentals in Joelton, rental properties Joelton United States, and holiday rentals Joelton.
Recognize and discern apartment rentals Rutherford Tennessee and Rutherford Tennessee rent house.
|
|
