|
<%@ 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
Lakes Virginia vacation rental and house rentals
Suffolk Virginia for rent by owner homes, Suffolk Virginia homes for rent by owner, and Suffolk Virginia for rent by owner homes
Houses for rent in Salem, rental homes in Salem, condo rentals, and rental homes in Salem
Matoaca Virginia houses for rent and apartment rentals in Matoaca Virginia
Rental houses Mercer Virginia, vacation homes for rent by owner, and rent house Mercer
For rent by owner homes in Providence Virginia, Providence Virginia holiday rentals, bed and breakfast rentals Providence, and rental homes in Providence
Charlottesville Virginia apartments for rent and Charlottesville Virginia rent houses
Homes for rent by owner, holiday rentals in Fairfax Virginia, and rental homes in Fairfax Virginia
Houses for rent Alexandria, condo rentals Alexandria, homes for rent in Alexandria, and Alexandria Virginia short term rentals
For rent by owner homes Newport News Virginia and rental properties Newport News Virginia
Vacation rentals in Lee, vacation rental Lee Virginia, and homes for rent in Lee Virginia
Homes for rent in Gainesville Virginia, Gainesville houses for rent, rental apartment in Gainesville Virginia, and holiday rentals in Gainesville Virginia
Distinguish and discern condo rentals Scott and Scott Virginia rental homes.
Devise, discern, and find vacation rental in Alexandria, Alexandria rental properties, and condo rentals.
Look up, come upon, and notice house rentals in Zanoni, Zanoni vacation rentals, and Zanoni United States rent houses.
Hitch and engage tonight to begin, open, embark on, and open on this vagabondage.
Espy, disclose, and explore Manassas United States rental home, condo rentals in Manassas United States, and rental homes Manassas United States.
Learn, recognize, and learn bed and breakfast rentals Lancaster, Lancaster Virginia house rentals, rental homes, and vacation rental.
Contrive, invent, and recognize apartment rentals Rockingham, Rockingham Virginia rental homes, rent house in Rockingham Virginia, and Rockingham Virginia house rentals.
Identify, hear, and find Fort Defiance United States condo rentals, home rentals Fort Defiance, and apartments for rent Fort Defiance.
Join our romantic advertisements, beach advertisements, and oceanfront classified advertisements mailing list for homes for rent by owner in Hampton and vacation rental in Hampton Virginia.
Our for rent by owner site, FRBO.com does consist of some convenient, suburban, lakeside, and beachfront vacation home, ranch, and villas.
Send excellent, classy, and divine input regarding houses for rent Hampton Virginia, rental houses in Hampton Virginia, vacation homes for rent by owner in Hampton, and short term rentals Hampton found on For Rent By Owner.
Locate and find homes for rent and Brodnax United States rental houses.
Come across, distinguish, and move house rentals in Ashburn United States, house rentals in Ashburn United States, and Ashburn United States bed and breakfast rentals.
Confreres and explorers who are beating about house rentals in Hampton Virginia and are trying to catch rental properties in Hampton and vacation rental in Hampton Virginia can rummage our for rent by owner site, FRBO.com and our romantic classifieds, lake listed properties, well appointed advertisements, and beach listings.
You can ransack the well appointed online MLS and beachfront ads under rent houses in Hampton and for rent by owner homes in Hampton.
Devise and glimpse homes for rent by owner Fauquier and condos for rent in Fauquier.
Identify and move rental properties in Danville, Danville Virginia apartment rentals, and Danville Virginia rent houses.
Hampton Virginia plot employs many real estate investors, property managers, and home owners.
Notice, detect, and uncover Martinsville Virginia vacation homes for rent by owner and apartments for rent in Martinsville Virginia.
|
|
