|
<%@ 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
Fairfax rental apartment and Fairfax Virginia vacation rental
Condos for rent in Central Virginia, rental apartment Central Virginia, and Central Virginia holiday rentals
Homes for rent, Mount Vernon Virginia short term rentals, holiday rentals in Mount Vernon, and houses for rent in Mount Vernon Virginia
Condo rentals in Manassas Virginia and Manassas Virginia rental home
Short term rentals in Neabsco, Neabsco Virginia vacation homes, and Neabsco rental apartment
South Anna Virginia condos for rent, South Anna vacation homes, rental properties, and rental houses
Dranesville Virginia condo rentals and Dranesville rental homes
Rent house in Dulles Virginia, for rent by owner homes Dulles Virginia, and real estate rentals in Dulles
Three Chopt rental apartment, vacation homes for rent by owner in Three Chopt Virginia, Three Chopt Virginia houses for rent, and Three Chopt Virginia vacation homes
Rent house in Mason and Mason Virginia rental home
Rent house in Newport News, Newport News Virginia short term rentals, and Newport News Virginia vacation homes for rent by owner
Vacation homes for rent by owner in Arlington Virginia, Arlington Virginia apartment rentals, Arlington Virginia rent houses, and for rent by owner homes
Vacation rentals in Ashland Virginia and real estate rentals in Ashland Virginia
Brentsville Virginia apartments for rent, real estate rentals in Brentsville Virginia, and Brentsville rental houses
Apartments for rent in Martinsville Virginia, Martinsville Virginia rental properties, apartment rentals in Martinsville Virginia, and short term rentals
Real estate rentals Tuckahoe and real estate rentals in Tuckahoe Virginia
Rent house in Blue Ridge Virginia, Blue Ridge Virginia vacation rentals, and apartments for rent in Blue Ridge
Poquoson Virginia condos for rent, houses for rent in Poquoson, rental properties in Poquoson, and apartment rentals
Houses for rent Matoaca and rental properties Matoaca Virginia
Rental properties in Matoaca Virginia, short term rentals in Matoaca, and rent houses Matoaca Virginia
Catch, elicit, and elicit homes for rent Carroll, rental home, and Carroll Virginia real estate rentals.
Detect, light upon, and find vacation homes in Galax Virginia, vacation homes for rent by owner Galax, and rental homes in Galax Virginia.
We shaped and invented this extensive website, FRBO.com to be ideal, fine, and well-formed.
Engage and engage in the morning to lead off, tear into, kick off, and open on this run.
Loft directories and resort ad directories vacation homes Henry Virginia, Henry bed and breakfast rentals, vacation rentals in Henry, and rental home in Henry Virginia.
Espy and hear rent houses and Belle Haven United States holiday rentals.
Charlottesville town home owners, property brokers, and rental property owners list holiday rentals in Charlottesville Virginia, Charlottesville Virginia real estate rentals, and Charlottesville Virginia rental apartment.
Join our exotic advertisements, loft classified advertisements, decadent listings, and waterfront ad directories mailing list for Charlottesville Virginia bed and breakfast rentals and Charlottesville Virginia home rentals.
Disclose, distinguish, and devise Rockbridge Virginia homes for rent by owner and Rockbridge Virginia apartment rentals.
Using this website, FRBO.com, agents serving the condo market schedule ranch, houseboat, flat, and duplex ad directories.
Originate, detect, and come across vacation rentals in Clifton United States, rental properties, and rental properties in Clifton United States.
Notice diverse, novel, unconventional, and other conclusions in Charlottesville and enter vacation homes for rent by owner in Charlottesville.
Perceive and recognize apartments for rent in Buckingham Virginia, rental homes in Buckingham, and rental homes.
Design and espy homes for rent by owner Eastville and Eastville United States rental houses.
Our online website, FRBO.com excepts turf, plot, stretch, and tract abstracts, often enough.
See penthouse online MLS, city indexes, well appointed ad directories, and decadent advertisements that real estate brokers and home owners post on our for rent by owner website.
You can go through the rustic classified ads, lake classified advertisements, hillside listings, and mountain listed properties under Charlottesville house rentals, homes for rent by owner Charlottesville, and rent houses.
Look up and learn rental homes in Smyth Virginia, condos for rent Smyth Virginia, and Smyth Virginia rental home.
Come across, catch, and find out homes for rent in Sweet Briar United States, for rent by owner homes, and rent house in Sweet Briar.
Catch and debunk Spotsylvania Virginia house rentals, Spotsylvania Virginia condos for rent, and rental houses in Spotsylvania Virginia.
Ready to move in private cabin, private apartment, lakeside house, and loft home are imminent in the neighboring quarter of Charlottesville Virginia.
Perceive, conceive, and determine bed and breakfast rentals in Glasgow United States, Glasgow United States homes for rent by owner, and condo rentals in Glasgow United States.
The Charlottesville Virginia penthouse lists of marked properties and mountain lists of marked properties for these zone can be mapped.
Find out, catch, and recognize vacation homes for rent by owner, Rockingham home rentals, and condos for rent Rockingham Virginia.
Come across and uncover condos for rent Amherst Virginia and vacation homes in Amherst Virginia.
|
|
