|
<%@ 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 Staunton Virginia and Staunton Virginia houses for rent
Stonewall Virginia house rentals, apartment rentals in Stonewall, and vacation homes for rent by owner in Stonewall Virginia
Rent houses in Courtland, vacation homes for rent by owner in Courtland Virginia, vacation rental Courtland, and for rent by owner homes in Courtland
Harrisonburg rent house and houses for rent in Harrisonburg Virginia
Real estate rentals Back Creek Virginia, Back Creek home rentals, and vacation rentals
Real estate rentals in Catawba Virginia, houses for rent Catawba, condos for rent in Catawba, and Catawba Virginia rental home
Rental home and for rent by owner homes in Fairfield
Center for rent by owner homes, homes for rent in Center Virginia, and Center vacation homes
For rent by owner homes in Springfield Virginia, Springfield Virginia vacation rental, houses for rent in Springfield Virginia, and rental properties in Springfield Virginia
For rent by owner homes in Ashland and vacation rentals in Ashland Virginia
Recurrently, root for, boost, and thump your traveling women and road warriors to a adorable, well-liked, and lovely block.
Ferret out and perceive Isle of Wight vacation homes and Isle of Wight Virginia vacation homes.
Detect and identify vacation rentals in Lightfoot United States and Lightfoot United States short term rentals.
Sailors and globetrotters scour and inquire our webpage and originate rustic castle, city cabin, rustic ranch, and rustic farmhouse.
Learn, uncover, and move apartment rentals in Capeville United States, house rentals in Capeville, and rent house in Capeville United States.
Richmond stretch employs many rental property owners, rental property owners, and real estate brokers.
Identify, design, and discover Amherst Virginia apartments for rent and Amherst Virginia home rentals.
Recently vacated suburban cabin, log vacation home, lake farmhouse, and mountain vacation home are imminent in the nearby field of Richmond Virginia.
Catch and invent condos for rent and rental apartment in Hustle.
Invent and identify Goochland rental houses, holiday rentals in Goochland Virginia, and Goochland Virginia condos for rent.
Romantics, comrades, and traveling men who are wishing to light upon, distinguish, and find out or simply disclose information can use our page.
Send well-formed, stunning, statuesque, and good-looking picture regarding condo rentals, Richmond rental home, and rental home in Richmond found on our online website, FRBO.com.
Join our penthouse ad directories, ski in/out advertisements, hillside directories, and ski in/out classifieds mailing list for rent house in Richmond Virginia, rental houses in Richmond, and Richmond Virginia vacation homes for rent by owner.
Ascertain express, singular, novel, and unusual proof in Richmond and calendar Richmond Virginia real estate rentals.
Espy and detect rental homes and Stuarts Draft United States rental apartment.
|
|
