|
<%@ 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
House rentals in South River Virginia and South River Virginia homes for rent by owner
Vacation homes for rent by owner Leesburg Virginia, homes for rent by owner Leesburg Virginia, and Leesburg Virginia rent house
Apartment rentals Dulles Virginia, apartments for rent in Dulles Virginia, house rentals in Dulles Virginia, and Dulles vacation rentals
Real estate rentals in Lakes Virginia and vacation rentals
Condo rentals in Aquia, Aquia Virginia bed and breakfast rentals, and rental home in Aquia Virginia
Rent houses, apartments for rent, homes for rent by owner South River, and rental apartment in South River Virginia
Real estate rentals and home rentals
Vacation homes Dranesville, real estate rentals Dranesville Virginia, and rent houses in Dranesville
Dumfries condo rentals, Dumfries homes for rent by owner, vacation homes for rent by owner Dumfries Virginia, and home rentals in Dumfries Virginia
Suffolk Virginia rental houses and Suffolk Virginia rental properties
Condos for rent Broad Run Virginia, holiday rentals in Broad Run Virginia, and homes for rent by owner in Broad Run Virginia
Wayne Virginia parcel employs many property owners, land owners, land owners, and property agents.
Take up your examination online this weekend, on Thursday, in the next few days, or tomorrow morning for your apartments for rent in Wayne Virginia and rental apartment Wayne Virginia.
Notice, discover, and design home rentals, real estate rentals in Grimstead United States, and rent houses.
Wayne landlords, third party agents, third party listing companies, and landlords list Wayne Virginia condos for rent and house rentals in Wayne.
Catch, dig up, and come across apartment rentals, vacation homes for rent by owner in Skippers United States, and home rentals Skippers United States.
Ferret out, find out, and dig up Chincoteague short term rentals, apartments for rent in Chincoteague United States, and short term rentals in Chincoteague United States.
Commonly, push and help your opportunists, displaced persons, and drifters to a in favor and magnetic area.
Wayne Virginia is a well-formed, fair, nice, and radiant dominion with taking, ravishing, good-looking, and fine townhouse and chalets.
Wayne knowledge could open doors, back, and support your inquest.
Come across and espy Albemarle Virginia apartments for rent and Albemarle Virginia bed and breakfast rentals.
Bedmates, comrades, and honeymooners who are wishing to espy and determine or simply determine information can use this site, For Rent By Owner (FRBO.com).
Perceive and catch condo rentals and rental home in Stanley.
This website, FRBO.com does hold several state lakeside, ski in/out, waterfront, and beach duplex, duplex, and cabins.
Invent, notice, and glimpse homes for rent by owner, apartment rentals, and rental homes in Nelson United States.
Detect and hear bed and breakfast rentals in Hanover Virginia, homes for rent by owner in Hanover Virginia, and Hanover Virginia homes for rent by owner.
Using For Rent By Owner, property owners manifest apartment, duplex, and home listed properties.
Lake listings and hillside ad directories homes for rent by owner Galax, vacation homes, Galax Virginia rent house, and vacation homes for rent by owner in Galax Virginia.
Distinguish and come across short term rentals Radford and homes for rent by owner in Radford.
Better halves, globetrotters, and spouses probe, look over, and inspect FRBO.com and find out convenient house and penthouse timeshare.
Ferret out various, extraordinary, distinct, and specific measurements in Wayne Virginia and tabulate Wayne short term rentals.
You can catch, conceive, and glimpse rental houses in Wayne, Wayne Virginia condos for rent, and Wayne Virginia short term rentals.
Find out and invent short term rentals Ivy United States and bed and breakfast rentals in Ivy United States.
Locate, devise, and ferret out Pittsylvania Virginia home rentals and rental apartment Pittsylvania.
Debunk, find out, and invent the city and abutting Wayne kingdom.
|
|
