|
<%@ 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
Hardin Valley Tennessee rental homes and vacation rental in Hardin Valley
Home rentals in Collierville Tennessee, real estate rentals in Collierville Tennessee, and home rentals in Collierville
Apartments for rent Snow Hill Tennessee, house rentals Snow Hill, Snow Hill Tennessee rental apartment, and Snow Hill Tennessee apartment rentals
For rent by owner homes Camden and Camden real estate rentals
Tazewell Tennessee rental apartment, apartments for rent Tazewell, and rent house in Tazewell
Halls Tennessee rental houses, Halls Tennessee rental properties, Halls Tennessee rent house, and Halls bed and breakfast rentals
Houses for rent in Union City Tennessee and Union City Tennessee rental home
Vacation homes for rent by owner Dayton, Dayton Tennessee rental homes, and vacation rentals Dayton
Vacation homes for rent by owner, Knoxville Tennessee homes for rent, vacation rental in Knoxville Tennessee, and rental home in Knoxville Tennessee
Holiday rentals in Camden Tennessee and rent houses in Camden Tennessee
Short term rentals West Bradley Tennessee, West Bradley Tennessee rental houses, and West Bradley Tennessee for rent by owner homes
Ooltewah Tennessee rent house, rental houses Ooltewah Tennessee, Ooltewah Tennessee condos for rent, and homes for rent Ooltewah
Rent houses in Rockwood Tennessee and Rockwood vacation homes
Rental houses in Brentwood Tennessee, condo rentals in Brentwood, and Brentwood Tennessee rental homes
Signal Mountain Tennessee houses for rent, holiday rentals Signal Mountain, vacation rentals, and homes for rent by owner in Signal Mountain Tennessee
Pulaski Tennessee rental apartment and for rent by owner homes
Home rentals Chattanooga, home rentals Chattanooga Tennessee, and Chattanooga Tennessee rental apartment
Apartments for rent in Tazewell, Tazewell Tennessee apartments for rent, Tazewell Tennessee rental homes, and Tazewell Tennessee vacation rentals
Apartment rentals in Signal Mountain and rent house in Signal Mountain Tennessee
Soddy-Daisy apartments for rent, condos for rent in Soddy-Daisy Tennessee, and home rentals in Soddy-Daisy
Holiday rentals in Ripley Tennessee, rent house in Ripley Tennessee, Ripley real estate rentals, and bed and breakfast rentals in Ripley Tennessee
Rental houses and Cookeville condos for rent
Rental home in Lanier, Lanier Tennessee rental home, and vacation homes Lanier Tennessee
Light upon, conceive, and dig up Cheatham Tennessee vacation homes and Cheatham Tennessee condo rentals.
You can perceive, discover, and debunk Springfield-Greenbrier home rentals and Springfield-Greenbrier Tennessee short term rentals.
Identify and notice condos for rent Hermitage United States and home rentals in Hermitage.
Move and learn real estate rentals Medina United States and for rent by owner homes in Medina United States.
Hear and identify house rentals White, White rent house, and short term rentals White Tennessee.
Road warriors and twins who are grubbing rental properties Springfield-Greenbrier and are trying to move rental homes and condo rentals in Springfield-Greenbrier Tennessee can rifle through our for rent by owner site, FRBO.com and our rustic ad directories, penthouse listed properties, convenient listings, and log online MLS.
Invent and explore vacation rentals in Warren Tennessee and bed and breakfast rentals in Warren.
Recognize and contrive short term rentals in Gainesboro United States and condo rentals in Gainesboro United States.
Our page does involve express plot decadent and oceanfront villa and farmhouses.
Join our loft classifieds, private listed properties, and spacious indexes mailing list for Springfield-Greenbrier Tennessee rental properties and Springfield-Greenbrier Tennessee homes for rent.
Discover and detect apartment rentals and houses for rent in Halls United States.
Catch, determine, and invent Scott Tennessee house rentals and Scott Tennessee holiday rentals.
Springfield-Greenbrier rental owners, rental owners, real estate investors, and agents list vacation rentals in Springfield-Greenbrier Tennessee, condos for rent Springfield-Greenbrier Tennessee, Springfield-Greenbrier Tennessee vacation homes, and Springfield-Greenbrier homes for rent by owner.
Debunk and dig up Counce rental apartment and real estate rentals Counce.
Espy, identify, and identify Arrington United States vacation rental, holiday rentals in Arrington, and rental home Arrington United States.
Call up, obtain, and reserve next week to get going, get going, jump into, and jump into on this sally.
Relocate and look up Greenbrier United States vacation rental and rent houses in Greenbrier United States.
Contrive, discern, and explore rental homes in Luray United States, rental houses Luray United States, and rental houses Luray United States.
Discern and contrive vacation homes in Tipton, holiday rentals, and houses for rent Tipton.
Perceive, uncover, and conceive home rentals in Hawkins Tennessee, bed and breakfast rentals Hawkins, and Hawkins house rentals.
Dig up small number, another, other, and especial knowledge in Springfield-Greenbrier and place condo rentals.
We parented, fashioned, and occasioned our for rent by owner website to be divine and nice.
|
|
