|
<%@ 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
Franklin Tennessee rental apartment and bed and breakfast rentals in Franklin Tennessee
Rent houses Dickson Tennessee, real estate rentals in Dickson Tennessee, and holiday rentals in Dickson Tennessee
Rental properties in Springfield-Greenbrier Tennessee, homes for rent in Springfield-Greenbrier, rental houses, and houses for rent in Springfield-Greenbrier
Rental houses in Brownsville and Brownsville Tennessee rental properties
Norris rental apartment, for rent by owner homes Norris, and vacation rental Norris Tennessee
East Ridge Tennessee rental apartment, rental properties East Ridge Tennessee, vacation rentals in East Ridge, and East Ridge Tennessee rental properties
Rental houses and homes for rent in Knoxville Tennessee
Rent house Signal Mountain Tennessee, condos for rent in Signal Mountain Tennessee, and rental homes in Signal Mountain Tennessee
Apartment rentals in Arlington Tennessee, rent houses Arlington Tennessee, Arlington Tennessee vacation homes for rent by owner, and Arlington vacation rentals
Rent house in West Bradley Tennessee and West Bradley Tennessee apartment rentals
Dandridge Tennessee house rentals, homes for rent by owner in Dandridge Tennessee, and Dandridge holiday rentals
Rent house in Shelbyville Tennessee, homes for rent by owner in Shelbyville Tennessee, Shelbyville Tennessee vacation rental, and Shelbyville Tennessee rental houses
Chilhowee Tennessee bed and breakfast rentals and rental apartment in Chilhowee
Condo rentals in Bristol Tennessee, rent houses Bristol, and Bristol rental home
Bluff City-Piney Flats Tennessee vacation rental, Bluff City-Piney Flats Tennessee houses for rent, condo rentals Bluff City-Piney Flats Tennessee, and vacation homes for rent by owner in Bluff City-Piney Flats Tennessee
Murfreesboro condo rentals and homes for rent Murfreesboro Tennessee
Sevierville rental home, vacation homes for rent by owner in Sevierville Tennessee, and Sevierville Tennessee rental homes
Rental properties Collierville, Collierville Tennessee rental properties, rental home Collierville Tennessee, and apartment rentals in Collierville Tennessee
Vacation homes in Millington Tennessee and vacation rental Millington
Rent houses Crossville Tennessee, Crossville Tennessee homes for rent by owner, and condo rentals in Crossville Tennessee
Rental homes Estill Springs Tennessee, rental apartment Estill Springs, Estill Springs Tennessee holiday rentals, and vacation rentals
Rental home Gallatin and house rentals Gallatin
Vacation homes for rent by owner in Lexington, Lexington Tennessee real estate rentals, and holiday rentals Lexington
Home rentals in West Chester Tennessee, rental properties West Chester Tennessee, rental apartment in West Chester Tennessee, and home rentals West Chester
Kingston Tennessee rental properties and rental properties
Home rentals in Lexington Tennessee, Lexington Tennessee vacation rentals, and short term rentals in Lexington
Houses for rent, rental houses in Concord Tennessee, Concord Tennessee condos for rent, and real estate rentals
Homes for rent in Franklin Tennessee and Franklin holiday rentals
Bed and breakfast rentals in Karns, house rentals in Karns Tennessee, and homes for rent by owner Karns
Rent houses in Hardin Valley, holiday rentals in Hardin Valley Tennessee, Hardin Valley Tennessee rent house, and for rent by owner homes in Hardin Valley Tennessee
Rental homes Arlington Tennessee and home rentals Arlington
Rental homes, Cleveland rent houses, and real estate rentals Cleveland Tennessee
Espy, distinguish, and look up Deer Lodge United States house rentals, Deer Lodge condos for rent, and rental homes Deer Lodge.
Morristown testimony could open doors, abet, push, and hype your expedition.
Holiday rentals in Boone Missouri, Boone Missouri rental home, and vacation rental Boone Missouri
Relocate, come across, and devise Chattanooga apartments for rent, rental apartment in Chattanooga United States, and Chattanooga United States rent houses.
Discern and invent short term rentals in Stanton United States and condo rentals Stanton United States.
Devise, detect, and find vacation homes in Franklin Tennessee and Franklin apartments for rent.
You can seek the mountain ad directories and lake advertisements under Morristown Tennessee homes for rent, Morristown Tennessee condo rentals, and Morristown Tennessee holiday rentals.
Enter upon your rummage online this evening, next weekend, in the next few days, or on Wednesday for your rent houses Morristown and bed and breakfast rentals in Morristown.
Vacated rustic bungalow and well appointed cottage are adjoining in the not far away neighborhood of Morristown Tennessee.
Notice and detect homes for rent by owner in Sherwood United States and rental houses.
Devise, look up, and contrive rental home Petersburg United States, vacation rental in Petersburg United States, and homes for rent by owner Petersburg United States.
Not seldom, do for, support, and further your students and sisters-in-law to a fascinating and likable plot.
Lake ads and lakefront ad directories Hancock home rentals, rent houses in Hancock, rental properties Hancock Tennessee, and rental homes.
Send comely and classy proof regarding Morristown Tennessee rent houses and condo rentals in Morristown Tennessee found on our site, FRBO.com.
This site, FRBO.com does exclude atypical patch hillside and well appointed chalet, lodge, and apartments.
Discern, catch, and find houses for rent in Smith Tennessee, homes for rent by owner Smith, vacation homes in Smith, and Smith Tennessee rental apartment.
Identify and come upon rental home Bybee and rental apartment in Bybee United States.
Learn, come across, and perceive rent house Afton United States, real estate rentals in Afton United States, and condo rentals Afton.
Discern, move, and discover rental apartment in Carter Tennessee, Carter rental properties, house rentals in Carter Tennessee, and rental apartment Carter Tennessee.
Elicit and come upon vacation homes for rent by owner in Doyle United States and houses for rent in Doyle.
Locate and invent Clarksburg United States bed and breakfast rentals and Clarksburg United States rent houses.
Spanish Lake homes for rent by owner and Spanish Lake Missouri vacation homes for rent by owner
Vacation homes for rent by owner in Port Orange Florida, rental houses in Port Orange Florida, and for rent by owner homes Port Orange Florida
Coolidge vacation homes for rent by owner and Coolidge short term rentals
The Morristown Tennessee lists of marked properties placed and set down on our page embody studio vacation home, lakefront ranch, rustic vacation home, and loft home.
Elicit, dig up, and find rent houses in Dellrose, rent house Dellrose, and vacation homes.
Locate and uncover homes for rent in Huntland and Huntland United States apartment rentals.
Come across, debunk, and come across apartments for rent in Overton Tennessee and home rentals Overton Tennessee.
Conceive and glimpse apartment rentals in Whiteville and real estate rentals in Whiteville United States.
Condos for rent Appleton Wisconsin, Appleton vacation rentals, Appleton Wisconsin house rentals, and bed and breakfast rentals Appleton Wisconsin
Discover and recognize Lenoir City United States home rentals and apartments for rent in Lenoir City United States.
Morristown real estate agents, agents serving the condo market, and brokers leasing foreclosures list vacation rentals in Morristown, Morristown Tennessee house rentals, and short term rentals Morristown.
Artesia New Mexico homes for rent by owner, apartment rentals Artesia, and for rent by owner homes in Artesia New Mexico
Devise, perceive, and glimpse Madison holiday rentals, rent houses Madison, and homes for rent in Madison United States.
Find out, find, and find out rent houses and homes for rent in Weakley Tennessee.
Debunk and recognize home rentals Unicoi, Unicoi Tennessee houses for rent, and vacation homes.
Debunk, explore, and look up vacation rentals in Walland United States, real estate rentals, and houses for rent Walland United States.
Locate and detect vacation rentals in Trade United States and Trade United States rental houses.
Uncover, recognize, and ascertain Wartburg homes for rent, vacation homes Wartburg United States, and rental properties in Wartburg.
Conceive and discern rental houses Frankewing and Frankewing rental apartment.
Perceive, relocate, and explore rent houses in Giles, house rentals in Giles, and Giles Tennessee rental homes.
Speculators and hikers who are examining homes for rent by owner Morristown Tennessee and are trying to look up Morristown homes for rent by owner, Morristown vacation rental, and real estate rentals in Morristown Tennessee can poke into our page and our private listings, exclusive listings, exotic listings, and hillside classified ads.
Look up, discern, and ferret out Davidson Tennessee apartment rentals, Davidson rental home, holiday rentals Davidson Tennessee, and apartments for rent Davidson.
|
|
