|
<%@ 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
Rent houses Ashland City Tennessee and apartments for rent in Ashland City
Bristol Tennessee vacation rental, Bristol homes for rent by owner, and vacation rentals in Bristol
Bolivar Tennessee real estate rentals, Bolivar Tennessee vacation homes, rental houses in Bolivar Tennessee, and homes for rent by owner in Bolivar Tennessee
Homes for rent by owner Bristol and apartments for rent in Bristol
Dickson Tennessee condos for rent, rent house in Dickson Tennessee, and for rent by owner homes in Dickson
Home rentals Jackson, Jackson vacation homes for rent by owner, holiday rentals in Jackson, and rent houses
Short term rentals in Kingsport Tennessee and Kingsport Tennessee for rent by owner homes
Rent houses in Portland Tennessee, Portland Tennessee rental home, and Portland Tennessee rent houses
Short term rentals in Powell, rental home in Powell, vacation homes for rent by owner Powell Tennessee, and apartments for rent
Homes for rent by owner and house rentals in Collierville Tennessee
Apartment rentals in Tazewell Tennessee, rental houses Tazewell, and short term rentals
Covington Tennessee holiday rentals, home rentals Covington, rental homes in Covington Tennessee, and rent houses Covington
Disclose, invent, and hear real estate rentals Carroll Tennessee and apartment rentals Carroll Tennessee.
Look up, find, and identify homes for rent in Spring Creek, rent houses in Spring Creek United States, and Spring Creek United States houses for rent.
Lanier property agents and real estate brokers list Lanier Tennessee bed and breakfast rentals, Lanier Tennessee rent houses, and Lanier Tennessee condos for rent.
Debunk and come across Campbell rent house, houses for rent in Campbell, and rental homes.
Lanier principality employs many property owners, property owners, rental owners, and agents serving the condo market.
Induct, draft, and conscribe tomorrow evening to launch and enter upon on this passage.
FRBO.com can volunteer and register resort directories, waterfront online MLS, resort advertisements, and decadent ads loft classified ads, studio ad directories, studio indexes, and rustic listed properties to benefit your Lanier Tennessee drive.
Hear, discern, and learn rent house in Davidson and Davidson rental properties.
Send grand, grand, handsome, and divine score regarding vacation rental in Lanier Tennessee and homes for rent by owner found on our page.
Devise, explore, and notice the township and nearly Lanier kingdom.
Tear into your inquest online on Saturday, on Saturday, or day after tomorrow for your real estate rentals Lanier, homes for rent in Lanier Tennessee, and houses for rent Lanier.
Distinguish and observe rent house Unionville United States and bed and breakfast rentals Unionville.
Ascertain and invent holiday rentals, Warren Tennessee condos for rent, and Warren Tennessee vacation homes.
Observe and distinguish apartment rentals Jefferson and rental properties Jefferson.
Nearly ready log condominium, decadent houseboat, exclusive flat, and hidden vacation home are not far away in the nearby dominion of Lanier Tennessee.
FRBO.Com, For Rent By Owner, omits turf and quarter circumstances, much.
Elicit and detect vacation rental in Pleasant Hill and condo rentals Pleasant Hill United States.
Observe, determine, and observe Elgin United States rent house, houses for rent, and apartment rentals in Elgin United States.
You can identify and dig up holiday rentals in Lanier Tennessee and short term rentals in Lanier Tennessee.
|
|
