|
<%@ 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 homes for rent by owner in Etowah and real estate rentals Etowah Tennessee
Short term rentals, rental apartment in Ooltewah Tennessee, and vacation homes for rent by owner Ooltewah Tennessee
Rental houses in Shelbyville Tennessee, Shelbyville Tennessee apartment rentals, Shelbyville rental houses, and Shelbyville Tennessee vacation homes for rent by owner
Vacation rental and for rent by owner homes Sevierville Tennessee
House rentals in Middle Valley Tennessee, Middle Valley rental properties, and homes for rent by owner
Rent house in Lenoir City Tennessee, home rentals Lenoir City, Lenoir City Tennessee vacation homes for rent by owner, and rent houses in Lenoir City Tennessee
Northeast Wilson Tennessee apartment rentals and rent house in Northeast Wilson Tennessee
Home rentals, homes for rent by owner, and Oak Ridge Tennessee bed and breakfast rentals
Rental homes in Rogersville, Rogersville Tennessee for rent by owner homes, Rogersville apartments for rent, and rental home Rogersville
For rent by owner homes in Halls Tennessee and bed and breakfast rentals in Halls Tennessee
Portland Tennessee rental houses, short term rentals in Portland Tennessee, and rental apartment Portland Tennessee
Jefferson City Tennessee homes for rent by owner, home rentals in Jefferson City Tennessee, condo rentals Jefferson City Tennessee, and Jefferson City Tennessee real estate rentals
Holiday rentals Sevierville and Sevierville real estate rentals
Fairview Tennessee for rent by owner homes, vacation homes for rent by owner Fairview Tennessee, and holiday rentals in Fairview Tennessee
Collierville rental home, real estate rentals in Collierville Tennessee, Collierville Tennessee apartments for rent, and bed and breakfast rentals Collierville
Vacation homes for rent by owner in Signal Mountain and Signal Mountain rental home
Murfreesboro Tennessee rental properties, Murfreesboro Tennessee vacation homes, and house rentals in Murfreesboro Tennessee
Greeneville Tennessee rent house, vacation homes Greeneville, Greeneville apartment rentals, and Greeneville condos for rent
Greeneville Tennessee for rent by owner homes and bed and breakfast rentals
Real estate rentals in Lenoir City, vacation rentals Lenoir City Tennessee, and for rent by owner homes in Lenoir City Tennessee
Greeneville Tennessee rental apartment, Greeneville Tennessee rental properties, homes for rent by owner in Greeneville Tennessee, and Greeneville Tennessee holiday rentals
For rent by owner homes in Dickson Tennessee and apartment rentals
Rent house, bed and breakfast rentals in West Chester, and rent house West Chester Tennessee
Catch and locate Bulls Gap United States rent house and Bulls Gap houses for rent.
Recently vacated romantic apartment, penthouse lodge, and private lodge are nearly in the adjoining square of Jackson Tennessee.
Observe, detect, and ferret out Hardin bed and breakfast rentals, condo rentals Hardin, rental homes in Hardin Tennessee, and rental homes.
Mountain directories and convenient indexes home rentals in Grundy, real estate rentals in Grundy Tennessee, Grundy Tennessee for rent by owner homes, and vacation rental in Grundy Tennessee.
Debunk, uncover, and explore Hawkins houses for rent and homes for rent in Hawkins Tennessee.
You can investigate the romantic listings, beachfront directories, lake ads, and resort ads under real estate rentals Jackson and home rentals in Jackson Tennessee.
Dig up and notice homes for rent Putnam and condo rentals in Putnam Tennessee.
Espy, perceive, and find out vacation rentals in Red Boiling Springs United States, Red Boiling Springs rent houses, and rental apartment.
Originate and ferret out holiday rentals, rent houses in Overton Tennessee, and holiday rentals in Overton Tennessee.
Disclose, learn, and disclose short term rentals, for rent by owner homes in Houston Tennessee, rental home Houston, and real estate rentals in Houston Tennessee.
Conceive, explore, and come across house rentals Jefferson City, vacation rental Jefferson City United States, and apartment rentals.
See loft indexes, oceanfront classified ads, and exotic classified ads that land owners and property owners post on our online website, FRBO.com.
Identify, move, and espy Sullivan Tennessee homes for rent and Sullivan Tennessee home rentals.
Join our lakefront lists of marked properties and oceanfront classified advertisements mailing list for Jackson Tennessee vacation rentals, holiday rentals in Jackson, and Jackson Tennessee homes for rent by owner.
Using our website, FRBO.com, land owners record bungalow, farmhouse, duplex, and houseboat classified ads.
You can come upon and design rental properties in Jackson and rent house Jackson Tennessee.
Jackson agents, land owners, and agents serving the condo market list rental properties Jackson Tennessee, rental apartment Jackson, Jackson homes for rent, and vacation homes Jackson.
Explore and observe condos for rent in Trimble and bed and breakfast rentals Trimble United States.
Identify, detect, and explore rental homes in Kyles Ford United States, Kyles Ford United States condo rentals, and condos for rent Kyles Ford United States.
Discern and identify condos for rent Monroe Tennessee and rental houses in Monroe.
Identify, light upon, and conceive vacation homes Blountville, condo rentals in Blountville United States, and apartments for rent.
FRBO.Com, For Rent By Owner, embodys territory, domain, kingdom, and kingdom proof, ever so often.
Hear and dig up home rentals in Greenback United States and apartments for rent in Greenback United States.
|
|
