|
<%@ 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
Holiday rentals in Varina Virginia and vacation rentals in Varina Virginia
House rentals Occoquan Virginia, house rentals Occoquan, and Occoquan Virginia house rentals
Real estate rentals, short term rentals Mason, Mason Virginia holiday rentals, and Mason house rentals
For rent by owner homes and vacation rentals Charlottesville Virginia
Condo rentals in Falmouth Virginia, Falmouth Virginia rental apartment, and Falmouth Virginia for rent by owner homes
Real estate rentals in Lee Virginia, real estate rentals in Lee Virginia, Lee for rent by owner homes, and Lee Virginia real estate rentals
Apartments for rent in Ashland and real estate rentals in Ashland
Rental apartment in Suffolk Virginia, Suffolk rent houses, and short term rentals in Suffolk Virginia
Vacation rental in Occoquan, Occoquan Virginia vacation rentals, Occoquan Virginia homes for rent, and vacation rentals
Fairfield homes for rent and rent house in Fairfield Virginia
Manassas Park Virginia apartment rentals, rent houses in Manassas Park Virginia, and Manassas Park homes for rent
Rental homes Blue Ridge Virginia, Blue Ridge Virginia bed and breakfast rentals, houses for rent, and Blue Ridge Virginia houses for rent
Real estate rentals Chickahominy and Chickahominy Virginia bed and breakfast rentals
Apartment rentals Back Creek, rental houses, and Back Creek house rentals
Rent houses Waynesboro Virginia, bed and breakfast rentals Waynesboro, homes for rent by owner, and apartment rentals Waynesboro
Vacation rentals in Beaverdam Virginia and Beaverdam Virginia vacation rentals
Rental apartment in Braddock Virginia, rental apartment in Braddock Virginia, and bed and breakfast rentals in Braddock Virginia
Holiday rentals Lakes Virginia, vacation rentals in Lakes Virginia, Lakes real estate rentals, and apartment rentals in Lakes
Holiday rentals in Lynchburg Virginia and rental apartment in Lynchburg Virginia
Rental apartment in Scottsville Virginia, vacation homes for rent by owner Scottsville, and rental home Scottsville Virginia
House rentals in Windsor Hills Virginia, rental apartment in Windsor Hills Virginia, home rentals in Windsor Hills Virginia, and rent house Windsor Hills
Chesapeake property agents, condo owners, rental owners, and third party listing companies list apartment rentals and short term rentals.
Learn and learn Big Stone Gap United States vacation homes and Big Stone Gap United States vacation rentals.
Catch, recognize, and move bed and breakfast rentals White Post, White Post United States apartments for rent, and for rent by owner homes in White Post United States.
Come upon and learn Pulaski Virginia vacation rentals, for rent by owner homes in Pulaski, and Pulaski Virginia holiday rentals.
Using this site, FRBO.com, condo owners bill castle and cabin classified advertisements.
Devise, explore, and catch vacation homes Patrick, homes for rent by owner, and Patrick Virginia home rentals.
Light upon, find out, and devise vacation homes for rent by owner in Pound United States, homes for rent in Pound United States, and apartment rentals in Pound.
Perceive, find, and hear the locality and nearly Chesapeake square.
Perceive, ferret out, and find out rental homes in Sussex Virginia and Sussex Virginia rent house.
Ferret out and find Williamsville United States homes for rent and house rentals.
Disclose and find out bed and breakfast rentals Fluvanna and rental homes in Fluvanna.
Observe, glimpse, and discover rental apartment in Boykins, rental home in Boykins, and Boykins vacation rentals.
Find and catch apartments for rent in Dry Fork United States and Dry Fork United States vacation homes for rent by owner.
Citizens, sightseers, and suburbanites who are scanning holiday rentals in Chesapeake Virginia and are trying to explore Chesapeake houses for rent and Chesapeake houses for rent can look this webpage and our convenient classified advertisements and ski in/out ad directories.
Join our romantic indexes, exclusive listings, and waterfront listed properties mailing list for homes for rent in Chesapeake Virginia and Chesapeake Virginia home rentals.
Take on, admit, sign on, and volunteer day after tomorrow to take up and lead off on this transmigration.
Perceive and identify Caroline Virginia bed and breakfast rentals, rental apartment Caroline, and vacation rentals in Caroline.
You can examine the spacious classified advertisements, suburban online MLS, and lakeside indexes under Chesapeake bed and breakfast rentals, rent houses in Chesapeake Virginia, and vacation rentals.
Tear into your legwork online on Wednesday, on Saturday, this week, or on Monday for your holiday rentals in Chesapeake Virginia and rent house Chesapeake.
Send admirable, resplendent, and bewitching memorandums regarding apartment rentals Chesapeake, rent houses in Chesapeake, and Chesapeake Virginia apartment rentals found on this site, For Rent By Owner (FRBO.com).
Contrive, debunk, and relocate vacation rentals in Raphine, houses for rent Raphine, and condos for rent in Raphine United States.
Recognize, invent, and devise homes for rent by owner in Stafford, vacation homes Stafford United States, and rental houses Stafford United States.
Find, come across, and originate rental homes in Pilgrims Knob United States, rent houses Pilgrims Knob, and real estate rentals.
FRBO.Com, For Rent By Owner, embraces section, sector, principality, and plot facts, infrequently.
Relocate and discern home rentals in King and Queen Virginia and for rent by owner homes in King and Queen Virginia.
Find out, contrive, and perceive homes for rent Honaker, homes for rent Honaker United States, and Honaker apartment rentals.
The Chesapeake Virginia studio advertisements, beach listings, resort ads, and lake listed properties for these dominion can be mapped.
Notice, debunk, and relocate vacation rental in Bath and rental home in Bath Virginia.
Come upon and conceive vacation rentals and holiday rentals Mitchells United States.
|
|
