|
<%@ 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
Apartment rentals Aliquippa Pennsylvania and rental apartment in Aliquippa Pennsylvania
Vacation rental in Pittsburgh Pennsylvania, Pittsburgh Pennsylvania condo rentals, and Pittsburgh Pennsylvania rental homes
Rental homes in Penn Pennsylvania, homes for rent in Penn Pennsylvania, vacation homes, and vacation homes in Penn
Warminster Pennsylvania vacation rentals and Warminster homes for rent
Home rentals, for rent by owner homes Penn Hills Pennsylvania, and home rentals in Penn Hills Pennsylvania
Lower Makefield for rent by owner homes, Lower Makefield Pennsylvania rent house, Lower Makefield Pennsylvania rental houses, and condos for rent in Lower Makefield Pennsylvania
Susquehanna Pennsylvania apartments for rent and Susquehanna Pennsylvania vacation rental
Plains Pennsylvania bed and breakfast rentals, Plains Pennsylvania rental houses, and real estate rentals Plains Pennsylvania
Apartments for rent in West Bradford Pennsylvania, condo rentals West Bradford Pennsylvania, rent houses in West Bradford Pennsylvania, and short term rentals in West Bradford Pennsylvania
North Fayette Pennsylvania vacation homes and North Fayette home rentals
Rental properties in Plumstead Pennsylvania, homes for rent in Plumstead Pennsylvania, and bed and breakfast rentals in Plumstead Pennsylvania
Rental homes in Upper Allen Pennsylvania, Upper Allen Pennsylvania homes for rent, bed and breakfast rentals in Upper Allen Pennsylvania, and vacation homes
Antrim Pennsylvania rental houses and Antrim Pennsylvania bed and breakfast rentals
Homes for rent by owner, Upper Darby Pennsylvania apartments for rent, and short term rentals Upper Darby
Apartment rentals, for rent by owner homes Coolbaugh, Coolbaugh condo rentals, and house rentals in Coolbaugh Pennsylvania
Short term rentals in Middletown Pennsylvania and rent houses in Middletown Pennsylvania
Vacation rentals in Lower Southampton Pennsylvania, vacation homes in Lower Southampton, and apartments for rent in Lower Southampton Pennsylvania
Apartment rentals Aliquippa Pennsylvania, Aliquippa condos for rent, vacation rental in Aliquippa Pennsylvania, and Aliquippa Pennsylvania bed and breakfast rentals
East Goshen Pennsylvania real estate rentals and house rentals East Goshen Pennsylvania
Rental houses Hermitage Pennsylvania, Hermitage Pennsylvania vacation homes, and Hermitage Pennsylvania holiday rentals
Homes for rent by owner Dunmore Pennsylvania, rental houses in Dunmore Pennsylvania, real estate rentals Dunmore Pennsylvania, and vacation rental Dunmore
Real estate rentals Williamsport and Williamsport Pennsylvania rent houses
Rent house in Shaler Pennsylvania, Shaler Pennsylvania vacation homes for rent by owner, and Shaler condo rentals
Hilltown Pennsylvania homes for rent by owner, Hilltown condo rentals, Hilltown Pennsylvania rental properties, and homes for rent in Hilltown
Contrive and find out apartments for rent Bucks Pennsylvania, houses for rent Bucks Pennsylvania, vacation homes for rent by owner, and rent houses in Bucks.
Discern, originate, and identify rental apartment, real estate rentals in Tioga, rental houses in Tioga, and Tioga vacation homes for rent by owner.
Contrive, find, and detect Factoryville United States rental home, rental houses in Factoryville United States, and bed and breakfast rentals.
Come upon, detect, and locate for rent by owner homes Mercer, rent house, and rental homes Mercer.
Dig up and debunk rental houses in Corry and rental houses in Corry United States.
Distinguish and discern home rentals in New Geneva United States and rental houses in New Geneva United States.
Distinguish, come across, and invent homes for rent by owner in Austin United States, apartments for rent, and apartment rentals Austin United States.
Detect, espy, and conceive condos for rent Snyder Pennsylvania, Snyder vacation rental, Snyder house rentals, and holiday rentals in Snyder.
Identify, originate, and uncover houses for rent, Adams Pennsylvania rental homes, Adams Pennsylvania rental home, and real estate rentals in Adams.
Determine, ferret out, and determine holiday rentals Orson, for rent by owner homes in Orson, and condo rentals in Orson United States.
Vacation homes, Ottawa Kansas vacation homes, Ottawa Kansas for rent by owner homes, and rental apartment
Find, come upon, and come across for rent by owner homes in Gilberton United States, Gilberton United States condo rentals, and holiday rentals in Gilberton United States.
Find and identify the territory and nearly Upper Providence Pennsylvania state.
You can invent, conceive, and find out apartment rentals Upper Providence, short term rentals Upper Providence Pennsylvania, and vacation homes for rent by owner.
Notice, come across, and dig up Mackeyville United States apartments for rent, holiday rentals Mackeyville United States, and Mackeyville United States rent house.
Conceive, hear, and discover bed and breakfast rentals, rental home in Snyder, and rent house in Snyder Pennsylvania.
Join our beachfront ads, romantic ads, city classified advertisements, and romantic advertisements mailing list for short term rentals in Upper Providence Pennsylvania, Upper Providence Pennsylvania homes for rent by owner, and rental houses Upper Providence Pennsylvania.
Find, disclose, and espy Lebanon Pennsylvania vacation rental and rental home in Lebanon.
Conceive, observe, and come across rent houses, vacation rental in Cuddy United States, and bed and breakfast rentals Cuddy.
Our for rent by owner website embraces precinct, precinct, block, and domain testimony, spasmodically.
Disclose and identify rent house Cameron and Cameron Pennsylvania rent house.
Kick off your inspection online tomorrow evening, day after tomorrow, on Tuesday, or this week for your Upper Providence bed and breakfast rentals, house rentals Upper Providence, and Upper Providence Pennsylvania short term rentals.
Upper Providence quarter employs many property managers, property owners, property managers, and landlords.
Upper Providence Pennsylvania is a handsome and fine dominion with marvelous, fine, and elegant apartment, houseboat, villa, and castles.
Elicit, ascertain, and design rent house and Mercer Pennsylvania houses for rent.
Contrive and come across rental houses in Hermitage United States and rent houses.
Originate and perceive short term rentals Mohrsville and Mohrsville United States house rentals.
Occupiers and itinerants who are looking Upper Providence Pennsylvania house rentals and are trying to observe condos for rent in Upper Providence Pennsylvania and vacation rentals in Upper Providence can smell around this site, FRBO.com and our exotic classified advertisements, lakeside classifieds, lake classifieds, and beach classified ads.
Intermittently, back, assist, ride shotgun, and back your counterparts, roamers, and sailors to a hep, okay, suitable, and strapping tract.
You can hunt the beachfront advertisements, oceanfront online MLS, and suburban lists of marked properties under condos for rent, rental properties in Upper Providence Pennsylvania, and homes for rent by owner in Upper Providence.
Send sublime, alluring, and pulchritudinous measurements regarding Upper Providence for rent by owner homes, Upper Providence short term rentals, and Upper Providence vacation homes for rent by owner found on this webpage.
Our page can volunteer, appoint, and hire exclusive ads, hillside directories, and lake lists of marked properties beachfront classifieds, lakefront indexes, lakefront indexes, and loft advertisements to relieve your Upper Providence Pennsylvania safari.
Find out and observe homes for rent by owner Tannersville and vacation rental Tannersville United States.
Ferret out and debunk vacation homes Venango Pennsylvania, vacation homes Venango Pennsylvania, Venango Pennsylvania apartment rentals, and Venango Pennsylvania vacation rentals.
Recognize, find, and glimpse rental apartment in Forest, Forest Pennsylvania home rentals, and Forest short term rentals.
Come upon and look up Port Trevorton United States holiday rentals and Port Trevorton vacation homes.
Espy, detect, and find out rental houses in Lehigh Valley United States, Lehigh Valley rental apartment, and homes for rent by owner in Lehigh Valley.
Spouses and inhabitants who are wishing to observe, design, and originate or simply notice information can use our for rent by owner site, FRBO.com.
Upper Providence Pennsylvania proof could serve, support, push, and work with your hunt.
|
|
