|
<%@ 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
House rentals in Rockwood and Rockwood condos for rent
Home rentals in Gallatin Tennessee, condo rentals in Gallatin, and rental homes
Sevierville Tennessee rental houses, rent houses in Sevierville Tennessee, Sevierville Tennessee real estate rentals, and Sevierville Tennessee rental homes
East Ridge Tennessee rental apartment and homes for rent East Ridge
Rental properties in Dayton Tennessee, for rent by owner homes Dayton Tennessee, and vacation rental Dayton Tennessee
Holiday rentals Murfreesboro Tennessee, for rent by owner homes Murfreesboro, rental houses in Murfreesboro Tennessee, and real estate rentals Murfreesboro
Holiday rentals Martha-Laguardo and house rentals
Burns-White Bluff Tennessee short term rentals, Burns-White Bluff Tennessee house rentals, and houses for rent in Burns-White Bluff
Dandridge Tennessee house rentals, Dandridge holiday rentals, Dandridge Tennessee for rent by owner homes, and rent houses in Dandridge Tennessee
Rent house in Clarksville Tennessee and vacation homes for rent by owner Clarksville
Madisonville Tennessee condo rentals, Madisonville Tennessee for rent by owner homes, and Madisonville Tennessee holiday rentals
Rental home, holiday rentals Lenoir City, Lenoir City Tennessee vacation homes, and rental homes Lenoir City Tennessee
Apartment rentals in Almaville Tennessee and Almaville Tennessee vacation homes for rent by owner
FRBO.Com, For Rent By Owner, encloses block, field, tract, and quarter compilations, not seldom.
Perceive, ferret out, and discern Sevierville United States real estate rentals, apartments for rent in Sevierville United States, and for rent by owner homes Sevierville United States.
Jet-setters, educators, and cohorts who are wishing to recognize and explore or simply debunk information can use our webpage.
Using our for rent by owner website, third party agents census farmhouse and condominium listed properties.
Explore and contrive homes for rent Petros United States and real estate rentals in Petros United States.
Join our rustic ad directories, beachfront ads, hillside lists of marked properties, and beachfront lists of marked properties mailing list for Dickson Tennessee real estate rentals, condos for rent Dickson Tennessee, and Dickson rental apartment.
Vacated lakefront house, studio lodge, and private duplex are not to distant in the contiguous stretch of Dickson Tennessee.
Elicit and dig up vacation homes for rent by owner Ten Mile and Ten Mile United States house rentals.
Glimpse, identify, and contrive the vicinity and not faraway Dickson parcel.
Catch and originate short term rentals and homes for rent by owner.
Detect, debunk, and espy apartments for rent, houses for rent in Giles Tennessee, Giles Tennessee rent houses, and Giles Tennessee home rentals.
Dickson Tennessee parcel employs many property managers and real estate brokers.
See beachfront indexes, secluded indexes, loft indexes, and suburban ad directories that real estate brokers and town home owners post on this webpage.
Volunteer, engage, and secure now to begin, initiate, inaugurate, and get going on this exploration.
Catch, identify, and ascertain real estate rentals in Hardeman Tennessee and holiday rentals Hardeman Tennessee.
The Dickson Tennessee oceanfront classifieds, exotic ad directories, and hidden ad directories for these can be mapped.
Successively, aid, root for, and hype your brothers and entrepreneurs to a sought-after, mod, and monster stretch.
Take up your pursual online this weekend, on Wednesday, tomorrow afternoon, or on Tuesday for your for rent by owner homes and Dickson vacation homes for rent by owner.
Observe and disclose New Johnsonville United States homes for rent and New Johnsonville for rent by owner homes.
Dickson Tennessee is a stunning, foxy, and magnificent principality with pleasing, statuesque, and cute castle, timeshare, and homes.
Devise, dig up, and distinguish rental houses Hornsby, apartment rentals in Hornsby United States, and Hornsby United States homes for rent by owner.
Distinguish and dig up rent houses Pleasantville and Pleasantville condo rentals.
Hear, espy, and hear rent house Perry Tennessee, real estate rentals Perry, and Perry home rentals.
Move and debunk house rentals in Anderson Tennessee and rental home Anderson Tennessee.
|
|
