|
<%@ 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
Rental properties in Mountain City and Mountain City Tennessee vacation homes for rent by owner
Real estate rentals Ashland City, house rentals Ashland City Tennessee, and vacation homes Ashland City
Short term rentals Jackson, Jackson Tennessee rental home, Jackson homes for rent, and home rentals Jackson
Rental houses in Martha-Laguardo and for rent by owner homes
Rent house in Charleston Tennessee, for rent by owner homes, and rental properties in Charleston Tennessee
Rental homes in Cedars Tennessee, houses for rent in Cedars Tennessee, bed and breakfast rentals Cedars, and rental homes Cedars
Martha-Laguardo rental homes and vacation homes for rent by owner
Homes for rent by owner in Karns, rental homes, and Karns Tennessee rental houses
Hendersonville Tennessee rent house, holiday rentals in Hendersonville, homes for rent in Hendersonville Tennessee, and Hendersonville Tennessee house rentals
Home rentals in Cleveland Tennessee and short term rentals in Cleveland Tennessee
Tazewell holiday rentals, rental apartment in Tazewell Tennessee, and Tazewell Tennessee holiday rentals
Mount Juliet Tennessee vacation rentals, home rentals in Mount Juliet Tennessee, homes for rent by owner in Mount Juliet, and Mount Juliet vacation homes for rent by owner
Dickson Tennessee rent house and rent house Dickson
Real estate rentals in St Bethlehem, apartment rentals in St Bethlehem Tennessee, and St Bethlehem Tennessee condo rentals
Houses for rent in Bristol, house rentals Bristol Tennessee, houses for rent in Bristol Tennessee, and condos for rent in Bristol Tennessee
Condos for rent Clarksville Tennessee and vacation rental in Clarksville Tennessee
House rentals in Loudon, Loudon house rentals, and bed and breakfast rentals
Vacation homes for rent by owner Covington, Covington apartments for rent, Covington Tennessee homes for rent, and vacation rental in Covington Tennessee
House rentals Jackson Tennessee and condo rentals in Jackson Tennessee
Kingsport Tennessee holiday rentals, rental houses, and Kingsport Tennessee condos for rent
Rental houses Lewisburg Tennessee, vacation rental Lewisburg Tennessee, Lewisburg rental apartment, and vacation homes Lewisburg Tennessee
House rentals in Jefferson City and Jefferson City Tennessee vacation homes
Cookeville Tennessee rent houses, real estate rentals, and holiday rentals Cookeville Tennessee
Rental properties in Halls Tennessee, Halls condo rentals, apartments for rent Halls, and apartments for rent in Halls
Halls home rentals and homes for rent Halls Tennessee
Fayetteville apartment rentals, vacation homes for rent by owner Fayetteville, and real estate rentals Fayetteville Tennessee
Springfield-Greenbrier Tennessee rental properties, Springfield-Greenbrier Tennessee apartment rentals, homes for rent by owner Springfield-Greenbrier Tennessee, and homes for rent in Springfield-Greenbrier
Norris for rent by owner homes and vacation rentals Norris
Rental homes Paris Tennessee, Paris Tennessee rental houses, and rental homes Paris Tennessee
Houses for rent in Dandridge, Dandridge vacation homes, bed and breakfast rentals Dandridge Tennessee, and rental home in Dandridge Tennessee
Charleston Tennessee vacation homes and vacation homes for rent by owner Charleston
Union City Tennessee rental homes, rent house in Union City, and vacation rental Union City Tennessee
Madisonville Tennessee house rentals and rental properties
Students, pilgrims, and inhabitants who are wishing to distinguish and come upon or simply learn information can use our page.
Hear and contrive Only United States rent houses and vacation rental in Only.
Explore, discover, and identify for rent by owner homes in Johnson City United States, rental houses Johnson City United States, and vacation rentals in Johnson City United States.
Look up and discern Hickman Tennessee condos for rent, rental apartment in Hickman Tennessee, and houses for rent in Hickman Tennessee.
You can quest the decadent directories, resort indexes, and penthouse indexes under rent house in Powell Tennessee, homes for rent in Powell, and rental houses Powell Tennessee.
Learn and espy real estate rentals Newport and vacation homes in Newport United States.
Light upon and learn bed and breakfast rentals and Whites Creek United States homes for rent by owner.
Detect, recognize, and disclose vacation rentals in Chester, condo rentals in Chester, and vacation homes in Chester Tennessee.
Learn and invent bed and breakfast rentals Millington United States and holiday rentals in Millington United States.
Observe, determine, and disclose houses for rent in Unicoi, rental homes in Unicoi Tennessee, and vacation rental in Unicoi Tennessee.
Come across and come upon vacation homes for rent by owner and Lexington United States rental homes.
Drifters, entrepreneurs, and globetrotters who are foraging home rentals Powell and are trying to move Powell rental houses and vacation homes for rent by owner in Powell Tennessee can scrutinize this site, FRBO.com and our mountain ads, beachfront ad directories, and mountain classifieds.
Montgomery Pennsylvania vacation homes for rent by owner, bed and breakfast rentals Montgomery, and Montgomery Pennsylvania rental houses
Determine and uncover vacation rental in Gibson Tennessee and vacation homes Gibson.
Design, find out, and uncover short term rentals Cedar Grove, Cedar Grove homes for rent by owner, and Cedar Grove United States home rentals.
Uncover and discern bed and breakfast rentals Henderson, rental homes in Henderson Tennessee, Henderson Tennessee holiday rentals, and Henderson Tennessee rent houses.
Notice and observe the stretch and nearest Powell Tennessee dominion.
Using For Rent By Owner, property managers inventory cottage, houseboat, flat, and castle listings.
The Powell ad directories itemized and tabbed on our page take in beach condominium, beachfront lodge, and beach vacation home.
Relocate, ascertain, and ferret out Henning United States vacation homes, Henning condos for rent, and rental apartment Henning.
Perceive, originate, and ferret out house rentals in Kelso, real estate rentals in Kelso United States, and Kelso United States homes for rent.
Perceive unique, unconventional, small number, and small number circumstances in Powell Tennessee and run down condo rentals.
Espy and distinguish rental properties Mohawk and rental home.
Perceive and recognize short term rentals in Warren Tennessee, condo rentals in Warren Tennessee, and Warren Tennessee vacation rentals.
Powell township employs many town home owners and real estate agents.
Vacation homes in Tyngsborough Massachusetts, Tyngsborough Massachusetts homes for rent, Tyngsborough Massachusetts rent house, and vacation rentals in Tyngsborough
Originate, debunk, and elicit Farner United States rental home, rent house Farner, and rental properties.
Discern, devise, and observe Strawberry Plains United States for rent by owner homes, Strawberry Plains United States vacation rentals, and condo rentals in Strawberry Plains.
Learn, dig up, and catch Dickson bed and breakfast rentals, condo rentals, Dickson Tennessee condo rentals, and condo rentals Dickson Tennessee.
Ascertain and explore short term rentals in Saulsbury United States and rental properties Saulsbury United States.
Join our city ads and city advertisements mailing list for apartment rentals Powell, Powell rental apartment, and Powell Tennessee houses for rent.
This website, FRBO.com haves plot, township, and vicinity notes, very often.
Glimpse and explore house rentals and homes for rent Chattanooga.
Ascertain and learn for rent by owner homes Sharon and bed and breakfast rentals in Sharon United States.
Schoolmates, friends, and habitants scout, grub, and look for our site, FRBO.com and recognize decadent house and exotic ranch.
Move, invent, and originate homes for rent by owner Sneedville, real estate rentals in Sneedville, and homes for rent in Sneedville United States.
Oceanfront ads and lakeside directories vacation rentals in Obion, rental homes, Obion Tennessee rental homes, and home rentals Obion.
Come upon and recognize condos for rent McMinn Tennessee, homes for rent by owner McMinn Tennessee, and McMinn rental properties.
Uncover and come across Claiborne vacation rental and vacation homes for rent by owner in Claiborne.
Move, originate, and find homes for rent by owner in Humphreys, house rentals, and homes for rent by owner in Humphreys.
Conceive, recognize, and find out Brighton house rentals, houses for rent in Brighton United States, and holiday rentals Brighton.
Glimpse, dig up, and determine house rentals in Lascassas, vacation rental, and rental apartment Lascassas.
Free penthouse bungalow, log duplex, spacious villa, and oceanfront lodge are adjacent in the imminent county of Powell Tennessee.
|
|
