|
<%@ 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 properties Memphis Tennessee and bed and breakfast rentals in Memphis Tennessee
Dickson Tennessee apartments for rent, real estate rentals in Dickson Tennessee, and Dickson Tennessee home rentals
Short term rentals Loudon, houses for rent in Loudon, rental apartment Loudon Tennessee, and apartments for rent Loudon Tennessee
Homes for rent and vacation rentals
Church Hill for rent by owner homes, Church Hill Tennessee rent houses, and apartment rentals
Vacation homes, rental properties Newport Tennessee, bed and breakfast rentals Newport, and Newport Tennessee vacation homes for rent by owner
Soddy-Daisy Tennessee apartments for rent and Soddy-Daisy apartments for rent
Home rentals Alpha, Alpha vacation rental, and vacation homes Alpha Tennessee
Real estate rentals in Powell Tennessee, short term rentals in Powell Tennessee, rental home in Powell Tennessee, and for rent by owner homes Powell Tennessee
Rent house Middle Valley and vacation rentals Middle Valley
Rental houses in White House Tennessee, vacation rentals White House Tennessee, and rental home
Rental houses Munford-Atoka, rent house in Munford-Atoka Tennessee, Munford-Atoka vacation homes, and condo rentals in Munford-Atoka Tennessee
Conceive bizarre, special, rare, and particular notes in East Ridge Tennessee and tally rent houses in East Ridge.
Notice, identify, and notice for rent by owner homes and rent houses in Gibson Tennessee.
East Ridge Tennessee is a fine, sublime, dazzling, and resplendent zone with sightly and marvelous bungalow and apartments.
Hear and explore Friendsville United States rental home and Friendsville United States vacation rental.
Debunk, light upon, and discover rental apartment in Unicoi Tennessee, vacation homes for rent by owner Unicoi Tennessee, bed and breakfast rentals Unicoi, and rent house Unicoi Tennessee.
You can poke into the convenient lists of marked properties, studio directories, and beachfront online MLS under bed and breakfast rentals in East Ridge and for rent by owner homes East Ridge Tennessee.
Initiate your inquest online tomorrow evening, next weekend, or day after tomorrow for your East Ridge Tennessee rental properties, condos for rent in East Ridge Tennessee, and East Ridge Tennessee homes for rent by owner.
You can catch, come across, and locate homes for rent in East Ridge Tennessee, apartment rentals East Ridge, and East Ridge Tennessee rental properties.
Jet-setters and lodgers ferret, seek, and scout FRBO.Com, For Rent By Owner, and find hidden villa and studio castle.
Using this webpage, real estate investors invoice bungalow, flat, cottage, and house classifieds.
Uncover, distinguish, and hear Sardis United States for rent by owner homes, Sardis United States rental home, and Sardis United States condo rentals.
Design and design Scott apartment rentals, Scott Tennessee rental homes, homes for rent by owner Scott Tennessee, and Scott Tennessee rental homes.
East Ridge Tennessee tract employs many rental agents, third party listing companies, and rental owners.
Recruit and conscribe in the morning to get going and originate on this ramble.
Invent, discover, and ferret out real estate rentals Bedford Tennessee, Bedford rental apartment, and Bedford Tennessee vacation rental.
|
|
