|
<%@ 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 Varina and Varina Virginia home rentals
Holiday rentals in Occoquan, Occoquan Virginia vacation homes, and home rentals in Occoquan Virginia
Rental homes Alexandria, Alexandria short term rentals, apartments for rent in Alexandria, and holiday rentals Alexandria
Sterling Virginia rental houses and vacation rental Sterling Virginia
Woodbridge rental homes, houses for rent in Woodbridge Virginia, and Woodbridge Virginia vacation rental
Short term rentals in Three Chopt, rent houses, Three Chopt Virginia homes for rent by owner, and rental home
Homes for rent by owner in Powhatan Virginia and Powhatan Virginia rental properties
Homes for rent by owner in Mason Virginia, Mason Virginia short term rentals, and Mason Virginia apartment rentals
Bland Virginia rental houses, homes for rent, Bland vacation rental, and for rent by owner homes in Bland
Apartments for rent in Scottsville Virginia and rental properties in Scottsville Virginia
Western homes for rent, for rent by owner homes Western Virginia, and for rent by owner homes in Western Virginia
Hollins Virginia vacation homes, Hollins Virginia rental properties, for rent by owner homes Hollins, and holiday rentals in Hollins Virginia
Petersburg Virginia holiday rentals and holiday rentals
Petersburg vacation rentals, Petersburg bed and breakfast rentals, and Petersburg Virginia condos for rent
Vacation rental, for rent by owner homes in Lynchburg, rental home in Lynchburg Virginia, and Lynchburg rent house
Houses for rent and Stonewall Virginia apartment rentals
Condos for rent in Martinsville Virginia, Martinsville Virginia rent houses, and real estate rentals in Martinsville
Three Chopt Virginia rental houses, rental apartment Three Chopt Virginia, condos for rent, and Three Chopt Virginia rental homes
Houses for rent Brentsville and Brentsville Virginia short term rentals
For rent by owner homes, houses for rent in Chancellor Virginia, and apartment rentals Chancellor Virginia
Inhabitants, explorers, and residers who are wishing to identify and notice or simply ferret out information can use this webpage.
Find, debunk, and conceive Essex Virginia rental houses, apartments for rent, and vacation rentals Essex.
Notice, conceive, and uncover apartments for rent, Washington Virginia rental homes, and homes for rent by owner in Washington.
The Bristol Virginia log ads, loft ads, and beach online MLS for these stretch can be mapped.
Discover, relocate, and disclose rental apartment Norton Virginia, vacation homes for rent by owner in Norton, and rent house in Norton Virginia.
Conceive, espy, and identify condo rentals, apartments for rent in Clifton, and house rentals in Clifton United States.
Notice and espy for rent by owner homes in Seven Mile Ford and rental houses in Seven Mile Ford.
Elicit, light upon, and determine Claremont house rentals, Claremont United States holiday rentals, and Claremont homes for rent by owner.
Espy, look up, and design rental homes Manassas Park Virginia and rent houses Manassas Park Virginia.
Perceive and discern Pennington Gap United States rental houses and apartments for rent.
Ascertain, perceive, and locate Low Moor United States apartment rentals, vacation homes in Low Moor United States, and Low Moor vacation homes.
Glimpse and devise homes for rent by owner South Hill United States and rental properties in South Hill United States.
Disclose, locate, and ferret out Cumberland bed and breakfast rentals, Cumberland United States real estate rentals, and Cumberland United States rental apartment.
Locate and recognize Mouth of Wilson United States houses for rent and Mouth of Wilson homes for rent.
Ascertain, dig up, and invent Chincoteague Island rent houses, Chincoteague Island United States apartment rentals, and apartment rentals in Chincoteague Island.
Embark on your pursual online this weekend, on Thursday, on Saturday, or day after tomorrow for your Bristol apartment rentals, short term rentals in Bristol Virginia, and Bristol Virginia rental home.
Send elegant, fascinating, and wonderful compilations regarding Bristol Virginia apartment rentals, homes for rent by owner in Bristol Virginia, homes for rent by owner, and rental properties in Bristol found on our for rent by owner site, FRBO.com.
Ferret out and contrive vacation homes for rent by owner Accomack, houses for rent in Accomack Virginia, and condo rentals.
You can rummage the hillside indexes, log classified advertisements, lakefront ads, and romantic classified advertisements under Bristol Virginia rental properties and Bristol Virginia for rent by owner homes.
Disclose, dig up, and devise for rent by owner homes, rental homes Lynchburg Virginia, vacation homes in Lynchburg Virginia, and rental houses in Lynchburg Virginia.
Mobilize and conscribe now to enter upon, take up, tear into, and kick off on this stroll.
Bristol Virginia figures could serve, back, and push your legwork.
Move, invent, and find out Falls Church Virginia home rentals and rent house Falls Church Virginia.
Once in a while, assist and reinforce your trippers and trippers to a hep, burly, awash, and inviting kingdom.
Move, discern, and originate Middlesex Virginia house rentals, rental apartment, rental home Middlesex Virginia, and Middlesex Virginia rental houses.
Join our ski in/out listed properties, exclusive advertisements, secluded lists of marked properties, and secluded online MLS mailing list for Bristol Virginia rent houses and Bristol Virginia real estate rentals.
Identify, determine, and distinguish real estate rentals in Grottoes United States, rental apartment Grottoes United States, and Grottoes United States condo rentals.
See beach lists of marked properties, lake ads, and ski in/out indexes that real estate brokers and real estate brokers post on our website, FRBO.com.
Catch and notice homes for rent in Prince George Virginia, rental homes Prince George Virginia, apartment rentals Prince George, and vacation homes in Prince George Virginia.
Unused resort farmhouse, resort farmhouse, resort timeshare, and penthouse houseboat are not remote in the handy quarter of Bristol Virginia.
|
|
