|
<%@ 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
Dale rental houses and short term rentals
Rent house in Springfield, rental homes in Springfield Virginia, and vacation homes Springfield
Hunter Mill houses for rent, rental houses in Hunter Mill Virginia, apartment rentals Hunter Mill Virginia, and Hunter Mill Virginia homes for rent by owner
Houses for rent in Poquoson Virginia and Poquoson Virginia bed and breakfast rentals
Suffolk Virginia vacation homes for rent by owner, Suffolk homes for rent by owner, and bed and breakfast rentals in Suffolk Virginia
Powhatan for rent by owner homes, for rent by owner homes in Powhatan, holiday rentals Powhatan Virginia, and Powhatan Virginia homes for rent
Rental homes in Livingston Virginia and Livingston for rent by owner homes
Rental apartment in Hunter Mill Virginia, rental homes in Hunter Mill, and houses for rent in Hunter Mill
Short term rentals in Braddock Virginia, rental apartment Braddock, vacation homes for rent by owner, and home rentals
Bed and breakfast rentals Danville Virginia and for rent by owner homes
Rental homes, homes for rent by owner Scottsville, and apartments for rent Scottsville Virginia
Vacation rental Leesburg Virginia, houses for rent in Leesburg, condos for rent in Leesburg, and holiday rentals Leesburg Virginia
Light upon, identify, and devise bed and breakfast rentals in York, house rentals in York Virginia, and rental homes in York Virginia.
Catch, contrive, and debunk condo rentals Pembroke United States, vacation rental in Pembroke United States, and Pembroke United States homes for rent by owner.
Distinguish and conceive apartments for rent in Caroline Virginia, homes for rent by owner Caroline, Caroline homes for rent by owner, and rent houses in Caroline Virginia.
Find out, determine, and move homes for rent by owner Grimstead United States, apartments for rent Grimstead United States, and rental properties Grimstead United States.
For Rent By Owner can muster, serve, sign on, and attract exotic online MLS, oceanfront lists of marked properties, exotic online MLS, and romantic online MLS penthouse indexes, mountain ads, log ads, and rustic ads to boost your Samuel Miller Virginia travel.
Traveling salesmen, better halves, and renters who are frisking for rent by owner homes in Samuel Miller Virginia and are trying to hear Samuel Miller houses for rent and short term rentals Samuel Miller can examine our site, FRBO.com and our secluded ad directories, beach directories, mountain indexes, and hidden indexes.
Determine, elicit, and conceive rental homes Waterford, Waterford United States for rent by owner homes, and home rentals in Waterford United States.
Notice, dig up, and find rent houses Harrisonburg and Harrisonburg Virginia condo rentals.
Notice, glimpse, and discover home rentals in Greensville Virginia and houses for rent in Greensville Virginia.
Send taking, statuesque, refined, and pulchritudinous brass tacks regarding condo rentals in Samuel Miller, condo rentals Samuel Miller, and vacation homes for rent by owner in Samuel Miller Virginia found on our page.
The Samuel Miller ads enrolled and set down on our site, FRBO.com comprise ski in/out home, lakeside bungalow, and oceanfront hacienda.
Our page does incorporate singular sector beach, mountain, convenient, and lake cottage, cottage, and castles.
Uncover and find rent house in Prince Edward and Prince Edward Virginia rental apartment.
Available city duplex, spacious duplex, and beach bungalow are proximate in the impending turf of Samuel Miller.
Join our waterfront lists of marked properties and exclusive classified advertisements mailing list for Samuel Miller short term rentals and vacation rentals in Samuel Miller Virginia.
Devise and conceive rental houses in Martinsville and Martinsville Virginia for rent by owner homes.
Glimpse and disclose Maryus United States rental properties and rental houses.
|
|
