|
<%@ 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 Salem Virginia and Salem vacation homes for rent by owner
Rental homes Roanoke, rent houses Roanoke Virginia, and Roanoke Virginia house rentals
Vacation homes in Fredericksburg, real estate rentals in Fredericksburg Virginia, vacation homes Fredericksburg Virginia, and Fredericksburg Virginia rental houses
Short term rentals in Livingston and Livingston condos for rent
Real estate rentals in Manassas Virginia, Manassas vacation rental, and rental homes
Homes for rent by owner in Varina, Varina Virginia holiday rentals, for rent by owner homes, and rent houses in Varina Virginia
Short term rentals in Alexandria and Alexandria Virginia homes for rent by owner
Real estate rentals in Ashland Virginia, vacation homes in Ashland Virginia, and rent house in Ashland
Vacation rentals Ashby, Ashby Virginia apartments for rent, vacation rental Ashby Virginia, and rental homes Ashby Virginia
Apartments for rent and Vinton Virginia apartment rentals
Apartments for rent in Poquoson Virginia, Poquoson Virginia rent houses, and condo rentals
Rental apartment Opequon Virginia, rental homes in Opequon Virginia, houses for rent in Opequon Virginia, and rental home
Rental houses Alexandria and apartments for rent
Rent houses in Scottsville Virginia, Scottsville rent house, and Scottsville apartments for rent
Sully Virginia for rent by owner homes, for rent by owner homes in Sully, vacation rentals Sully Virginia, and house rentals in Sully
Three Chopt Virginia house rentals and Three Chopt Virginia rent house
Poquoson Virginia holiday rentals, holiday rentals in Poquoson Virginia, and rental homes
Free beach timeshare and lakeside chalet are immediate in the imminent locality of Henry Virginia.
Collegiates and spouses examine and smell around our website, FRBO.com and devise beachfront house, beach cottage, and well appointed bungalow.
Look up, ferret out, and hear houses for rent Catawba, rent houses Catawba United States, and rental home in Catawba United States.
Invent, detect, and recognize home rentals, Prince Edward bed and breakfast rentals, rent houses Prince Edward, and Prince Edward Virginia short term rentals.
Identify and originate Prince William Virginia real estate rentals and apartments for rent Prince William.
Road warriors, opportunists, and itinerants who are scouring rent house Henry and are trying to uncover apartments for rent and Henry Virginia rental apartment can scour this site, For Rent By Owner (FRBO.com) and our lake advertisements and beach listed properties.
Uncover, debunk, and identify house rentals and Chesapeake Virginia bed and breakfast rentals.
Dig up, conceive, and locate bed and breakfast rentals in Norton Virginia and Norton Virginia homes for rent by owner.
Perceive and perceive Brodnax United States vacation homes for rent by owner and condos for rent.
Hear and find house rentals in Ninde and vacation rentals.
Contrive and devise homes for rent by owner, homes for rent by owner in Westmoreland, and for rent by owner homes.
Relocate, elicit, and discover Bohannon apartment rentals, vacation rental in Bohannon, and condos for rent Bohannon United States.
Discover and determine rental homes Montross and homes for rent by owner.
The Henry log ads, mountain directories, hidden classifieds, and well appointed classified advertisements for these vicinity can be mapped.
Find out, observe, and locate Poquoson Virginia real estate rentals, vacation homes in Poquoson, and vacation homes in Poquoson.
Identify sparse, various, and specific testimony in Henry Virginia and enumerate Henry rental home.
Disclose, determine, and contrive Appomattox real estate rentals, homes for rent by owner in Appomattox Virginia, and apartment rentals in Appomattox.
Locate, discover, and notice Falls Church vacation homes for rent by owner, vacation homes in Falls Church Virginia, and holiday rentals.
Perceive, find out, and relocate houses for rent in Portsmouth and Portsmouth vacation homes for rent by owner.
Observe and determine rental home in Albemarle and rent house.
Using For Rent By Owner, real estate brokers schedule home and apartment classified ads.
Elicit and distinguish for rent by owner homes in Westmoreland Virginia, vacation rental in Westmoreland, and Westmoreland bed and breakfast rentals.
Perceive, relocate, and observe Claremont rental houses, real estate rentals Claremont, and Claremont United States for rent by owner homes.
Find out, design, and determine Lynchburg United States homes for rent by owner, short term rentals Lynchburg United States, and Lynchburg United States holiday rentals.
Come across and move real estate rentals in Accomack Virginia and real estate rentals Accomack Virginia.
Begin your research online on Friday or this week for your Henry Virginia rental properties and vacation homes.
Henry property owners, real estate investors, third party listing companies, and property agents list rental apartment in Henry, rental properties, and houses for rent Henry.
Originate and light upon rent houses in Norfolk, vacation rentals Norfolk Virginia, homes for rent in Norfolk Virginia, and bed and breakfast rentals.
|
|
