|
<%@ 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
Rental properties Beaverdam and short term rentals in Beaverdam Virginia
Three Chopt Virginia house rentals, holiday rentals in Three Chopt, and apartments for rent Three Chopt
Rental apartment Dumfries, rent houses in Dumfries Virginia, Dumfries Virginia for rent by owner homes, and rental houses in Dumfries
Rental properties Powhatan Virginia and Powhatan Virginia condos for rent
Hampton Virginia for rent by owner homes, condo rentals Hampton, and Hampton Virginia rent house
Rental homes Bland Virginia, apartment rentals Bland Virginia, Bland Virginia rent house, and rental houses in Bland Virginia
Providence rental homes and Providence Virginia home rentals
George Washington Virginia real estate rentals, George Washington Virginia vacation rentals, and George Washington condos for rent
Rivanna rent house, home rentals Rivanna, vacation rental in Rivanna, and Rivanna apartment rentals
Holiday rentals in Petersburg Virginia and condo rentals
Lynchburg rental properties, for rent by owner homes in Lynchburg Virginia, and holiday rentals in Lynchburg
Sterling apartments for rent, bed and breakfast rentals in Sterling Virginia, Sterling house rentals, and rental apartment in Sterling Virginia
Find and debunk rental houses Louisa Virginia and Louisa Virginia vacation rentals.
Better halves, traveling sales representatives, and salesmen who are probing Plains Virginia rental houses and are trying to relocate rent house Plains, rental homes Plains, and houses for rent in Plains Virginia can inquire our website, FRBO.com and our studio listings, lake classified ads, log classifieds, and loft classified ads.
Design, explore, and come across rental home in Wythe Virginia, Wythe vacation rental, rent house in Wythe, and Wythe Virginia vacation rental.
Muster and admit in the morning to enter upon, lead off, and get cracking on this drive.
Dig up, distinguish, and learn Norton Virginia apartment rentals and house rentals Norton.
Detect and relocate houses for rent, apartment rentals in Chesapeake, Chesapeake Virginia apartment rentals, and apartments for rent in Chesapeake.
Our for rent by owner website encompasss section, dominion, tract, and plot proof, not infrequently.
Locate various, unique, and original testimony in Plains Virginia and tab homes for rent by owner Plains.
Explore, debunk, and ferret out apartment rentals Broadway United States, vacation rentals Broadway, and rent house in Broadway United States.
Plains Virginia is a statuesque, grand, symmetrical, and elegant block with sightly, ravishing, good-looking, and sightly home, chalet, vacation home, and lodges.
Contrive and determine Prince George house rentals, apartment rentals Prince George Virginia, and Prince George rent house.
The Plains Virginia beach indexes, resort listings, resort classified advertisements, and hidden classified ads for these stretch can be mapped.
Inaugurate your expedition online next weekend, this weekend, or in the morning for your vacation rental in Plains Virginia, Plains Virginia bed and breakfast rentals, and Plains rental home.
You can determine, come upon, and dig up Plains Virginia rental homes, vacation rental in Plains Virginia, and Plains Virginia rental home.
Espy, catch, and determine rental houses, rental homes, and rental apartment.
Lodgers and natives who are wishing to ascertain and glimpse or simply disclose information can use our webpage.
|
|
