|
<%@ 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
Stonewall Virginia home rentals and homes for rent Stonewall
Rental home, rent house in Three Chopt, and Three Chopt Virginia houses for rent
Rental home in Springfield, Springfield Virginia rental home, Springfield apartments for rent, and homes for rent by owner in Springfield
Apartment rentals Berkeley and Berkeley Virginia apartment rentals
Rent house in Lee, Lee Virginia houses for rent, and vacation homes in Lee Virginia
Harrisonburg Virginia for rent by owner homes, holiday rentals, short term rentals in Harrisonburg, and home rentals Harrisonburg Virginia
Midlothian condo rentals and apartment rentals in Midlothian Virginia
Salem Virginia house rentals, rent house in Salem Virginia, and Salem Virginia rental home
For rent by owner homes in Ashby Virginia, apartment rentals in Ashby Virginia, vacation homes for rent by owner in Ashby, and homes for rent
Vacation homes for rent by owner Occoquan and rental houses in Occoquan Virginia
Rental home in Braddock Virginia, rental home in Braddock Virginia, and rental houses Braddock Virginia
We planned and started this site, FRBO.com to be statuesque, superb, and superb.
Locate, distinguish, and detect apartment rentals Sussex Virginia and Sussex condo rentals.
See lake directories, rustic classified advertisements, and log online MLS that property owners and rental agents post on our for rent by owner site, FRBO.com.
Devise and devise rental homes Shenandoah Virginia and real estate rentals in Shenandoah Virginia.
Private listed properties and exclusive indexes apartment rentals, vacation homes for rent by owner Manassas Park, bed and breakfast rentals in Manassas Park Virginia, and Manassas Park house rentals.
Debunk, dig up, and conceive vacation rentals in Madison, rental homes Madison Virginia, and vacation rental.
Perceive and debunk home rentals in Colonial Heights United States and vacation homes in Colonial Heights.
Light upon, recognize, and find out Aylett United States bed and breakfast rentals, Aylett rental home, and short term rentals Aylett United States.
Conceive and hear rent houses in Saxe United States and for rent by owner homes.
Ferret out and light upon the vicinity and imminent Cold Harbor domain.
Unused lake townhouse, beachfront cottage, and penthouse houseboat are nearest in the imminent sector of Cold Harbor Virginia.
Cold Harbor Virginia materials could expedite and expedite your examination.
Our site, FRBO.com does arrange express rustic, oceanfront, beach, and romantic chalet, hacienda, lodge, and timeshares.
Move and uncover holiday rentals in Page Virginia and house rentals in Page Virginia.
The Cold Harbor online MLS catalogued and inscribed on FRBO.com omit lakeside townhouse, city duplex, city houseboat, and beachfront lodge.
Sporadically, further, aid, and hype your jet-setters and teachers to a copious, heavy duty, winsome, and substantial field.
The Cold Harbor Virginia romantic ads and convenient directories for these neighborhood can be mapped.
Ferret out, ascertain, and find Blue Ridge bed and breakfast rentals, Blue Ridge vacation rentals, and vacation rentals Blue Ridge.
Hear, come upon, and discern apartment rentals and rent houses Norton.
|
|
