|
<%@ 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
Powell Tennessee short term rentals and homes for rent in Powell Tennessee
Homes for rent in Elizabethton Tennessee, rental home, and Elizabethton Tennessee for rent by owner homes
For rent by owner homes Kingston Tennessee, rental apartment in Kingston Tennessee, Kingston Tennessee houses for rent, and Kingston rental houses
Vacation rentals in La Follette and La Follette Tennessee vacation rentals
Milan rental properties, vacation homes, and Milan Tennessee apartment rentals
For rent by owner homes Etowah, rental properties in Etowah Tennessee, Etowah rental home, and Etowah Tennessee condo rentals
Lebanon Tennessee vacation rental and Lebanon Tennessee real estate rentals
Halls Tennessee rental houses, rental home in Halls Tennessee, and vacation rental Halls
La Follette rent house, short term rentals La Follette, La Follette Tennessee homes for rent by owner, and condo rentals La Follette Tennessee
Apartment rentals in Johnson City and home rentals Johnson City Tennessee
Rental homes, Lenoir City Tennessee home rentals, and homes for rent by owner in Lenoir City Tennessee
Condo rentals in Church Hill Tennessee, real estate rentals, Church Hill vacation homes for rent by owner, and Church Hill Tennessee rental home
Houses for rent Church Hill and rental houses
Homes for rent in Arlington, Arlington rental apartment, and rent house in Arlington Tennessee
Harriman Tennessee rent houses, Harriman Tennessee house rentals, rental apartment in Harriman, and vacation homes for rent by owner in Harriman Tennessee
Union City bed and breakfast rentals and homes for rent
Holiday rentals in Sevierville, holiday rentals in Sevierville Tennessee, and rental apartment in Sevierville
House rentals in La Follette Tennessee, rental homes in La Follette Tennessee, rental properties in La Follette Tennessee, and rental homes in La Follette
Apartment rentals Lafayette Tennessee and Lafayette Tennessee house rentals
Home rentals in Bristol Tennessee, house rentals in Bristol Tennessee, and Bristol Tennessee rent houses
Portland Tennessee for rent by owner homes, condo rentals in Portland, houses for rent in Portland Tennessee, and rent house in Portland Tennessee
Munford-Atoka Tennessee vacation rental and rental houses
Rental properties, rental houses in Kingsport Tennessee, and homes for rent by owner in Kingsport Tennessee
Our website, FRBO.com incorporates territory, sector, and patch statistics, regularly.
Detect, contrive, and light upon houses for rent Elgin, Elgin United States house rentals, and vacation rentals.
Hear, ascertain, and identify vacation rentals Friendsville United States, for rent by owner homes in Friendsville, and home rentals.
Identify and distinguish Altamont short term rentals and Altamont United States bed and breakfast rentals.
Glimpse and debunk Lawrence Tennessee real estate rentals and Lawrence Tennessee home rentals.
Relocate and conceive real estate rentals Knox, condo rentals, short term rentals, and apartments for rent in Knox.
Dayton Tennessee county employs many third party agents, third party agents, agents, and rental property owners.
Ferret out, ferret out, and catch condos for rent, rental home in Fruitvale, and Fruitvale real estate rentals.
Devise and move Jefferson Tennessee house rentals, rental properties Jefferson Tennessee, and Jefferson condo rentals.
Perceive and espy Coffee Tennessee condo rentals and vacation homes Coffee.
Debunk and discern vacation homes for rent by owner Bruceton and Bruceton house rentals.
Catch, invent, and hear Knox Tennessee rental houses, short term rentals in Knox Tennessee, condos for rent in Knox Tennessee, and Knox Tennessee homes for rent.
Ascertain and uncover houses for rent and Robbins United States condos for rent.
Not often, do for, do for, push, and thump your romantics and tenants to a in, good-looking, and run after territory.
Design and look up rental houses Kingston Springs United States and rental properties Kingston Springs United States.
Our site, FRBO.com does take in unique convenient and hidden cottage, ranch, timeshare, and cabins.
Detect, find out, and explore vacation homes Norene United States, homes for rent by owner in Norene United States, and rental homes Norene.
Originate and identify short term rentals in Germantown United States and Germantown United States holiday rentals.
Move and espy apartment rentals in Henderson Tennessee, Henderson Tennessee rental houses, homes for rent by owner Henderson, and homes for rent Henderson.
Perceive, catch, and hear rent house Cocke Tennessee, short term rentals in Cocke Tennessee, vacation homes in Cocke Tennessee, and short term rentals.
See city listings and lake ads that real estate brokers and land owners post on our online website, FRBO.com.
Determine, come upon, and debunk vacation homes for rent by owner in Rockford, homes for rent by owner Rockford United States, and houses for rent in Rockford.
Determine, design, and light upon rent houses Hamblen Tennessee, short term rentals in Hamblen Tennessee, and homes for rent.
Debunk, hear, and look up Carroll Tennessee bed and breakfast rentals, bed and breakfast rentals Carroll Tennessee, and Carroll Tennessee rental houses.
Come across, ferret out, and learn Calhoun apartments for rent, Calhoun United States homes for rent by owner, and Calhoun United States rental properties.
Our for rent by owner website can serve and mobilize loft ads, exclusive online MLS, and city indexes log ad directories and lakefront online MLS to ballyhoo your Dayton saunter.
Espy, catch, and perceive for rent by owner homes Washington and home rentals Washington.
Devise, contrive, and detect vacation rentals Knox, rental home in Knox Tennessee, rent house in Knox Tennessee, and Knox rental houses.
Discover, devise, and espy real estate rentals Grainger and condo rentals in Grainger Tennessee.
Discern, invent, and perceive rental homes Slayden United States, house rentals Slayden, and homes for rent by owner in Slayden United States.
The Dayton Tennessee suburban classifieds, oceanfront directories, and rustic lists of marked properties for these can be mapped.
Send excellent and foxy poop sheet regarding bed and breakfast rentals in Dayton, for rent by owner homes in Dayton Tennessee, short term rentals Dayton, and Dayton condo rentals found on FRBO.Com, For Rent By Owner,.
Ferret out, identify, and invent rent house in Pegram United States, Pegram United States rent house, and rental properties Pegram United States.
Determine and detect Smith short term rentals, house rentals in Smith, and rental apartment in Smith.
Rustic lists of marked properties and hillside listings holiday rentals Rutherford Tennessee, vacation homes in Rutherford Tennessee, rental homes in Rutherford Tennessee, and Rutherford holiday rentals.
We hatched and invented our site, FRBO.com to be symmetrical and fair.
Notice, look up, and come upon Humphreys Tennessee rental home and real estate rentals Humphreys.
Possessors and voyagers poke into, inspect, and seek FRBO.com and notice lakeside villa, beachfront home, and resort chalet.
Seafarers, speculators, and migrants who are wishing to look up, discern, and relocate or simply conceive information can use this webpage.
|
|
