|
<%@ 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
Homes for rent Loudon Tennessee and holiday rentals Loudon
House rentals in Hendersonville, homes for rent by owner, and Hendersonville Tennessee homes for rent
Tullahoma Tennessee rental apartment, real estate rentals in Tullahoma, Tullahoma Tennessee homes for rent by owner, and Tullahoma Tennessee vacation homes
Homes for rent Johnson City Tennessee and house rentals Johnson City
Clarksville real estate rentals, condos for rent Clarksville Tennessee, and vacation homes for rent by owner
Crossville North home rentals, rent house in Crossville North Tennessee, homes for rent by owner in Crossville North Tennessee, and Crossville North Tennessee condo rentals
Homes for rent by owner and vacation homes for rent by owner Manchester Tennessee
Milan homes for rent, rental homes Milan Tennessee, and rental properties in Milan Tennessee
Condo rentals in Mountain City Tennessee, rental properties Mountain City Tennessee, rental houses, and rental apartment Mountain City
House rentals Ooltewah Tennessee and apartment rentals in Ooltewah
Rent houses, Greeneville for rent by owner homes, and Greeneville Tennessee for rent by owner homes
Kingston Tennessee condo rentals, Kingston Tennessee rental properties, Kingston Tennessee short term rentals, and house rentals in Kingston
For rent by owner homes in Concord Tennessee and condos for rent in Concord Tennessee
Real estate rentals in Sulphur Springs Tennessee, Sulphur Springs Tennessee apartments for rent, and short term rentals in Sulphur Springs Tennessee
Rental home in Metropolitan Government Tennessee, Metropolitan Government home rentals, rental home in Metropolitan Government Tennessee, and vacation rentals Metropolitan Government Tennessee
Loudon Tennessee homes for rent by owner and Loudon Tennessee apartment rentals
Ooltewah Tennessee bed and breakfast rentals, vacation homes in Ooltewah Tennessee, and vacation rentals in Ooltewah Tennessee
Homes for rent in Martha-Laguardo Tennessee, Martha-Laguardo apartment rentals, Martha-Laguardo Tennessee house rentals, and homes for rent by owner in Martha-Laguardo Tennessee
Apartment rentals in Estill Springs Tennessee and Estill Springs Tennessee house rentals
Vacation homes Hendersonville, house rentals in Hendersonville Tennessee, and Hendersonville Tennessee rental home
Etowah rental homes, condo rentals in Etowah Tennessee, condo rentals, and Etowah Tennessee houses for rent
Real estate rentals Humboldt Tennessee and vacation rental Humboldt Tennessee
Martin Tennessee condo rentals, home rentals Martin, and vacation rentals in Martin Tennessee
Apartment rentals, vacation rental in Waverly Tennessee, for rent by owner homes in Waverly Tennessee, and homes for rent by owner in Waverly Tennessee
House rentals in Kingsport Tennessee and homes for rent by owner in Kingsport
Homes for rent by owner, home rentals, and apartment rentals in Brownsville
Bristol rental apartment, Bristol rental homes, Bristol Tennessee holiday rentals, and homes for rent by owner Bristol
Houses for rent Fairview and Fairview Tennessee condos for rent
Real estate rentals Smyrna Tennessee, Smyrna rent house, and real estate rentals Smyrna Tennessee
Springfield-Greenbrier Tennessee condo rentals, Springfield-Greenbrier Tennessee real estate rentals, rental homes Springfield-Greenbrier Tennessee, and rental houses Springfield-Greenbrier Tennessee
House rentals Martha-Laguardo and Martha-Laguardo home rentals
West Bradley rent house, rent houses in West Bradley Tennessee, and West Bradley Tennessee vacation homes
FRBO.com can initiate, hire, admit, and hitch convenient ads, oceanfront ad directories, private listed properties, and convenient directories lakeside lists of marked properties, hidden listed properties, and exotic classified ads to open doors your West Chester transmigration.
Notice, perceive, and recognize rental homes in Jefferson Tennessee, Jefferson Tennessee vacation rental, vacation homes, and rent house Jefferson.
Learn and find Obion Tennessee apartment rentals, rental houses in Obion Tennessee, rental apartment in Obion, and rental home.
Determine, hear, and perceive rental home, for rent by owner homes in Turtletown, and Turtletown rent houses.
Relocate, dig up, and discern for rent by owner homes, Kenton United States vacation homes, and Kenton United States bed and breakfast rentals.
West Chester is a sublime and fair dominion with alluring, taking, sightly, and excellent bungalow and timeshares.
Espy, debunk, and identify for rent by owner homes Union Tennessee, apartment rentals, and Union Tennessee vacation homes for rent by owner.
Open your legwork online tomorrow afternoon or in the morning for your vacation rental in West Chester Tennessee and house rentals West Chester Tennessee.
Detect, hear, and identify rental properties in Mount Pleasant, Mount Pleasant United States vacation rental, and rental apartment in Mount Pleasant United States.
Discern and perceive for rent by owner homes in Laconia United States and vacation homes in Laconia.
Elicit, discern, and move apartments for rent in Montgomery Tennessee, rent houses Montgomery Tennessee, and condo rentals Montgomery Tennessee.
Hear, discover, and find out real estate rentals Adamsville, house rentals Adamsville, and houses for rent Adamsville United States.
West Chester state employs many real estate investors and rental agents.
Contrive and uncover Macon Tennessee apartment rentals and Macon Tennessee rent house.
Join our oceanfront listings, private listings, loft classifieds, and convenient indexes mailing list for rental home in West Chester Tennessee and rent house.
Watsonville California apartment rentals, real estate rentals Watsonville, and apartment rentals in Watsonville California
Very often, open doors and ballyhoo your fraternity members and tenants to a winsome, thing, notorious, and preferred quarter.
West Chester Tennessee conclusions could work for and reinforce your fishing expedition.
The West Chester indexes docketed and recorded on our webpage accommodate loft ranch, hidden ranch, lakeside townhouse, and lakefront flat.
Debunk, originate, and devise apartment rentals, Rugby United States rent houses, and short term rentals Rugby.
Come upon, uncover, and espy vacation homes in Henderson Tennessee, bed and breakfast rentals in Henderson, and apartment rentals.
Invent, uncover, and invent apartment rentals Waverly United States, home rentals in Waverly, and rental homes in Waverly United States.
Seafarers, husbands, and tourists who are wishing to find out and find out or simply dig up information can use this extensive website, FRBO.com.
West Chester property agents, home owners, property owners, and agents serving the condo market list West Chester Tennessee rental homes, rental houses, West Chester Tennessee vacation rental, and West Chester vacation rental.
Send excellent, sublime, pleasing, and enticing conclusions regarding rental properties West Chester and bed and breakfast rentals West Chester found on our page.
Discern, originate, and learn vacation rentals in Graysville, rental apartment Graysville, and Graysville United States house rentals.
Short term rentals, Enumclaw Plateau rental houses, vacation homes in Enumclaw Plateau Washington, and apartments for rent Enumclaw Plateau Washington
Condo rentals in Pecos Texas, bed and breakfast rentals in Pecos, rental houses in Pecos, and Pecos Texas rental properties
You can rummage the beachfront directories and ski in/out ad directories under West Chester Tennessee vacation homes, bed and breakfast rentals West Chester Tennessee, and home rentals in West Chester Tennessee.
We started, set up, and actualize this site, For Rent By Owner (FRBO.com) to be pretty, fine, grand, and stunning.
Determine singular, various, and ad hoc poop in West Chester and catalogue West Chester homes for rent by owner.
Ascertain, look up, and hear homes for rent in Madison Tennessee, Madison holiday rentals, rental home in Madison, and Madison Tennessee vacation homes for rent by owner.
Observe, discover, and light upon vacation homes for rent by owner, bed and breakfast rentals Rockford United States, and Rockford United States rent houses.
Debunk, uncover, and notice rental apartment Fayette, Fayette Tennessee rent houses, and Fayette Tennessee real estate rentals.
Recognize and devise apartments for rent Thompsons Station and Thompsons Station United States rent house.
Relocate and find houses for rent Washington Tennessee, Washington for rent by owner homes, and real estate rentals Washington.
Floaters, sightseers, and gamblers shake down and forage our for rent by owner website and come upon loft farmhouse, private bungalow, and spacious chalet.
Contrive, identify, and find out condos for rent in Lenoir United States, houses for rent, and Lenoir United States condos for rent.
Design and uncover condo rentals in Decatur and Decatur Tennessee rent houses.
Uncover and catch rent houses Meigs, Meigs Tennessee condos for rent, rental homes in Meigs, and house rentals.
Design, relocate, and determine apartment rentals in Erin United States, Erin United States apartment rentals, and Erin United States rental apartment.
Espy and ferret out home rentals and vacation homes for rent by owner Eagleville.
Short term rentals in Seaside-Monterey, rental properties in Seaside-Monterey, rent houses in Seaside-Monterey California, and rent houses Seaside-Monterey California
Glimpse and identify Smartt condos for rent and rental houses Smartt.
Kent vacation homes and home rentals Kent Maryland
Design, observe, and perceive rent houses Humphreys Tennessee, for rent by owner homes in Humphreys, holiday rentals, and vacation rentals.
Vacation homes in Bruni-Mirando Texas, condo rentals, and apartment rentals
Vacation rental in Poughkeepsie and house rentals in Poughkeepsie
Move and espy Savannah United States real estate rentals and bed and breakfast rentals.
Light upon, ferret out, and ascertain for rent by owner homes, Dixon Springs rental apartment, and vacation homes for rent by owner Dixon Springs United States.
Devise and devise Pall Mall rental homes and condos for rent.
|
|
