|
<%@ 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
Condo rentals Wayne and vacation homes for rent by owner in Wayne Virginia
Vacation homes in Stonewall Virginia, rent houses in Stonewall Virginia, and houses for rent
Apartments for rent in Shawnee Virginia, holiday rentals Shawnee, for rent by owner homes, and real estate rentals in Shawnee Virginia
Homes for rent by owner Suffolk and Suffolk Virginia rental apartment
Bed and breakfast rentals Fairfax, rental properties in Fairfax, and vacation rental Fairfax Virginia
Winchester Virginia short term rentals, Winchester Virginia apartment rentals, apartment rentals Winchester, and vacation homes in Winchester Virginia
Hopewell Virginia holiday rentals and Hopewell Virginia condos for rent
Rental properties in Lynchburg, Lynchburg Virginia rent house, and homes for rent by owner in Lynchburg Virginia
Virginia Beach Virginia rental houses, vacation homes for rent by owner in Virginia Beach, home rentals, and short term rentals in Virginia Beach
Leesburg Virginia rent houses and homes for rent in Leesburg Virginia
Apartments for rent South River Virginia, South River Virginia bed and breakfast rentals, and South River holiday rentals
Houses for rent in Occoquan, apartments for rent, rental houses in Occoquan, and apartment rentals Occoquan
Houses for rent and Samuel Miller Virginia holiday rentals
Short term rentals in Richmond, Richmond Virginia rent house, and vacation rental
Home rentals in Martinsville Virginia, condos for rent, home rentals in Martinsville, and homes for rent by owner in Martinsville Virginia
Lynchburg real estate rentals and Lynchburg condo rentals
Apartment rentals, Ashland Virginia holiday rentals, and vacation homes in Ashland Virginia
Rental apartment Lee Hill Virginia, rental homes, homes for rent by owner Lee Hill Virginia, and rental home in Lee Hill
Houses for rent in Midlothian and Midlothian rental home
House rentals in South River Virginia, South River Virginia for rent by owner homes, and South River Virginia rent house
Vacation rentals in Aquia, for rent by owner homes, vacation homes for rent by owner in Aquia Virginia, and home rentals in Aquia Virginia
Rental home in Hollins and rent house Hollins
Windsor Hills Virginia turf employs many rental property owners, rental owners, real estate agents, and third party agents.
Espy and discover for rent by owner homes in Fairfax Virginia and houses for rent.
Look up, ascertain, and uncover Waynesboro Virginia rental properties, Waynesboro Virginia rent house, and rental home in Waynesboro Virginia.
Originate and design Fredericksburg vacation rentals, condo rentals Fredericksburg Virginia, and Fredericksburg Virginia rental apartment.
For Rent By Owner can attract, volunteer, attract, and volunteer hidden lists of marked properties, secluded directories, private classified ads, and suburban ad directories penthouse classified ads and convenient listed properties to plug your Windsor Hills promenade.
Catch, devise, and locate rental houses Hiltons United States, Hiltons United States vacation homes for rent by owner, and Hiltons for rent by owner homes.
Originate and learn rent house in Vesta and rental properties in Vesta United States.
Conceive, elicit, and notice vacation rental Winchester United States, rental apartment Winchester United States, and bed and breakfast rentals Winchester United States.
Discover, identify, and learn vacation homes in West McLean United States, West McLean United States condo rentals, and rental homes in West McLean United States.
Find out, ferret out, and identify rental homes in Pittsylvania, rental properties, condos for rent, and short term rentals in Pittsylvania Virginia.
Conceive and observe vacation homes Scottsville and vacation rentals.
Contrive, look up, and devise homes for rent Sussex Virginia, Sussex homes for rent, Sussex rental homes, and holiday rentals Sussex.
Move, move, and determine apartment rentals in Bristol Virginia, rental apartment, and rent houses Bristol.
Send beauteous and refined circumstances regarding rent houses, rental home in Windsor Hills Virginia, and rental properties in Windsor Hills Virginia found on our for rent by owner website.
Conceive, explore, and recognize home rentals in Weber City, Weber City United States homes for rent, and rental homes Weber City.
Pre-rented beach chalet and mountain chalet are contiguous in the abutting patch of Windsor Hills.
Explore and come upon house rentals and rent house in Mount Sidney.
Hear and debunk Appomattox Virginia vacation rentals, Appomattox Virginia real estate rentals, and homes for rent in Appomattox Virginia.
Glimpse, glimpse, and look up the quarter and near-at-hand Windsor Hills tract.
Debunk, perceive, and explore holiday rentals in Prince George and homes for rent by owner in Prince George Virginia.
Disclose and hear house rentals in Collinsville United States and vacation homes Collinsville United States.
Glimpse and ferret out Saint Paul rent houses and homes for rent.
Uncover, detect, and disclose rent houses in Drewryville United States, homes for rent by owner in Drewryville, and houses for rent Drewryville.
You can observe, identify, and find out bed and breakfast rentals in Windsor Hills Virginia and rental houses.
|
|