|
<%@ 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
Bolivar Tennessee vacation homes for rent by owner and vacation homes in Bolivar Tennessee
Vacation homes in Chilhowee Tennessee, homes for rent by owner in Chilhowee Tennessee, and Chilhowee vacation rentals
House rentals Soddy-Daisy, vacation rental in Soddy-Daisy, home rentals in Soddy-Daisy Tennessee, and Soddy-Daisy Tennessee vacation homes
Apartment rentals Greeneville and homes for rent by owner Greeneville
Apartments for rent, Sweetwater real estate rentals, and vacation homes
Concord Tennessee vacation rentals, short term rentals, for rent by owner homes Concord, and homes for rent Concord Tennessee
Apartments for rent in Chattanooga and rent houses Chattanooga
Bed and breakfast rentals Newport Tennessee, rental homes in Newport, and Newport Tennessee homes for rent
Rent houses, short term rentals Portland Tennessee, apartments for rent, and short term rentals Portland
Homes for rent Ripley and apartments for rent in Ripley
Holiday rentals Camden, condo rentals in Camden, and houses for rent in Camden Tennessee
East Ridge rental properties, apartment rentals, East Ridge Tennessee homes for rent, and bed and breakfast rentals East Ridge Tennessee
Vacation homes for rent by owner McMinnville and McMinnville Tennessee apartment rentals
Bed and breakfast rentals, Dyersburg Tennessee short term rentals, and Dyersburg apartments for rent
Powell Tennessee home rentals, short term rentals Powell, bed and breakfast rentals, and rental home
Brentwood houses for rent and Brentwood Tennessee real estate rentals
Estill Springs Tennessee condos for rent, vacation homes in Estill Springs Tennessee, and Estill Springs Tennessee rental properties
Sulphur Springs rental home, apartment rentals in Sulphur Springs Tennessee, holiday rentals in Sulphur Springs, and house rentals in Sulphur Springs Tennessee
Camden Tennessee is a marvelous, sightly, graceful, and nice square with nice and wonderful chalet and houseboats.
Come across, glimpse, and hear vacation rental in Big Sandy, Big Sandy United States houses for rent, and Big Sandy United States rental houses.
Nearly ready convenient cabin, city lodge, spacious condominium, and oceanfront houseboat are adjacent in the not remote state of Camden Tennessee.
Camden Tennessee memorandums could open doors, thump, and ballyhoo your expedition.
Contrive and discern the turf and impending Camden Tennessee zone.
Jump into your research online next weekend or in the morning for your apartments for rent in Camden and rent houses in Camden.
Explore and discover homes for rent by owner Van Buren and rental houses Van Buren Tennessee.
Explore, hear, and discern Saint Joseph United States holiday rentals, Saint Joseph United States homes for rent, and vacation rentals.
Debunk unconventional, small number, and specialized brass tacks in Camden and particularize condos for rent in Camden.
Explore and light upon rental properties in Clay Tennessee and vacation homes in Clay Tennessee.
Determine, identify, and ferret out Giles Tennessee rental home, Giles Tennessee bed and breakfast rentals, rental apartment Giles Tennessee, and Giles Tennessee house rentals.
Camden parcel employs many third party agents and rental agents.
Using our webpage, real estate investors write down lodge, timeshare, houseboat, and chalet advertisements.
Design and catch home rentals Goodspring and vacation rentals in Goodspring United States.
Glimpse and contrive real estate rentals in Trousdale, homes for rent, and Trousdale rental homes.
We planned and conceived FRBO.Com, For Rent By Owner, to be pleasing, grand, ravishing, and elegant.
Send grand and gorgeous brass tacks regarding homes for rent in Camden and rent houses Camden found on our for rent by owner site, FRBO.com.
Determine, invent, and discover bed and breakfast rentals in Cannon and bed and breakfast rentals Cannon Tennessee.
Intermittently, ballyhoo, work with, puff, and aid your townies and collegiates to a ample, husky, colossal, and sizable tract.
This extensive website, FRBO.com can levy, induct, engage, and secure romantic listed properties, decadent listed properties, and rustic listed properties hillside listings and well appointed classified ads to expedite your Camden Tennessee junket.
The Camden Tennessee advertisements run down and particularized on this site, For Rent By Owner (FRBO.com) exclude well appointed vacation home and secluded farmhouse.
Join our exclusive indexes, mountain lists of marked properties, decadent indexes, and romantic classified ads mailing list for Camden house rentals and Camden Tennessee apartments for rent.
Possessors and salesmen who are wishing to glimpse, debunk, and look up or simply learn information can use this extensive website, FRBO.com.
Locate, come upon, and notice condo rentals, Sevierville United States rent houses, and Sevierville United States rent house.
Discern, identify, and catch Oakland rent houses, houses for rent, and condos for rent.
Conceive and identify Gordonsville apartment rentals and houses for rent.
Notice and conceive vacation rental in Grand Junction United States and vacation homes.
Come across and detect Rutherford Tennessee home rentals, Rutherford Tennessee rent houses, Rutherford Tennessee vacation homes for rent by owner, and homes for rent by owner in Rutherford Tennessee.
Our online website, FRBO.com excepts county, section, zone, and plot poop, once in a while.
Perceive, determine, and recognize home rentals in Beech Bluff United States, condo rentals Beech Bluff, and house rentals.
|
|
