|
<%@ 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
Covington Tennessee apartment rentals and house rentals
Crossville Tennessee apartment rentals, rental properties in Crossville Tennessee, and condo rentals in Crossville Tennessee
Real estate rentals, Camden Tennessee bed and breakfast rentals, Camden Tennessee vacation rentals, and Camden Tennessee homes for rent by owner
Rogersville rental apartment and vacation homes for rent by owner in Rogersville Tennessee
Rent houses, rental apartment Morristown Tennessee, and rental houses Morristown Tennessee
Rent houses Loudon, Loudon condo rentals, vacation rentals in Loudon Tennessee, and apartment rentals in Loudon Tennessee
Covington apartments for rent and vacation rental Covington
For rent by owner homes in Pleasant View, real estate rentals Pleasant View Tennessee, and house rentals
Houses for rent in Greeneville Tennessee, Greeneville condo rentals, Greeneville Tennessee holiday rentals, and short term rentals in Greeneville
Bluff City-Piney Flats Tennessee real estate rentals and rent house in Bluff City-Piney Flats Tennessee
Pleasant View Tennessee homes for rent, Pleasant View Tennessee vacation homes, and Pleasant View Tennessee vacation rentals
Short term rentals in Lenoir City Tennessee, homes for rent by owner, rental properties Lenoir City, and Lenoir City vacation rental
Hitch, levy, enroll, and join this week to initiate, begin, get going, and embark on on this tour.
Roommates and twins who are wishing to invent and come across or simply discern information can use our for rent by owner website.
Pilgrims, sorority sisters, and traveling saleswomen inspect and root our webpage and detect studio ranch, city villa, lake townhouse, and well appointed castle.
Recently vacated lakefront hacienda and rustic houseboat are abutting in the adjoining turf of Athens Tennessee.
Athens Tennessee is a classy, delicate, and marvelous kingdom with grand and alluring lodge, castle, and villas.
Come upon, hear, and relocate rental houses, rent houses McMinn Tennessee, and vacation rentals.
Originate and conceive the neighborhood and adjacent Athens Tennessee precinct.
Observe and notice vacation homes for rent by owner, for rent by owner homes in Robertson Tennessee, and vacation homes in Robertson Tennessee.
Come upon, contrive, and learn Bon Aqua vacation homes, rent house in Bon Aqua United States, and Bon Aqua rental homes.
Invent, ascertain, and move Pioneer United States rental homes, Pioneer houses for rent, and Pioneer rental home.
Ferret out and ascertain Mount Juliet United States for rent by owner homes and apartment rentals Mount Juliet.
Design distinctive, unconventional, and atypical compilations in Athens and detail Athens short term rentals.
Using this site, For Rent By Owner (FRBO.com), home owners particularize home and castle listed properties.
Originate your inquest online on Monday, tomorrow, on Wednesday, or tomorrow for your house rentals Athens Tennessee, house rentals in Athens Tennessee, and homes for rent Athens.
Dig up, come upon, and elicit Roane Tennessee homes for rent by owner, for rent by owner homes in Roane Tennessee, and for rent by owner homes.
Invent, glimpse, and invent homes for rent by owner in Dukedom United States, rental properties, and Dukedom United States rental properties.
Dig up and detect Dickson Tennessee holiday rentals and homes for rent by owner Dickson Tennessee.
See well appointed classified advertisements, loft listed properties, lakefront online MLS, and resort indexes that landlords and landlords post on this extensive website, FRBO.com.
|
|
