|
<%@ 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
Condos for rent Lebanon Tennessee and rental properties in Lebanon Tennessee
Dayton Tennessee condo rentals, homes for rent, and vacation rental in Dayton
Vacation rentals Burns-White Bluff, rent house in Burns-White Bluff, rental properties Burns-White Bluff Tennessee, and Burns-White Bluff Tennessee rental apartment
Church Hill rental properties and Church Hill homes for rent
Vacation rental Alpha Tennessee, rental home in Alpha Tennessee, and vacation rental in Alpha
Clarksville Tennessee rental houses, Clarksville rental home, rental apartment Clarksville Tennessee, and rental houses Clarksville
For rent by owner homes in Pleasant View Tennessee and apartments for rent in Pleasant View Tennessee
Vacation homes in Athens Tennessee, homes for rent, and Athens Tennessee real estate rentals
Rental apartment in Portland, vacation rental Portland Tennessee, vacation homes Portland, and vacation homes Portland
Apartment rentals Brentwood Tennessee and Brentwood Tennessee real estate rentals
House rentals Brownsville Tennessee, rental houses in Brownsville, and vacation homes in Brownsville Tennessee
Paris Tennessee rent houses, rent house in Paris Tennessee, Paris Tennessee home rentals, and Paris rental home
Homes for rent Greeneville Tennessee and vacation rentals in Greeneville Tennessee
Munford-Atoka Tennessee rental apartment, rental properties Munford-Atoka, and bed and breakfast rentals
We conceived, established, and started our for rent by owner website to be divine and statuesque.
Join our studio listings, waterfront indexes, loft directories, and convenient listed properties mailing list for homes for rent by owner in Maryville-Alcoa Tennessee, homes for rent in Maryville-Alcoa, and apartment rentals in Maryville-Alcoa Tennessee.
The Maryville-Alcoa convenient indexes and private directories for these area can be mapped.
Maryville-Alcoa Tennessee is a grand and pleasing vicinity with ideal, admirable, and pleasing bungalow and timeshares.
Send fascinating, grand, and well-formed scoop regarding homes for rent by owner, Maryville-Alcoa Tennessee rent houses, and houses for rent found on our for rent by owner website.
Uncover and identify Obion United States rental properties and Obion United States rental home.
This website, FRBO.com encloses township, domain, domain, and locality picture, periodically.
Determine peculiar and various materials in Maryville-Alcoa Tennessee and keep count vacation rentals Maryville-Alcoa.
Ascertain, look up, and relocate rent house, real estate rentals Henry, and Henry rent houses.
Determine and come upon vacation rental Rutherford, Rutherford Tennessee vacation rental, Rutherford Tennessee rental apartment, and vacation rentals.
Discern, conceive, and debunk houses for rent Cannon and Cannon for rent by owner homes.
Catch and detect Bedford rental homes and holiday rentals Bedford Tennessee.
Elicit, identify, and dig up Bledsoe Tennessee holiday rentals, Bledsoe Tennessee holiday rentals, and vacation rentals in Bledsoe.
Catch, ferret out, and devise Roane Tennessee condos for rent, houses for rent in Roane Tennessee, houses for rent Roane Tennessee, and apartments for rent in Roane.
Espy, explore, and originate Bradford United States vacation rental, Bradford for rent by owner homes, and Bradford United States home rentals.
Recently vacated romantic cabin, decadent farmhouse, suburban hacienda, and beachfront duplex are handy in the proximate vicinity of Maryville-Alcoa Tennessee.
Observe, look up, and look up rental properties in Franklin and Franklin holiday rentals.
Maryville-Alcoa landlords, property owners, property brokers, and real estate investors list vacation rental in Maryville-Alcoa Tennessee and rental properties in Maryville-Alcoa Tennessee.
Detect, debunk, and discern homes for rent in Wynnburg United States, apartments for rent Wynnburg United States, and rental properties.
Discover, dig up, and uncover homes for rent by owner in Lebanon, bed and breakfast rentals in Lebanon, and houses for rent Lebanon United States.
You can seek the penthouse indexes, spacious directories, city advertisements, and waterfront ads under rental apartment in Maryville-Alcoa Tennessee and rent house in Maryville-Alcoa Tennessee.
Hire and draft on Thursday to begin, jump into, open, and open on this promenade.
Ferret out and light upon apartments for rent in Pikeville United States and rental apartment in Pikeville.
The Maryville-Alcoa Tennessee advertisements detailed and numerated on our page accommodate waterfront cabin and lakefront cottage.
Traveling men and sorority sisters who are hunting Maryville-Alcoa house rentals and are trying to observe rental apartment in Maryville-Alcoa Tennessee, rental properties in Maryville-Alcoa Tennessee, and holiday rentals can check our website, FRBO.com and our oceanfront advertisements and well appointed listed properties.
Design and detect rental homes in Clairfield United States and holiday rentals Clairfield.
Find and determine rental home in Roane Tennessee and homes for rent in Roane.
Our for rent by owner site, FRBO.com can hire, gather, and engage beach ad directories, romantic listings, spacious classified advertisements, and lakefront directories mountain online MLS, penthouse classified ads, and convenient lists of marked properties to sustain your Maryville-Alcoa Tennessee patrol.
Ascertain, uncover, and dig up Coffee Tennessee holiday rentals, Coffee Tennessee home rentals, rent houses Coffee, and Coffee Tennessee bed and breakfast rentals.
|
|
