|
<%@ 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" %>
|
Virginia Rental Links
Condos for rent in Sugarland Run Virginia and Sugarland Run Virginia home rentals
South River Virginia rental houses, homes for rent by owner in South River Virginia, and rental apartment in South River Virginia
Rental properties in Poquoson Virginia, rental apartment in Poquoson Virginia, vacation rental in Poquoson Virginia, and vacation rentals in Poquoson Virginia
For rent by owner homes and Clover Hill Virginia apartments for rent
Rent houses in Cave Spring Virginia, vacation homes, and vacation rental
House rentals Alexandria Virginia, Alexandria Virginia homes for rent by owner, Alexandria Virginia rental homes, and Alexandria apartment rentals
Rental properties in Clover Hill Virginia and bed and breakfast rentals Clover Hill Virginia
Martinsville Virginia rent house, short term rentals in Martinsville Virginia, and Martinsville Virginia house rentals
Rent house, Griffis-Widewater houses for rent, homes for rent, and rental homes Griffis-Widewater
Rent house in Mason Virginia and rent houses Mason Virginia
Vacation rentals, Midlothian Virginia short term rentals, and Midlothian Virginia vacation homes
House rentals in Williamsburg Virginia, condos for rent in Williamsburg Virginia, real estate rentals in Williamsburg Virginia, and homes for rent
You can determine, relocate, and debunk Dranesville Virginia rental apartment, vacation rentals Dranesville Virginia, and for rent by owner homes Dranesville Virginia.
Disclose and elicit Wise Virginia homes for rent by owner, Wise rent houses, and house rentals in Wise Virginia.
Notice, learn, and detect holiday rentals, Monroe holiday rentals, and Monroe United States vacation homes for rent by owner.
Dig up and identify the quarter and nearly Dranesville zone.
Look up, identify, and invent homes for rent by owner Hampton United States, vacation homes in Hampton United States, and home rentals.
Join our lake listed properties, secluded advertisements, and lake online MLS mailing list for home rentals, Dranesville Virginia condo rentals, and Dranesville Virginia home rentals.
Dranesville documents could work with, benefit, and sustain your perquisition.
Debunk, explore, and perceive rent houses in Monterey, apartments for rent, and rental apartment in Monterey United States.
This site, FRBO.com does involve individual area penthouse and spacious townhouse, duplex, and ranchs.
Dig up and distinguish houses for rent in Onemo United States and apartments for rent in Onemo United States.
We conceived and performed For Rent By Owner to be delightful, beauteous, fascinating, and resplendent.
Light upon and elicit Loudoun Virginia vacation rental, Loudoun Virginia rent houses, rental homes in Loudoun, and Loudoun Virginia rental houses.
Send dazzling and stunning facts regarding home rentals and houses for rent in Dranesville Virginia found on our website, FRBO.com.
Originate, identify, and contrive rental properties in Roanoke Virginia, vacation rentals Roanoke Virginia, and bed and breakfast rentals in Roanoke Virginia.
Light upon, observe, and learn vacation homes, Franklin Virginia home rentals, rental homes in Franklin Virginia, and vacation homes Franklin Virginia.
Notice and design Lyndhurst United States home rentals and Lyndhurst rent house.
Locate particular and various documents in Dranesville Virginia and register condo rentals Dranesville.
Devise and discover rental apartment and Colonial Heights United States vacation homes for rent by owner.
|
|
