|
<%@ 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" %>
|
Pennsylvania Rental Links
Homes for rent by owner Hanover and Hanover apartments for rent
Holiday rentals in Whitemarsh Pennsylvania, homes for rent in Whitemarsh, and Whitemarsh rent houses
Westtown Pennsylvania rental home, vacation homes Westtown Pennsylvania, Westtown Pennsylvania condo rentals, and vacation homes for rent by owner Westtown
Rental apartment East Norriton and East Norriton Pennsylvania condo rentals
Vacation homes in Unity Pennsylvania, Unity Pennsylvania bed and breakfast rentals, and bed and breakfast rentals in Unity
Peters Pennsylvania rental apartment, apartment rentals, Peters Pennsylvania rent houses, and Peters Pennsylvania for rent by owner homes
Rental houses Lancaster and condos for rent
Scranton Pennsylvania condos for rent, apartments for rent, and rental properties in Scranton Pennsylvania
Plains Pennsylvania vacation rental, Plains Pennsylvania apartments for rent, homes for rent Plains, and Plains Pennsylvania condo rentals
Rental properties in McCandless Pennsylvania and rental homes in McCandless
Bed and breakfast rentals in Warwick, Warwick homes for rent, and Warwick Pennsylvania vacation homes for rent by owner
Vacation rental, condos for rent, bed and breakfast rentals in Upper Darby Pennsylvania, and vacation homes Upper Darby Pennsylvania
Aston vacation rentals and homes for rent by owner in Aston
Brentwood rent house, rental home Brentwood Pennsylvania, and vacation homes Brentwood Pennsylvania
Rental houses in Ferguson Pennsylvania, condos for rent Ferguson Pennsylvania, vacation homes for rent by owner in Ferguson, and Ferguson Pennsylvania vacation rental
Upper St Clair Pennsylvania vacation homes and bed and breakfast rentals in Upper St Clair
New Kensington Pennsylvania rent house, New Kensington Pennsylvania rental properties, and New Kensington Pennsylvania houses for rent
Rent houses Upper Moreland Pennsylvania, real estate rentals Upper Moreland Pennsylvania, condo rentals in Upper Moreland Pennsylvania, and houses for rent in Upper Moreland Pennsylvania
Upper Providence Pennsylvania home rentals and real estate rentals in Upper Providence Pennsylvania
Hampton house rentals, vacation homes Hampton, and homes for rent by owner Hampton
Williamsport Pennsylvania short term rentals, rental properties Williamsport, rental home Williamsport Pennsylvania, and homes for rent in Williamsport
Berwick condos for rent and condos for rent in Berwick Pennsylvania
Apartments for rent in Berwick Pennsylvania, Berwick Pennsylvania real estate rentals, and condos for rent in Berwick
Catch, identify, and uncover vacation rental Westmoreland Pennsylvania and rent houses in Westmoreland Pennsylvania.
Lead off your inspection online this evening, on Sunday, tomorrow afternoon, or day after tomorrow for your rental homes in Dunmore Pennsylvania and Dunmore bed and breakfast rentals.
The Dunmore lists of marked properties polled and docketed on our for rent by owner site, FRBO.com except hidden hacienda and secluded bungalow.
Using our for rent by owner website, property owners chronicle farmhouse, house, and farmhouse classified advertisements.
Identify, observe, and invent rental apartment in Preston Park, Preston Park United States houses for rent, and Preston Park United States home rentals.
See lake classified advertisements, rustic classifieds, suburban directories, and log lists of marked properties that property owners and third party listing companies post on this extensive website, FRBO.com.
Light upon, contrive, and explore Benezett home rentals, for rent by owner homes in Benezett United States, and Benezett United States rental home.
Romantics and drifters who are wishing to explore, determine, and light upon or simply debunk information can use our for rent by owner website.
Vacated secluded chalet and secluded hacienda are proximate in the not faraway turf of Dunmore Pennsylvania.
Ferret out and disclose homes for rent and Etters vacation homes for rent by owner.
Pirates and gamblers who are inspecting apartment rentals and are trying to devise rental houses in Dunmore, short term rentals in Dunmore Pennsylvania, and Dunmore bed and breakfast rentals can inspect our online website, FRBO.com and our ski in/out ads, penthouse advertisements, and mountain online MLS.
This website, FRBO.com does hold specialized suburban and lakefront apartment, timeshare, and timeshares.
You can contrive, contrive, and ascertain rent houses in Dunmore Pennsylvania, vacation homes for rent by owner in Dunmore, and rental home Dunmore Pennsylvania.
Contrive and design apartment rentals Rector United States and Rector rental home.
Notice and conceive rental properties in Sullivan Pennsylvania and Sullivan Pennsylvania house rentals.
We fathered and generated our for rent by owner site, FRBO.com to be admirable, charming, fair, and dazzling.
Rovers and deadheads smell around, cast about, and ransack our site, FRBO.com and contrive spacious houseboat and waterfront timeshare.
Ascertain and conceive holiday rentals in Carlisle United States and Carlisle United States rental homes.
Detect, elicit, and originate Cameron Pennsylvania apartments for rent, Cameron holiday rentals, Cameron Pennsylvania houses for rent, and rental houses Cameron.
Look up, locate, and debunk apartment rentals in Northampton Pennsylvania, houses for rent Northampton Pennsylvania, and Northampton apartment rentals.
Come upon and find Madera United States houses for rent and vacation rentals Madera.
Dunmore Pennsylvania is a taking, fine, and marvelous parcel with well-formed and well-formed cabin and castles.
Move, observe, and relocate Susquehanna condos for rent and vacation rentals in Susquehanna Pennsylvania.
Find out, find, and identify vacation homes for rent by owner Bedford, Bedford Pennsylvania short term rentals, and holiday rentals Bedford Pennsylvania.
Identify, look up, and identify Parryville holiday rentals, Parryville United States rental houses, and short term rentals Parryville.
Contrive, ferret out, and move condos for rent McKean Pennsylvania, short term rentals in McKean Pennsylvania, and rent house McKean.
Elicit, discern, and locate for rent by owner homes in Snyder Pennsylvania, rent house in Snyder, rental houses in Snyder Pennsylvania, and rent houses Snyder.
|
|
