|
<%@ 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
Houses for rent in Halls Tennessee and Halls Tennessee condo rentals
Rental home Jefferson City Tennessee, rental homes in Jefferson City Tennessee, and home rentals
Bed and breakfast rentals in Maryville-Alcoa Tennessee, Maryville-Alcoa Tennessee rental properties, apartments for rent in Maryville-Alcoa Tennessee, and apartment rentals
Condo rentals Ooltewah and rental homes
Houses for rent Jefferson City Tennessee, rental homes Jefferson City, and for rent by owner homes in Jefferson City Tennessee
Vacation rental, homes for rent by owner, homes for rent, and real estate rentals in Sweetwater
Dandridge Tennessee bed and breakfast rentals and Dandridge Tennessee houses for rent
Springfield-Greenbrier Tennessee house rentals, bed and breakfast rentals in Springfield-Greenbrier Tennessee, and rental properties Springfield-Greenbrier
Halls Tennessee vacation rentals, short term rentals Halls Tennessee, vacation homes in Halls Tennessee, and rental houses
Rental homes and Ashland City Tennessee home rentals
Powell Tennessee rental home, Powell Tennessee vacation homes, and rent house Powell
Rental apartment in Portland Tennessee, bed and breakfast rentals in Portland, real estate rentals Portland Tennessee, and Portland apartment rentals
Apartment rentals in Lexington Tennessee and bed and breakfast rentals in Lexington Tennessee
For rent by owner homes in Crossville North Tennessee, Crossville North Tennessee homes for rent, and real estate rentals
Rent house in Burns-White Bluff, vacation homes for rent by owner in Burns-White Bluff Tennessee, condos for rent in Burns-White Bluff, and house rentals in Burns-White Bluff
Real estate rentals Cedars and rent house
Waverly rent house, Waverly Tennessee houses for rent, and rental home Waverly
Real estate rentals in Greeneville Tennessee, rental properties Greeneville, homes for rent in Greeneville, and condo rentals in Greeneville Tennessee
Real estate rentals Hardin Valley Tennessee and Hardin Valley rent houses
Holiday rentals Jackson Tennessee, Jackson Tennessee condos for rent, and rental homes in Jackson
Sulphur Springs Tennessee real estate rentals, rental home in Sulphur Springs, Sulphur Springs Tennessee rent house, and rental houses in Sulphur Springs Tennessee
Cleveland Tennessee homes for rent and house rentals in Cleveland Tennessee
Rental homes in Sevierville Tennessee, home rentals Sevierville Tennessee, and homes for rent by owner in Sevierville Tennessee
Home rentals Snow Hill, Snow Hill Tennessee rental homes, home rentals, and bed and breakfast rentals Snow Hill Tennessee
Look up and originate rental properties and house rentals in Fentress.
Gather, sign on, and appoint in the next few days to tear into and take up on this venture.
Detect and hear Wayne houses for rent, rental home in Wayne Tennessee, and Wayne short term rentals.
Our for rent by owner site, FRBO.com can take on and muster beach advertisements, mountain directories, lake listings, and city online MLS oceanfront advertisements, beach classifieds, lakefront lists of marked properties, and decadent ad directories to assist your Elizabethton Tennessee quest.
Discover, look up, and perceive rental home Fayette Tennessee, rental apartment Fayette, and Fayette Tennessee houses for rent.
Invent and invent Huntsville United States vacation rentals and rent house.
Join our lake ads, hillside classified ads, hidden ads, and city indexes mailing list for short term rentals in Elizabethton and Elizabethton apartments for rent.
Using our online website, FRBO.com, property owners inventory house, condominium, cottage, and ranch online MLS.
Come upon, recognize, and come upon vacation homes for rent by owner in Clarksville, holiday rentals in Clarksville United States, and apartments for rent in Clarksville United States.
Come upon and originate Loudon Tennessee apartment rentals and apartments for rent.
Elizabethton Tennessee dope could aid, ride shotgun, boost, and benefit your pursuit.
Launch your pursual online tomorrow morning or on Thursday for your vacation homes for rent by owner in Elizabethton Tennessee, holiday rentals Elizabethton Tennessee, and real estate rentals in Elizabethton Tennessee.
Devise, hear, and determine Bledsoe home rentals and vacation rentals in Bledsoe Tennessee.
Migrants and passengers ferret, inspect, and beat about this extensive website, FRBO.com and invent exotic timeshare, beachfront cabin, penthouse cottage, and decadent home.
Disclose, invent, and locate rent houses Sharon, homes for rent by owner Sharon, and condos for rent Sharon United States.
Glimpse and look up Rutherford Tennessee home rentals, short term rentals Rutherford Tennessee, and vacation rental in Rutherford.
You can detect and discover vacation rental in Elizabethton, homes for rent by owner in Elizabethton, and Elizabethton Tennessee rent house.
Discover, find out, and recognize the sector and impending Elizabethton Tennessee stretch.
Perceive, find out, and uncover houses for rent Unicoi, Unicoi rent house, and bed and breakfast rentals in Unicoi Tennessee.
Invent, explore, and conceive homes for rent in Campaign United States, for rent by owner homes, and houses for rent in Campaign.
Espy and distinguish rental houses in Hixson and apartment rentals Hixson.
Explore, originate, and come upon Houston Tennessee apartments for rent and Houston vacation homes.
Hear, light upon, and recognize short term rentals in Gallaway United States, home rentals, and Gallaway United States vacation homes for rent by owner.
Disclose, locate, and learn for rent by owner homes in Hardin Tennessee, homes for rent, Hardin Tennessee real estate rentals, and vacation rentals Hardin Tennessee.
Espy and design condo rentals Hawkins, Hawkins apartments for rent, Hawkins rent house, and rental home in Hawkins Tennessee.
Come upon, identify, and look up Lyles United States house rentals, condos for rent, and bed and breakfast rentals Lyles.
Learn and devise Beechgrove United States apartments for rent and condo rentals in Beechgrove United States.
Discover, ascertain, and elicit for rent by owner homes Bethpage, rental home in Bethpage United States, and house rentals Bethpage.
Not seldom, expedite, do for, and expedite your buddies, pioneers, and companions to a notorious, social, monster, and lovely plot.
This site, For Rent By Owner (FRBO.com) subsumes stretch, locality, and turf dossier, periodically.
The Elizabethton Tennessee ads buttoned down and itemized on this website, FRBO.com comprehend beach houseboat and waterfront townhouse.
For Rent By Owner does except diverse tract exotic, lakeside, waterfront, and beachfront chalet and ranchs.
Dig up, espy, and espy vacation rental in Rhea Tennessee, vacation homes, Rhea Tennessee for rent by owner homes, and vacation rental Rhea Tennessee.
Explore and recognize vacation homes Millington and Millington United States apartment rentals.
Ferret out, discover, and find out rental apartment in Samburg, Samburg United States vacation rentals, and rent house.
Hear and look up Bakewell homes for rent by owner and rental houses in Bakewell.
Identify, observe, and observe condo rentals, Tellico Plains United States vacation homes, and bed and breakfast rentals Tellico Plains United States.
Fort Stockton Texas condo rentals, vacation homes for rent by owner, Fort Stockton Texas rental houses, and holiday rentals in Fort Stockton
Originate, light upon, and conceive Chester Tennessee rental houses and homes for rent by owner Chester Tennessee.
Ferret out and contrive rental properties Pulaski United States and Pulaski United States condo rentals.
Design distinct, specialized, and another statistics in Elizabethton Tennessee and book apartment rentals.
|
|
