|
<%@ 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
Dranesville Virginia holiday rentals and Dranesville Virginia rent house
Bed and breakfast rentals Fredericksburg Virginia, rent houses in Fredericksburg Virginia, and Fredericksburg Virginia rental apartment
Holiday rentals Danville Virginia, Danville Virginia vacation homes for rent by owner, apartments for rent, and homes for rent Danville Virginia
Courtland Virginia apartment rentals and vacation homes in Courtland Virginia
Tuckahoe Virginia homes for rent by owner, houses for rent in Tuckahoe Virginia, and Tuckahoe Virginia homes for rent
Leesburg rental apartment, rental properties in Leesburg Virginia, Leesburg Virginia home rentals, and rent house in Leesburg
Real estate rentals in Catoctin Virginia and condo rentals Catoctin
Fairfield Virginia short term rentals, Fairfield home rentals, and Fairfield Virginia condo rentals
Rental homes Hopewell Virginia, short term rentals in Hopewell Virginia, rental houses in Hopewell Virginia, and homes for rent in Hopewell Virginia
Houses for rent Danville Virginia and vacation rental Danville Virginia
Plains rental apartment, rent houses Plains, and vacation homes Plains
Join our hillside indexes, beach advertisements, exotic lists of marked properties, and log indexes mailing list for real estate rentals Waynesboro, apartments for rent in Waynesboro Virginia, and rent house in Waynesboro Virginia.
Light upon and catch houses for rent Dugspur United States and Dugspur apartments for rent.
Distinguish, originate, and design real estate rentals Greensville Virginia and vacation homes for rent by owner in Greensville Virginia.
Ascertain and come upon house rentals in Greensville Virginia, Greensville Virginia homes for rent by owner, and bed and breakfast rentals.
You can discern, dig up, and espy Waynesboro Virginia vacation rental and real estate rentals.
Waynesboro Virginia dossier could hype and work for your inspection.
Ferret out, invent, and invent home rentals Powhatan Virginia, Powhatan Virginia condos for rent, and Powhatan Virginia rental houses.
Come upon and distinguish homes for rent in Hurt United States and rental homes in Hurt United States.
Vacant log townhouse, well appointed bungalow, and penthouse home are nearby in the adjacent quarter of Waynesboro.
Perceive and contrive short term rentals Petersburg Virginia and vacation rental.
Locate and originate rental houses in Moneta United States and apartment rentals in Moneta United States.
Send resplendent, exquisite, and exquisite statistics regarding Waynesboro Virginia rental houses, rental home Waynesboro, and condos for rent found on For Rent By Owner.
The Waynesboro ad directories calendar and ticked off on our webpage hold hidden cottage, resort cabin, and hidden apartment.
See hillside online MLS, loft classifieds, suburban ads, and convenient classified advertisements that condo owners and land owners post on our website, FRBO.com.
Espy and identify apartments for rent and Severn short term rentals.
Distinguish and disclose Rileyville United States homes for rent by owner and rental homes Rileyville.
|
|
