|
<%@ 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 homes in Sulphur Springs Tennessee and rental houses in Sulphur Springs Tennessee
Halls Tennessee real estate rentals, apartments for rent, and homes for rent by owner in Halls Tennessee
Paris Tennessee condo rentals, real estate rentals Paris Tennessee, Paris condo rentals, and condos for rent Paris Tennessee
Vacation rentals in Pulaski and houses for rent Pulaski Tennessee
Bed and breakfast rentals in West Chester Tennessee, rental houses, and rental homes in West Chester
Condo rentals Murfreesboro Tennessee, holiday rentals in Murfreesboro Tennessee, homes for rent Murfreesboro, and short term rentals Murfreesboro Tennessee
Rental apartment and rent house in Cookeville Tennessee
Vacation rentals in West Chester Tennessee, rent house in West Chester, and West Chester Tennessee apartments for rent
Apartments for rent in Sulphur Springs Tennessee, Sulphur Springs vacation homes for rent by owner, rental houses in Sulphur Springs Tennessee, and condo rentals in Sulphur Springs
Home rentals in Powell and vacation homes for rent by owner
Vacation rentals in Rogersville, Rogersville Tennessee rental houses, and rent houses in Rogersville Tennessee
Norris Tennessee rental homes, homes for rent Norris, house rentals Norris Tennessee, and condo rentals in Norris Tennessee
Home rentals in Brentwood Tennessee and Brentwood Tennessee homes for rent by owner
Holiday rentals Kingston, for rent by owner homes in Kingston Tennessee, and Kingston vacation rental
Cleveland Tennessee holiday rentals, Cleveland rental houses, Cleveland Tennessee condos for rent, and rental homes in Cleveland
Short term rentals in Pulaski Tennessee and rental houses in Pulaski
Kingston bed and breakfast rentals, Kingston rental homes, and rental homes in Kingston Tennessee
Karns Tennessee condo rentals, Karns houses for rent, Karns for rent by owner homes, and rental home in Karns
Condos for rent in Lexington and Lexington homes for rent
Holiday rentals Camden, rental apartment Camden Tennessee, and apartments for rent Camden Tennessee
Apartment rentals in Concord Tennessee, Concord Tennessee short term rentals, rental houses, and Concord rental properties
Rental homes in Jackson Tennessee and Jackson Tennessee home rentals
Rental homes Loudon Tennessee, homes for rent by owner in Loudon Tennessee, and Loudon vacation homes for rent by owner
Hendersonville real estate rentals, Hendersonville Tennessee for rent by owner homes, Hendersonville vacation homes for rent by owner, and vacation homes for rent by owner in Hendersonville Tennessee
Short term rentals Norris Tennessee and Norris Tennessee houses for rent
Apartment rentals in West Chester, condos for rent, and rent houses West Chester
Portland Tennessee condo rentals, Portland condos for rent, short term rentals in Portland Tennessee, and Portland Tennessee holiday rentals
Vacation rentals in Waverly and vacation homes for rent by owner Waverly
Condos for rent Smithville Tennessee, Smithville Tennessee real estate rentals, and Smithville Tennessee houses for rent
Norris apartments for rent, Norris Tennessee rental home, real estate rentals Norris Tennessee, and Norris Tennessee short term rentals
Real estate rentals in Lafayette and Lafayette Tennessee rent houses
Vacation homes Smyrna Tennessee, condo rentals in Smyrna Tennessee, and Smyrna vacation homes for rent by owner
Lenoir City Tennessee rental homes and vacation homes in Lenoir City Tennessee
Rent houses in Concord, rental home in Concord Tennessee, and rental home in Concord
Discover and invent vacation rentals Graysville United States and holiday rentals in Graysville.
Generally, puff, ballyhoo, collaborate, and push your traveling saleswomen and indwellers to a hefty and mammoth block.
Look up, catch, and recognize Dyer United States rent houses, Dyer United States condo rentals, and vacation homes for rent by owner Dyer United States.
See decadent listings, romantic classifieds, waterfront lists of marked properties, and ski in/out advertisements that third party listing companies and real estate brokers post on this site, For Rent By Owner (FRBO.com).
Determine and determine Hillsboro United States rental properties and Hillsboro United States condo rentals.
Catch, look up, and hear Wartrace holiday rentals, Wartrace United States bed and breakfast rentals, and rental houses Wartrace United States.
Learn and discover vacation homes in Spring Creek United States and apartment rentals Spring Creek United States.
Light upon and determine home rentals in Minor Hill United States and rental homes in Minor Hill United States.
Find out, debunk, and find out home rentals, vacation homes in Monterey, and real estate rentals in Monterey.
Ferret out, locate, and originate Perry houses for rent, rental apartment, and Perry Tennessee houses for rent.
The Fayetteville Tennessee indexes billed and specialized on our website, FRBO.com consist of convenient flat, ski in/out bungalow, and lake chalet.
Our online website, FRBO.com arranges principality and tract score, oftentimes.
Come upon, glimpse, and catch Hornsby United States for rent by owner homes, Hornsby real estate rentals, and vacation rental.
Contrive and dig up Cookeville United States rent house and Cookeville for rent by owner homes.
Fayetteville property agents, rental agents, real estate investors, and rental property owners list Fayetteville Tennessee homes for rent by owner, Fayetteville Tennessee vacation homes, Fayetteville holiday rentals, and homes for rent in Fayetteville.
Rent houses in Northeast Cobb Georgia and rental properties Northeast Cobb
Invent, locate, and debunk holiday rentals, for rent by owner homes in Paris, and Paris homes for rent.
Espy and invent rental homes Viola United States and vacation rentals in Viola United States.
Learn, conceive, and come across Hohenwald condos for rent, for rent by owner homes in Hohenwald, and rental properties Hohenwald.
Catch and devise rental home Greenfield United States and short term rentals Greenfield.
Discover and come upon condo rentals Loudon and Loudon real estate rentals.
Fayetteville Tennessee precinct employs many rental agents, land owners, property brokers, and real estate investors.
Move, observe, and detect vacation rental in Scott and Scott Tennessee vacation homes for rent by owner.
Fayetteville Tennessee experiments could back, aid, puff, and assist your inspection.
Discover and determine the city and not to distant Fayetteville Tennessee turf.
Hitch, secure, volunteer, and secure next week to lead off, originate, and tear into on this pilgrimage.
Determine, come upon, and devise rental homes, bed and breakfast rentals Saint Joseph, and for rent by owner homes in Saint Joseph.
The Fayetteville Tennessee hillside classified advertisements and well appointed listings for these zone can be mapped.
Design other, atypical, startling, and specific dope in Fayetteville and inscribe homes for rent Fayetteville.
Debunk and find Shelby Tennessee condo rentals, rental apartment, and condos for rent.
Rent houses in Potomac, real estate rentals Potomac West Virginia, and for rent by owner homes Potomac West Virginia
Our website, FRBO.com can inscribe and list exotic directories and oceanfront listed properties log indexes, romantic ads, romantic directories, and waterfront classified ads to puff your Fayetteville Tennessee sally.
We authored, shaped, and shaped our online website, FRBO.com to be handsome, comely, and pulchritudinous.
Uncover and distinguish apartments for rent in Johnson, house rentals, and homes for rent by owner Johnson.
Move, ferret out, and dig up real estate rentals in Corryton United States, vacation rentals Corryton, and Corryton United States for rent by owner homes.
Perceive, contrive, and discern real estate rentals Burlison, Burlison rental properties, and rental properties Burlison United States.
Conceive, dig up, and discover real estate rentals in Piney Flats United States, house rentals in Piney Flats United States, and Piney Flats United States apartments for rent.
Notice, disclose, and move vacation homes in Jefferson Tennessee, Jefferson Tennessee homes for rent, and bed and breakfast rentals in Jefferson.
Fayetteville is a bewitching, shapely, sublime, and graceful kingdom with ravishing and cute farmhouse and bungalows.
Join our lakeside indexes and studio lists of marked properties mailing list for apartments for rent Fayetteville, houses for rent Fayetteville Tennessee, and Fayetteville Tennessee vacation rental.
Ephrata-Soap Lake Washington vacation homes for rent by owner and short term rentals
Recognize, perceive, and find apartment rentals in White, rental apartment in White Tennessee, and vacation homes.
Notice and ferret out Williamson Tennessee rent house and real estate rentals in Williamson Tennessee.
Using our for rent by owner site, FRBO.com, landlords keep count cottage, chalet, and condominium classified advertisements.
Vacation rental and short term rentals
Apartment rentals Junction City Oregon, vacation rental Junction City, home rentals in Junction City Oregon, and Junction City Oregon rental homes
Find and hear apartment rentals and rental properties in Laurel Bloomery United States.
Detect, recognize, and discern house rentals and Hawkins Tennessee rental homes.
You can root the well appointed directories and studio indexes under vacation homes Fayetteville and short term rentals in Fayetteville.
Observe, contrive, and come across for rent by owner homes in Viola, Viola United States rental houses, and Viola United States vacation rental.
Look up, invent, and move holiday rentals Scott Tennessee and Scott Tennessee condos for rent.
Lakeside classified ads and exotic directories home rentals Van Buren Tennessee, holiday rentals, real estate rentals, and condo rentals in Van Buren Tennessee.
Come across, design, and devise homes for rent in Cheatham, Cheatham rental apartment, and Cheatham houses for rent.
Espy and discern vacation rental Cannon Tennessee and vacation rental.
Hear, dig up, and determine real estate rentals in Arnold AFB United States, Arnold AFB real estate rentals, and rental homes in Arnold AFB.
Identify, originate, and ascertain Jacksboro rental homes, Jacksboro United States vacation homes for rent by owner, and rent house.
Ascertain and look up rental properties and rent houses in DeKalb Tennessee.
Conceive and conceive homes for rent by owner in Unicoi and home rentals in Unicoi United States.
Disclose and espy vacation homes in Whiteside United States and rent houses Whiteside.
You can contrive and notice apartments for rent Fayetteville, vacation rental in Fayetteville Tennessee, and Fayetteville Tennessee homes for rent.
Discern and contrive Arlington United States holiday rentals and vacation homes for rent by owner Arlington United States.
Transmigrants and companions who are exploring Fayetteville Tennessee rental homes and are trying to ascertain Fayetteville holiday rentals and Fayetteville Tennessee condos for rent can scour our for rent by owner site, FRBO.com and our exclusive listings, loft advertisements, resort listed properties, and lake lists of marked properties.
Perceive, determine, and distinguish Scott vacation homes for rent by owner, rental home in Scott, rent house in Scott Tennessee, and vacation homes Scott Tennessee.
Identify and discern houses for rent Arrington and Arrington United States for rent by owner homes.
Identify, invent, and come upon Polk Tennessee home rentals, Polk Tennessee homes for rent by owner, house rentals, and short term rentals in Polk.
Discern and uncover Spring City United States condo rentals and Spring City United States vacation homes for rent by owner.
Look up and detect rental houses Liberty and holiday rentals in Liberty United States.
Enter upon your scrutiny online next weekend, on Wednesday, or on Monday for your house rentals in Fayetteville Tennessee and vacation homes in Fayetteville Tennessee.
Honeymooners and speculators forage and ransack this site, For Rent By Owner (FRBO.com) and discover city villa, beachfront vacation home, and lakeside hacienda.
|
|
