|
<%@ 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
Rental apartment Lee Hill and Lee Hill Virginia rent houses
Rental homes in Dranesville Virginia, vacation homes for rent by owner Dranesville, and short term rentals in Dranesville Virginia
Vacation rental Manassas Virginia, apartment rentals, Manassas Virginia houses for rent, and Manassas apartment rentals
Samuel Miller Virginia rental apartment and homes for rent Samuel Miller
Colonial Heights Virginia rent house, Colonial Heights Virginia rental homes, and Colonial Heights Virginia holiday rentals
Vacation homes for rent by owner Livingston Virginia, home rentals in Livingston Virginia, Livingston Virginia apartments for rent, and vacation homes for rent by owner Livingston
Condos for rent and Matoaca Virginia rent houses
South Anna rent houses, South Anna Virginia short term rentals, and homes for rent by owner in South Anna Virginia
Rental home, apartments for rent in Ashby Virginia, rental homes Ashby Virginia, and real estate rentals
Apartment rentals in Rock Hill and condo rentals in Rock Hill
Vacation rentals in Danville Virginia, apartments for rent Danville Virginia, and Danville Virginia rental apartment
Chickahominy Virginia vacation homes, vacation rentals Chickahominy Virginia, holiday rentals in Chickahominy Virginia, and vacation homes for rent by owner
Charlottesville Virginia condo rentals and house rentals
Vacation homes in Central Virginia, Central condo rentals, and Central rent houses
Vacation homes in Coles Virginia, houses for rent, apartment rentals in Coles Virginia, and rent houses in Coles Virginia
Rental apartment Ashland and Ashland real estate rentals
Bed and breakfast rentals in Petersburg, rental houses Petersburg Virginia, and apartment rentals
Danville Virginia vacation homes, Danville home rentals, house rentals in Danville, and Danville holiday rentals
Catch and distinguish Fairfax vacation homes for rent by owner and Fairfax Virginia condo rentals.
Relocate, invent, and recognize vacation rentals in Appomattox Virginia and Appomattox Virginia rental houses.
Romantic listings and hillside classified ads rental home in Pittsylvania, rent house Pittsylvania, bed and breakfast rentals Pittsylvania, and home rentals Pittsylvania Virginia.
Relocate and notice New Kent United States condo rentals and New Kent real estate rentals.
This site, For Rent By Owner (FRBO.com) does take in original well appointed, hillside, private, and hillside lodge, flat, cabin, and villas.
Originate and come across Nassawadox United States rent houses and holiday rentals in Nassawadox United States.
You can devise, dig up, and originate short term rentals in Livingston Virginia and holiday rentals in Livingston.
Identify and come across for rent by owner homes Goochland and Goochland United States vacation homes.
Recruit and incorporate on Thursday to launch, tear into, kick off, and lead off on this transit.
Livingston Virginia is a bewitching, statuesque, and pretty county with dazzling, charming, angelic, and fine duplex and duplexs.
Come across, hear, and discover Colonial Heights vacation rentals and Colonial Heights Virginia rent house.
Ascertain and discover vacation rentals in Washington Virginia, houses for rent, and Washington Virginia rental apartment.
Discover, dig up, and move Galax United States apartments for rent, real estate rentals in Galax United States, and rental properties Galax.
Observe sundry, distinct, and particular compilations in Livingston Virginia and inscribe vacation rentals Livingston.
Livingston property managers, agents, and real estate agents list rental properties in Livingston Virginia, homes for rent by owner Livingston Virginia, Livingston Virginia rent houses, and apartments for rent in Livingston Virginia.
Junketers and possessors who are wishing to design and ferret out or simply glimpse information can use this extensive website, FRBO.com.
Find and contrive homes for rent Farmville United States and Farmville United States holiday rentals.
Come upon and conceive Providence Forge United States holiday rentals and bed and breakfast rentals.
Join our exclusive online MLS and log ad directories mailing list for Livingston apartments for rent and home rentals in Livingston.
Move, find, and locate vacation rental in Pamplin United States, Pamplin vacation homes for rent by owner, and Pamplin United States rent houses.
Light upon and recognize apartments for rent, Amelia Virginia vacation homes for rent by owner, Amelia Virginia vacation homes, and Amelia Virginia rental apartment.
|
|
