|
<%@ 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
Virginia Beach Virginia rent house and bed and breakfast rentals Virginia Beach Virginia
Holiday rentals Fairfield, apartments for rent in Fairfield Virginia, and homes for rent by owner in Fairfield Virginia
Rent houses in Stonewall, Stonewall Virginia houses for rent, Stonewall Virginia vacation homes for rent by owner, and Stonewall Virginia homes for rent
Rent houses in Waynesboro and holiday rentals Waynesboro
Mechanicsville short term rentals, condo rentals in Mechanicsville Virginia, and short term rentals
Neabsco Virginia holiday rentals, vacation rental Neabsco, home rentals in Neabsco Virginia, and rental apartment in Neabsco Virginia
Broad Run houses for rent and homes for rent in Broad Run Virginia
Vacation rental in Suffolk Virginia, homes for rent in Suffolk Virginia, and condos for rent in Suffolk Virginia
Rent house in Falls Church Virginia, Falls Church Virginia condo rentals, real estate rentals Falls Church, and Falls Church Virginia vacation homes for rent by owner
Short term rentals Chickahominy and apartment rentals in Chickahominy Virginia
Rental home Beaverdam Virginia, for rent by owner homes in Beaverdam, and short term rentals in Beaverdam
Cold Harbor bed and breakfast rentals, short term rentals Cold Harbor, Cold Harbor Virginia rental apartment, and apartment rentals Cold Harbor Virginia
The Sully Virginia beachfront ads and beach online MLS for these state can be mapped.
Come upon, glimpse, and conceive short term rentals Norfolk United States, Norfolk rental apartment, and Norfolk rental apartment.
This site, For Rent By Owner (FRBO.com) can record, incorporate, and hitch hidden directories and convenient indexes city ad directories, convenient listings, log online MLS, and private ad directories to abet your Sully Virginia run.
Dig up, learn, and perceive rent houses and vacation homes for rent by owner Highland Virginia.
Detect, debunk, and look up home rentals in Spotsylvania, real estate rentals in Spotsylvania, and Spotsylvania rent house.
We coined, occasioned, and formed our for rent by owner site, FRBO.com to be radiant and fascinating.
See lakefront online MLS, hillside lists of marked properties, beachfront online MLS, and ski in/out directories that home owners and condo owners post on this site, For Rent By Owner (FRBO.com).
Explore, identify, and detect rent houses Lightfoot United States, house rentals, and Lightfoot United States rental apartment.
Sully Virginia is a symmetrical and well-formed square with fair, grand, splendid, and exquisite apartment, cabin, lodge, and houses.
Espy several, novel, and discrete testimony in Sully and tabulate homes for rent by owner in Sully Virginia.
Sully real estate investors and land owners list home rentals, condos for rent in Sully, Sully Virginia for rent by owner homes, and homes for rent Sully.
Recently available suburban farmhouse, secluded home, suburban farmhouse, and exotic cottage are impending in the near-at-hand locality of Sully Virginia.
Conceive, relocate, and light upon the vicinity and handy Sully Virginia state.
Waterfront indexes and studio ad directories rental homes in Richmond, rent houses in Richmond Virginia, vacation homes in Richmond Virginia, and Richmond rent house.
Detect, uncover, and relocate house rentals in Frederick, vacation homes for rent by owner Frederick, homes for rent by owner in Frederick Virginia, and houses for rent Frederick Virginia.
Find out and elicit homes for rent in Lynchburg, rent houses in Lynchburg Virginia, and for rent by owner homes in Lynchburg Virginia.
Identify and recognize apartments for rent Rocky Mount United States and apartment rentals.
|
|
