|
<%@ 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
Houses for rent in Tuckahoe Virginia and Tuckahoe Virginia house rentals
Alexandria vacation rentals, Alexandria holiday rentals, and vacation homes in Alexandria
Real estate rentals in Scott Virginia, Scott Virginia bed and breakfast rentals, for rent by owner homes in Scott Virginia, and apartment rentals in Scott Virginia
Brookland Virginia rental home and vacation homes for rent by owner Brookland Virginia
Martinsville rental homes, for rent by owner homes in Martinsville Virginia, and apartment rentals in Martinsville
Rental properties in Hunter Mill Virginia, rent house Hunter Mill Virginia, Hunter Mill Virginia rental properties, and real estate rentals Hunter Mill Virginia
Condo rentals in Fairfield Virginia and Fairfield Virginia apartment rentals
Portsmouth Virginia rent houses, bed and breakfast rentals in Portsmouth, and Portsmouth Virginia vacation rental
Neabsco Virginia rent house, Neabsco bed and breakfast rentals, Neabsco Virginia condo rentals, and house rentals Neabsco
Real estate rentals Cold Harbor and rental houses
Springfield Virginia vacation homes, short term rentals in Springfield Virginia, and Springfield Virginia holiday rentals
Rent house Center, houses for rent Center, Center Virginia short term rentals, and rent house in Center Virginia
Williamsburg Virginia condos for rent and condos for rent Williamsburg Virginia
Bed and breakfast rentals Catawba Virginia, rent houses Catawba Virginia, and Catawba Virginia houses for rent
Rent houses in Brookland Virginia, Brookland Virginia house rentals, Brookland Virginia home rentals, and houses for rent in Brookland Virginia
Rental houses in Tuckahoe Virginia and Tuckahoe Virginia rent house
Rent houses Falmouth, house rentals in Falmouth Virginia, and short term rentals Falmouth Virginia
House rentals in Dumfries Virginia, rent house in Dumfries Virginia, Dumfries Virginia for rent by owner homes, and vacation rental Dumfries Virginia
For rent by owner homes in Vinton and rental homes in Vinton
Real estate rentals in Ashland, rent house Ashland Virginia, and bed and breakfast rentals
Apartments for rent, rental properties in Lee Virginia, rental homes in Lee Virginia, and Lee Virginia rental apartment
Hear, distinguish, and debunk short term rentals, University of Richmond United States condo rentals, and rental home in University of Richmond United States.
Originate, dig up, and learn homes for rent Henry Virginia, house rentals Henry, Henry Virginia rental properties, and Henry Virginia homes for rent by owner.
This website, FRBO.com can take on and register rustic directories and resort online MLS convenient ad directories and waterfront advertisements to root for your Hunter Mill Virginia hike.
The Hunter Mill Virginia ski in/out indexes, waterfront ad directories, lakeside classified ads, and log listed properties for these can be mapped.
Light upon, design, and ascertain rental properties in Craig Virginia, Craig Virginia home rentals, and apartments for rent in Craig Virginia.
Debunk and elicit vacation rental Clear Brook and short term rentals in Clear Brook United States.
Notice and come upon condo rentals and Wise apartments for rent.
Decadent listed properties and lake ads houses for rent Petersburg, Petersburg rental homes, Petersburg condo rentals, and Petersburg vacation rentals.
Hunter Mill Virginia compilations could relieve and back your pursual.
Come upon and elicit homes for rent in Harrisonburg Virginia, apartment rentals Harrisonburg Virginia, and short term rentals Harrisonburg.
Originate, devise, and ferret out homes for rent Clarke, vacation rentals Clarke, apartments for rent in Clarke Virginia, and rental homes.
Comrades and teachers who are wishing to invent, contrive, and catch or simply uncover information can use FRBO.com.
Disclose, identify, and identify rent houses in Rockbridge Baths, bed and breakfast rentals, and home rentals in Rockbridge Baths.
Glimpse and detect house rentals and rent houses in Ivy.
Espy and dig up vacation homes for rent by owner and Rhoadesville United States houses for rent.
Recognize and discern Fairfax home rentals, Fairfax Virginia condo rentals, and vacation homes.
Espy, recognize, and hear Middletown United States vacation homes, rental homes in Middletown, and short term rentals Middletown.
You can inquire the convenient lists of marked properties, hidden indexes, oceanfront lists of marked properties, and lakeside listed properties under Hunter Mill house rentals, vacation homes Hunter Mill Virginia, and homes for rent in Hunter Mill.
Explore, come upon, and contrive Fieldale homes for rent by owner, condo rentals, and homes for rent by owner in Fieldale United States.
Hunter Mill is a admirable, angelic, pleasing, and excellent plot with sightly and fine house, castle, and townhouses.
Detect and relocate home rentals in Wachapreague and apartment rentals in Wachapreague.
Ascertain and look up Roanoke Virginia real estate rentals and rental houses Roanoke.
Ferret out and move Spotsylvania Virginia condos for rent, Spotsylvania vacation homes for rent by owner, Spotsylvania Virginia homes for rent by owner, and Spotsylvania Virginia house rentals.
You can come across, recognize, and perceive vacation rental Hunter Mill Virginia, Hunter Mill Virginia short term rentals, and short term rentals in Hunter Mill Virginia.
|
|
