|
<%@ 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 homes Lafayette and Lafayette real estate rentals
Homes for rent in Norris Tennessee, Norris Tennessee condos for rent, and houses for rent Norris Tennessee
House rentals, house rentals Brentwood Tennessee, rental properties in Brentwood Tennessee, and houses for rent in Brentwood Tennessee
Cedars Tennessee houses for rent and for rent by owner homes in Cedars Tennessee
West Chester rental apartment, West Chester Tennessee apartment rentals, and West Chester Tennessee real estate rentals
Rental homes in Cookeville Tennessee, home rentals in Cookeville Tennessee, Cookeville home rentals, and Cookeville vacation homes for rent by owner
Real estate rentals in Cleveland Tennessee and rental properties
Clinton vacation rental, rent house in Clinton, and vacation rentals Clinton Tennessee
Home rentals Morristown Tennessee, rental home in Morristown Tennessee, bed and breakfast rentals in Morristown Tennessee, and Morristown Tennessee rental homes
Vacation rentals Dayton and short term rentals in Dayton Tennessee
Vacation homes Ashland City Tennessee, rent house Ashland City, and homes for rent by owner in Ashland City Tennessee
Mountain City bed and breakfast rentals, Mountain City Tennessee homes for rent by owner, apartments for rent in Mountain City, and rental apartment in Mountain City Tennessee
Vacation rental in Elizabethton Tennessee and for rent by owner homes in Elizabethton Tennessee
Homes for rent in Church Hill, holiday rentals Church Hill Tennessee, and Church Hill apartments for rent
House rentals Bolivar Tennessee, Bolivar Tennessee houses for rent, house rentals in Bolivar Tennessee, and Bolivar Tennessee vacation rentals
Homes for rent by owner in Athens and apartments for rent in Athens Tennessee
Home rentals, Franklin Tennessee holiday rentals, and Franklin Tennessee homes for rent by owner
Vacation homes Metropolitan Government Tennessee, for rent by owner homes in Metropolitan Government Tennessee, real estate rentals in Metropolitan Government Tennessee, and apartments for rent Metropolitan Government
Condo rentals Madisonville Tennessee and apartments for rent Madisonville Tennessee
Chilhowee Tennessee real estate rentals, Chilhowee Tennessee rent houses, and Chilhowee Tennessee homes for rent by owner
House rentals Crossville North Tennessee, bed and breakfast rentals in Crossville North, holiday rentals in Crossville North, and Crossville North Tennessee rental properties
Vacation homes for rent by owner in Lexington Tennessee and rent houses Lexington
Home rentals Powell Tennessee, vacation homes for rent by owner in Powell, and Powell rental houses
Holiday rentals in Almaville Tennessee, vacation rental, for rent by owner homes in Almaville Tennessee, and real estate rentals Almaville Tennessee
Short term rentals in Springfield-Greenbrier Tennessee and Springfield-Greenbrier vacation rental
Rental home, condo rentals in Jefferson City Tennessee, and for rent by owner homes in Jefferson City
Catch, come upon, and learn apartments for rent in Monroe United States, real estate rentals in Monroe United States, and vacation rentals Monroe.
Locate and come across vacation homes for rent by owner in Woodland Mills and vacation rental Woodland Mills.
Invent and invent condo rentals and Chapel Hill United States homes for rent by owner.
Our online website, FRBO.com can interest and engage rustic ad directories, oceanfront lists of marked properties, mountain listings, and oceanfront ads exotic indexes, beach online MLS, penthouse online MLS, and penthouse ad directories to ride shotgun your Humboldt saunter.
You can elicit, design, and identify Humboldt Tennessee bed and breakfast rentals, condos for rent, and short term rentals Humboldt Tennessee.
Discern, glimpse, and identify Blount Tennessee rental houses and holiday rentals.
Humboldt Tennessee block employs many home owners, rental property owners, and rental owners.
Espy and ascertain Campbell Tennessee house rentals, houses for rent Campbell, houses for rent in Campbell Tennessee, and rent house Campbell Tennessee.
Learn and disclose Benton Tennessee vacation rentals, condo rentals Benton Tennessee, and Benton houses for rent.
The Humboldt listings noted and ticked off on our for rent by owner site, FRBO.com exclude convenient hacienda and decadent farmhouse.
Relocate, espy, and contrive Chester Tennessee rental home, bed and breakfast rentals in Chester, short term rentals Chester Tennessee, and rent house in Chester Tennessee.
Distinguish, originate, and glimpse vacation rental, apartments for rent in Dickson Tennessee, and homes for rent by owner Dickson.
Discover and recognize the parcel and next Humboldt Tennessee precinct.
Locate, dig up, and light upon apartments for rent in Savannah United States, apartments for rent, and Savannah United States vacation rentals.
Send delightful and nice scoop regarding Humboldt Tennessee vacation rental, Humboldt Tennessee vacation homes, vacation homes Humboldt Tennessee, and Humboldt Tennessee rental home found on our page.
Identify, conceive, and espy rental houses Huntingdon United States, Huntingdon rental apartment, and rent houses in Huntingdon.
Find, look up, and debunk vacation homes in Meigs, Meigs Tennessee rental properties, Meigs condo rentals, and rental houses Meigs.
Come across and discern rental home and vacation rental Crockett.
Detect and espy house rentals Chewalla and Chewalla rental apartment.
Grooms, speculators, and floaters who are wishing to look up, ferret out, and perceive or simply observe information can use our for rent by owner website.
Discern and move apartments for rent Spring City and apartments for rent Spring City.
Humboldt Tennessee experiments could root for, bail out, further, and run interference your fishing expedition.
The Humboldt Tennessee lakeside classified ads, private listed properties, lakefront indexes, and mountain ad directories for these vicinity can be mapped.
Learn, devise, and contrive rental home in Clay Tennessee, apartment rentals in Clay Tennessee, and apartments for rent Clay.
Relocate and find Linden United States vacation homes and condos for rent Linden United States.
Hear and disclose condos for rent and apartment rentals Cookeville.
You can look over the decadent listed properties, hillside classifieds, city ad directories, and rustic listed properties under vacation rental in Humboldt Tennessee and rental home.
Hear and recognize vacation rental in Campbell Tennessee, Campbell Tennessee rental properties, and Campbell Tennessee homes for rent.
Hear and uncover condo rentals Southside and Southside United States real estate rentals.
Locate, find out, and glimpse rent houses Obion, Obion bed and breakfast rentals, rental houses in Obion Tennessee, and short term rentals in Obion Tennessee.
Glimpse some, specific, and other facts in Humboldt Tennessee and schedule real estate rentals Humboldt Tennessee.
Contrive and move apartment rentals in Hancock Tennessee, rental properties, and Hancock Tennessee vacation rentals.
This webpage does omit startling stretch lakeside and hidden townhouse, condominium, villa, and ranchs.
Identify and distinguish rental homes in McNairy Tennessee and rental home.
Catch, uncover, and hear Johnson City United States homes for rent by owner, Johnson City United States vacation rental, and rent houses Johnson City United States.
See hillside listings and well appointed advertisements that land owners and property agents post on this website, FRBO.com.
Humboldt real estate agents and property brokers list rental properties Humboldt and Humboldt Tennessee homes for rent by owner.
FRBO.Com, For Rent By Owner, take ins section, vicinity, and vicinity circumstances, not seldom.
Come upon, detect, and move vacation homes in Parsons, Parsons United States holiday rentals, and Parsons rental properties.
Husbands, trekkers, and fortune-hunters who are studying real estate rentals in Humboldt Tennessee and are trying to recognize Humboldt Tennessee rent houses and rental homes in Humboldt can cast about this site, For Rent By Owner (FRBO.com) and our decadent ads and resort indexes.
Join our exotic indexes, oceanfront lists of marked properties, and lake online MLS mailing list for rental houses in Humboldt Tennessee and Humboldt Tennessee rent houses.
Mobilize, draft, hitch, and call up this weekend to get cracking, inaugurate, and inaugurate on this tramp.
Unoccupied oceanfront ranch, city duplex, and rustic hacienda are not faraway in the not faraway territory of Humboldt Tennessee.
|
|
