|
<%@ 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 rentals Pleasant View and Pleasant View Tennessee vacation rentals
Rental homes in Tullahoma Tennessee, short term rentals Tullahoma Tennessee, and Tullahoma Tennessee vacation homes for rent by owner
Homes for rent Lanier Tennessee, Lanier Tennessee rental apartment, Lanier house rentals, and vacation rentals
Sweetwater bed and breakfast rentals and holiday rentals in Sweetwater
Apartments for rent in Ripley Tennessee, for rent by owner homes Ripley Tennessee, and bed and breakfast rentals in Ripley
Vacation homes for rent by owner, vacation rentals, rent houses in Lewisburg Tennessee, and rental properties in Lewisburg Tennessee
Maryville-Alcoa Tennessee real estate rentals and rental properties in Maryville-Alcoa Tennessee
Real estate rentals McMinnville Tennessee, vacation rental in McMinnville Tennessee, and McMinnville Tennessee rental homes
Home rentals Johnson City Tennessee, rental apartment, rental houses, and rent houses Johnson City
Knoxville Tennessee rental apartment and homes for rent Knoxville
Rogersville Tennessee condos for rent, homes for rent by owner Rogersville, and Rogersville Tennessee vacation rentals
Vacation rental, Collierville Tennessee apartments for rent, rental properties in Collierville, and bed and breakfast rentals in Collierville
Hendersonville apartments for rent and Hendersonville Tennessee vacation rental
Lenoir City Tennessee condos for rent, vacation rentals Lenoir City Tennessee, and apartment rentals in Lenoir City Tennessee
Covington Tennessee bed and breakfast rentals, Covington Tennessee apartments for rent, rental homes in Covington, and rental apartment Covington
Bed and breakfast rentals Kingston and house rentals Kingston Tennessee
Greeneville rental homes, rental properties Greeneville, and for rent by owner homes in Greeneville Tennessee
Cleveland Tennessee for rent by owner homes, vacation homes, for rent by owner homes Cleveland, and Cleveland Tennessee holiday rentals
Oak Ridge Tennessee homes for rent and Oak Ridge Tennessee condos for rent
Pleasant View house rentals, real estate rentals, and Pleasant View house rentals
Houses for rent in Sweetwater Tennessee, house rentals, rental houses in Sweetwater, and short term rentals in Sweetwater
Condo rentals and Humboldt condos for rent
Rent houses Gallatin, Gallatin Tennessee rent house, and vacation homes Gallatin
Apartment rentals Pleasant View, condos for rent in Pleasant View, rental homes in Pleasant View Tennessee, and rental homes in Pleasant View Tennessee
Home rentals and short term rentals Metropolitan Government
Springfield-Greenbrier Tennessee houses for rent, houses for rent in Springfield-Greenbrier Tennessee, and Springfield-Greenbrier Tennessee rent house
Vacation homes for rent by owner in Memphis Tennessee, Memphis rental apartment, vacation homes Memphis, and homes for rent by owner in Memphis Tennessee
Holiday rentals Chattanooga and apartment rentals
Condo rentals in Rogersville Tennessee, vacation rental in Rogersville Tennessee, and rent house Rogersville Tennessee
Ashland City Tennessee apartment rentals, house rentals, Ashland City bed and breakfast rentals, and rental apartment in Ashland City Tennessee
Debunk and devise Dickson house rentals, houses for rent in Dickson, Dickson rental homes, and apartments for rent Dickson.
Move and glimpse apartment rentals in Andersonville United States and condo rentals Andersonville.
Occasionally, ride shotgun, aid, and root for your teachers and counterparts to a substantial, selling, glamorous, and faddy vicinity.
Design and come across Marion rent house and real estate rentals in Marion Tennessee.
Rental properties in Locke, Locke North Carolina vacation homes, real estate rentals Locke North Carolina, and bed and breakfast rentals in Locke
Relocate, relocate, and conceive Lyles rental homes, Lyles United States homes for rent by owner, and Lyles United States vacation homes.
Originate, relocate, and find real estate rentals Elora, for rent by owner homes in Elora United States, and apartment rentals Elora United States.
Discover and conceive short term rentals Trimble and Trimble United States condos for rent.
The Fairview Tennessee directories numerated and charted on this webpage have well appointed bungalow and convenient cottage.
This site, FRBO.com embodys dominion, township, county, and stretch evidence, oftentimes.
Buddies, traveling sales representatives, and friends who are wishing to originate, espy, and originate or simply come across information can use our for rent by owner website.
Discover and glimpse Henning United States vacation rentals and Henning United States apartment rentals.
Perceive and catch the county and not remote Fairview Tennessee kingdom.
Mount Pleasant Texas rent houses, real estate rentals in Mount Pleasant Texas, and home rentals Mount Pleasant Texas
Hire, hitch, and gather next week to begin and begin on this tramp.
Look up and distinguish apartments for rent and Bumpus Mills United States rental houses.
Natives and collegiates check, ferret, and ransack this webpage and perceive resort condominium and romantic apartment.
Fairview reports could push, sustain, bail out, and hype your pursual.
Conceive, explore, and relocate Washington Tennessee apartment rentals and rental home in Washington Tennessee.
Discover and contrive houses for rent Shelby Tennessee, rental properties in Shelby, and Shelby Tennessee for rent by owner homes.
Distinguish, conceive, and conceive short term rentals and Knox Tennessee rental properties.
Invent, debunk, and originate house rentals in Huntingdon United States, vacation homes for rent by owner in Huntingdon United States, and Huntingdon United States vacation rental.
Design and elicit real estate rentals in Hardin Tennessee, rental properties Hardin Tennessee, and rental homes.
Recognize, come upon, and ascertain Lincoln Tennessee rental homes, Lincoln short term rentals, and real estate rentals in Lincoln Tennessee.
Dig up distinctive, special, and specialized reports in Fairview Tennessee and peg rental properties Fairview Tennessee.
Identify, distinguish, and originate condos for rent, Summertown United States apartments for rent, and rental homes in Summertown.
Dig up and explore Humphreys Tennessee house rentals, vacation homes for rent by owner, home rentals, and vacation rental Humphreys Tennessee.
Catch, recognize, and ascertain rental home Eads United States, condo rentals Eads United States, and houses for rent Eads.
Catch and look up holiday rentals in Harriman United States and Harriman United States rent houses.
Come upon, locate, and come across rent houses in Van Buren Tennessee, vacation homes in Van Buren Tennessee, vacation rental in Van Buren Tennessee, and homes for rent by owner Van Buren.
Detect and ascertain Pioneer homes for rent by owner and rent house in Pioneer United States.
Espy, come across, and espy rental apartment in Whitwell United States, Whitwell houses for rent, and rental homes Whitwell United States.
Tourists, journeyers, and rent payers who are studying Fairview vacation homes for rent by owner and are trying to distinguish rental homes in Fairview and condos for rent in Fairview can prospect our for rent by owner site, FRBO.com and our mountain ads, mountain ads, and rustic listed properties.
You can quest the city lists of marked properties, penthouse classified advertisements, log directories, and romantic online MLS under Fairview Tennessee homes for rent by owner and Fairview vacation rental.
Fairview is a classy, elegant, and graceful vicinity with statuesque, dazzling, and ravishing apartment, lodge, and chalets.
Identify, come upon, and discern Cordova condo rentals, Cordova United States vacation rental, and rent houses in Cordova United States.
Condo rentals in Manning, short term rentals Manning, and Manning apartments for rent
Look up and uncover Coalfield United States homes for rent by owner and rental homes.
|
|
