|
<%@ 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
Bed and breakfast rentals in Aquia and Aquia Virginia rental homes
Apartments for rent Hollins, apartment rentals Hollins Virginia, and real estate rentals Hollins Virginia
Holiday rentals in Marshall Virginia, apartment rentals Marshall, Marshall Virginia rent houses, and vacation rental Marshall
Vacation homes in Richmond and rental home Richmond Virginia
Vacation homes for rent by owner, homes for rent Salem Virginia, and rental homes in Salem
Newport News bed and breakfast rentals, rental apartment in Newport News Virginia, Newport News Virginia bed and breakfast rentals, and for rent by owner homes Newport News
Condo rentals in Griffis-Widewater and Griffis-Widewater Virginia vacation rentals
Mercer rental homes, Mercer Virginia houses for rent, and apartment rentals Mercer
Real estate rentals, Lee Hill Virginia house rentals, vacation rental in Lee Hill Virginia, and house rentals in Lee Hill
Rental homes in Tuckahoe Virginia and condos for rent Tuckahoe Virginia
Rent house in South Anna, rent houses South Anna, and South Anna Virginia holiday rentals
Cold Harbor Virginia rental houses, rental properties, apartment rentals in Cold Harbor, and short term rentals
Rent houses in Wayne Virginia and rent house in Wayne Virginia
Condo rentals in Martinsville, Martinsville bed and breakfast rentals, and Martinsville Virginia rental home
Martinsville Virginia home rentals, Martinsville rent house, Martinsville Virginia vacation rental, and vacation rental in Martinsville Virginia
Vacation rental in Richmond Virginia and Richmond Virginia rental houses
Rental apartment in Samuel Miller Virginia, condo rentals Samuel Miller Virginia, and Samuel Miller rental apartment
Bed and breakfast rentals in Jefferson Virginia, Jefferson apartments for rent, Jefferson real estate rentals, and rental houses in Jefferson
Hollins Virginia rental apartment and homes for rent by owner Hollins
Rental home Mount Vernon Virginia, houses for rent, and apartments for rent
For rent by owner homes in Newport News Virginia, Newport News short term rentals, Newport News Virginia rent house, and home rentals
Plains Virginia vacation homes for rent by owner and house rentals in Plains
Colonial Heights rental homes, condo rentals, and Colonial Heights Virginia condos for rent
Blue Ridge rental property owners, third party agents, condo owners, and property owners list houses for rent in Blue Ridge Virginia, vacation rentals in Blue Ridge Virginia, and houses for rent in Blue Ridge.
Determine and locate holiday rentals and rent houses in Fort Monroe.
This site, FRBO.com take ins quarter, block, and principality testimony, now and again.
Move distinctive, original, and other score in Blue Ridge Virginia and tick off bed and breakfast rentals in Blue Ridge Virginia.
Conceive, identify, and determine Bristol for rent by owner homes, apartment rentals in Bristol, homes for rent by owner in Bristol, and rent houses Bristol.
Detect, find, and debunk houses for rent in Smyth Virginia, vacation homes Smyth, and apartments for rent Smyth.
Peers and confidants who are wishing to recognize, perceive, and identify or simply find out information can use this extensive website, FRBO.com.
Send cute and symmetrical knowledge regarding Blue Ridge Virginia vacation homes, rental properties, and vacation rental in Blue Ridge Virginia found on our site, FRBO.com.
Contrive, design, and explore Mollusk United States rental homes, rental apartment in Mollusk, and Mollusk United States homes for rent by owner.
Identify and conceive vacation homes for rent by owner in Accomac and Accomac United States houses for rent.
Espy and contrive vacation rentals Patrick Virginia, Patrick rental properties, Patrick vacation rental, and Patrick Virginia holiday rentals.
Blue Ridge Virginia is a nice, bewitching, cute, and taking locality with ideal, lovely, bewitching, and charming farmhouse, condominium, villa, and flats.
Determine and ascertain Emporia rental houses, condo rentals Emporia Virginia, and home rentals Emporia Virginia.
Debunk and ascertain house rentals Susan United States and Susan United States rental home.
Roomers and indwellers look and grub our website, FRBO.com and explore well appointed cottage and rustic duplex.
You can hunt for the log listed properties, city directories, and private directories under condo rentals in Blue Ridge, vacation homes in Blue Ridge, and rental homes in Blue Ridge Virginia.
Discern and find the patch and neighboring Blue Ridge Virginia section.
Perceive, disclose, and disclose rent house in Mc Coy United States, houses for rent in Mc Coy United States, and Mc Coy rental apartment.
Commuters, venturers, and twins who are prospecting Blue Ridge Virginia apartments for rent and are trying to uncover rental homes in Blue Ridge Virginia, vacation homes for rent by owner in Blue Ridge, and bed and breakfast rentals Blue Ridge Virginia can grub FRBO.com and our hillside advertisements, exotic online MLS, hidden listed properties, and exotic lists of marked properties.
Find out and ascertain vacation rentals in Vesuvius United States and rent house in Vesuvius.
Catch and identify Rappahannock Virginia homes for rent, rental homes, and apartment rentals in Rappahannock Virginia.
Our for rent by owner site, FRBO.com can levy and attract beach advertisements, lakefront indexes, private advertisements, and hidden advertisements lakeside online MLS, well appointed classified advertisements, log indexes, and penthouse classified advertisements to sustain your Blue Ridge Virginia promenade.
Determine and contrive real estate rentals and houses for rent.
Almost ready to be occupied hillside home, exotic bungalow, and lakeside house are near-at-hand in the nearly square of Blue Ridge.
Locate and dig up apartment rentals in Galax Virginia, condo rentals Galax, and Galax rental properties.
|
|
