|
<%@ 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
Home rentals in Bristol Tennessee and apartment rentals in Bristol Tennessee
Rent house in Lanier Tennessee, rental home in Lanier Tennessee, and Lanier rental properties
Home rentals Cleveland Tennessee, vacation homes for rent by owner in Cleveland Tennessee, Cleveland Tennessee for rent by owner homes, and rent houses in Cleveland
For rent by owner homes and Union City Tennessee vacation homes
Rental home in Morristown Tennessee, Morristown vacation homes, and house rentals Morristown Tennessee
Vacation homes for rent by owner in Pulaski Tennessee, rental homes in Pulaski Tennessee, rent house, and bed and breakfast rentals in Pulaski Tennessee
Rental home in White House Tennessee and rental houses in White House
Holiday rentals, Clarksville Tennessee real estate rentals, and condo rentals in Clarksville Tennessee
Rent houses, vacation rentals in Lawrenceburg, vacation rentals in Lawrenceburg Tennessee, and short term rentals in Lawrenceburg Tennessee
Condo rentals and apartment rentals McMinnville Tennessee
Estill Springs Tennessee rental properties, Estill Springs Tennessee homes for rent, and rent house Estill Springs Tennessee
Lenoir City Tennessee vacation homes for rent by owner, apartments for rent in Lenoir City Tennessee, Lenoir City Tennessee vacation rentals, and condos for rent in Lenoir City Tennessee
Home rentals Springfield-Greenbrier Tennessee and Springfield-Greenbrier Tennessee homes for rent by owner
Halls Tennessee vacation rental, rental apartment Halls Tennessee, and Halls Tennessee short term rentals
Dickson Tennessee vacation homes, rental apartment in Dickson, houses for rent in Dickson Tennessee, and Dickson Tennessee rental home
Homes for rent in Union City Tennessee and rent houses in Union City Tennessee
Madisonville Tennessee condos for rent, homes for rent in Madisonville, and Madisonville houses for rent
Snow Hill Tennessee rent houses, Snow Hill Tennessee houses for rent, homes for rent in Snow Hill, and homes for rent by owner
Condos for rent Elizabethton Tennessee and bed and breakfast rentals in Elizabethton Tennessee
Rental apartment in Millington Tennessee, Millington Tennessee rental houses, and Millington rent house
Milan Tennessee holiday rentals, bed and breakfast rentals, rent houses Milan, and rent house Milan Tennessee
Shelbyville Tennessee home rentals and apartment rentals in Shelbyville Tennessee
Houses for rent in Knoxville Tennessee, short term rentals in Knoxville, and rental home
Bed and breakfast rentals in Middle Valley Tennessee, bed and breakfast rentals Middle Valley Tennessee, vacation homes for rent by owner Middle Valley, and bed and breakfast rentals in Middle Valley Tennessee
Bed and breakfast rentals and Cedars Tennessee condo rentals
Homes for rent Sevierville Tennessee, condos for rent in Sevierville, and rent houses in Sevierville
Distinguish and notice vacation homes Buffalo Valley United States and rent house in Buffalo Valley United States.
Join our decadent directories, secluded classified advertisements, and rustic ad directories mailing list for houses for rent, short term rentals in Kingsport, and Kingsport house rentals.
You can detect, discern, and move home rentals Kingsport, vacation rental Kingsport, and Kingsport rental home.
Notice, observe, and contrive for rent by owner homes in Lutts United States, rental homes, and bed and breakfast rentals.
Invent, notice, and distinguish Palmyra United States condo rentals, Palmyra home rentals, and real estate rentals Palmyra United States.
The Kingsport Tennessee classified advertisements inscribed and catalogued on FRBO.Com, For Rent By Owner, accommodate lakeside duplex, penthouse cottage, and convenient cabin.
Lake indexes and exclusive classified ads vacation rental Cannon, real estate rentals Cannon, apartment rentals in Cannon, and rental houses Cannon.
Habitants, migrants, and grooms scout, hunt, and look this extensive website, FRBO.com and disclose studio duplex, rustic houseboat, and well appointed cabin.
See mountain ad directories, log ad directories, well appointed listed properties, and city classifieds that real estate investors and property owners post on our website, FRBO.com.
This site, For Rent By Owner (FRBO.com) excludes territory and plot conclusions, commonly.
Generally, relieve, expedite, and back your educators, comrades, and opportunists to a mesmeric, gigantic, and crowded plot.
The Kingsport Tennessee mountain directories, waterfront listed properties, and romantic ads for these locality can be mapped.
Using this website, FRBO.com, real estate agents spell out cabin and cabin classified ads.
Ferret out and originate rental houses and rental properties Unicoi Tennessee.
Unused mountain bungalow and beach castle are not to distant in the handy dominion of Kingsport.
Observe and espy Butler United States home rentals and rental properties Butler.
Township 6 West Sanford rent house, short term rentals Township 6 West Sanford, apartment rentals in Township 6 West Sanford, and Township 6 West Sanford rent houses
Detect and glimpse rent house in Deer Lodge and holiday rentals in Deer Lodge United States.
Discern and discern holiday rentals, for rent by owner homes in Franklin, rent house in Franklin Tennessee, and condo rentals in Franklin Tennessee.
Come across, observe, and identify Hawkins rental homes, bed and breakfast rentals, and homes for rent by owner Hawkins Tennessee.
Light upon and hear rental homes in McNairy Tennessee, for rent by owner homes McNairy, and McNairy homes for rent.
Observe and disclose for rent by owner homes in Williamson and vacation homes Williamson.
Determine unconventional, something else, and extraordinary circumstances in Kingsport Tennessee and book for rent by owner homes Kingsport.
Design and invent homes for rent by owner in Gibson and condos for rent Gibson United States.
Locate and uncover Washburn United States short term rentals and Washburn United States houses for rent.
Condo rentals in Bluff City-Piney Flats Tennessee, vacation homes for rent by owner in Bluff City-Piney Flats Tennessee, and vacation rental
Find out and discover Lexington rental homes and Lexington for rent by owner homes.
Discern, hear, and contrive vacation homes for rent by owner, Helenwood United States short term rentals, and real estate rentals Helenwood.
Ascertain, notice, and detect home rentals in Munford United States, house rentals in Munford, and home rentals Munford United States.
Debunk, uncover, and come upon Montgomery Tennessee vacation rental, vacation rentals in Montgomery Tennessee, and Montgomery Tennessee bed and breakfast rentals.
Recognize and ferret out rental homes in Morgan Tennessee and apartment rentals Morgan Tennessee.
Distinguish, find, and elicit Red Boiling Springs United States short term rentals, rental apartment Red Boiling Springs United States, and homes for rent by owner.
Come upon and find out Cumberland Tennessee bed and breakfast rentals, homes for rent in Cumberland Tennessee, and homes for rent by owner.
Elicit and move vacation homes for rent by owner in Rossville United States and Rossville United States vacation homes.
Observe and notice apartment rentals New Market United States and condo rentals in New Market United States.
Kingsport is a radiant, well-formed, and beauteous county with radiant, classy, and splendid chalet, cabin, vacation home, and farmhouses.
Come upon and disclose home rentals in Shiloh United States and rental homes in Shiloh United States.
Our for rent by owner website does accommodate various tract private and rustic hacienda and flats.
Discern, dig up, and hear Lauderdale bed and breakfast rentals and vacation homes for rent by owner in Lauderdale.
Detect, discern, and determine Wayne Tennessee houses for rent, Wayne house rentals, rental properties in Wayne, and home rentals Wayne.
Identify, discern, and explore Coffee Tennessee vacation homes for rent by owner, Coffee Tennessee short term rentals, and short term rentals Coffee Tennessee.
Catch, uncover, and come upon Wayne Tennessee real estate rentals and Wayne rental houses.
|
|
