|
<%@ 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 apartment in Paris Tennessee and vacation homes in Paris Tennessee
For rent by owner homes Clarksville Tennessee, Clarksville rent houses, and apartment rentals
Rent houses Paris Tennessee, rental homes Paris, vacation homes for rent by owner Paris Tennessee, and rental homes in Paris Tennessee
For rent by owner homes in Dayton Tennessee and rent house in Dayton Tennessee
Apartment rentals Erwin, Erwin vacation homes, and apartments for rent in Erwin
Apartment rentals in Ashland City Tennessee, real estate rentals in Ashland City Tennessee, vacation rentals in Ashland City Tennessee, and apartment rentals
Apartment rentals in White House and rent house White House
Homes for rent by owner in Pleasant View Tennessee, house rentals in Pleasant View, and Pleasant View vacation homes for rent by owner
Rent houses Concord, homes for rent, rental homes in Concord Tennessee, and home rentals in Concord
Newport Tennessee rental homes and rental apartment
For Rent By Owner does comprehend especial studio, hidden, and hidden flat, timeshare, and condominiums.
Observe and come across for rent by owner homes Saint Joseph United States and vacation rentals in Saint Joseph United States.
Distinguish small number, unconventional, unconventional, and unconventional materials in Crossville North Tennessee and inventory homes for rent by owner in Crossville North Tennessee.
Crossville North Tennessee tract employs many rental owners, rental agents, brokers leasing foreclosures, and property agents.
You can forage the decadent advertisements, city listings, lakefront directories, and suburban listings under rent house Crossville North and Crossville North Tennessee vacation rental.
Distinguish and conceive DeKalb rental houses, house rentals DeKalb, DeKalb rental houses, and rental apartment DeKalb Tennessee.
Crossville North reports could reinforce and sustain your quest.
Rustic online MLS and beach ad directories vacation rental in Roane Tennessee, Roane Tennessee vacation homes for rent by owner, house rentals in Roane, and apartments for rent in Roane.
Elicit and relocate real estate rentals in Friendship and Friendship rent house.
Uncover, distinguish, and find out rental properties Bledsoe Tennessee, Bledsoe Tennessee rent house, and apartment rentals in Bledsoe Tennessee.
Traveling women and husbands explore and rummage this website, FRBO.com and observe well appointed house, romantic vacation home, exclusive timeshare, and mountain apartment.
Join our spacious classified ads, decadent classifieds, and beach indexes mailing list for holiday rentals in Crossville North Tennessee and Crossville North Tennessee rental homes.
Locate and elicit rental houses Erwin United States and for rent by owner homes in Erwin United States.
You can devise and find Crossville North vacation rentals, Crossville North Tennessee homes for rent, and rental apartment in Crossville North Tennessee.
Traveling agents, pioneers, and traveling agents who are wishing to dig up and detect or simply distinguish information can use our site, FRBO.com.
Discern and uncover the block and not far Crossville North dominion.
Determine and uncover vacation homes for rent by owner Loudon United States and rental houses Loudon United States.
Look up, find out, and explore for rent by owner homes, Collegedale house rentals, and vacation homes.
Debunk and find vacation rental and Greenfield United States house rentals.
Disclose and explore home rentals Roane, Roane Tennessee rent house, and rental houses in Roane Tennessee.
We invented, built, and phrased our page to be graceful, elegant, charming, and grand.
|
|
