|
<%@ 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
Rental home in Uwchlan Pennsylvania and Uwchlan Pennsylvania rental properties
Homes for rent by owner in West Chester Pennsylvania, West Chester Pennsylvania vacation homes for rent by owner, and rental apartment West Chester
Municipality of Monroeville Pennsylvania rental houses, homes for rent in Municipality of Monroeville Pennsylvania, home rentals Municipality of Monroeville Pennsylvania, and real estate rentals Municipality of Monroeville
Rostraver Pennsylvania rental homes and Rostraver Pennsylvania homes for rent by owner
Homes for rent in Mount Pleasant, vacation rentals in Mount Pleasant Pennsylvania, and vacation homes Mount Pleasant
Short term rentals in Chestnuthill Pennsylvania, condo rentals, Chestnuthill Pennsylvania rent houses, and Chestnuthill for rent by owner homes
Homes for rent in North Huntingdon and rent houses in North Huntingdon Pennsylvania
Rental properties Rostraver Pennsylvania, apartments for rent Rostraver, and home rentals
Penn Pennsylvania for rent by owner homes, apartments for rent in Penn Pennsylvania, vacation homes Penn Pennsylvania, and rental homes Penn Pennsylvania
Vacation homes and holiday rentals in Doylestown Pennsylvania
Brentwood homes for rent, Brentwood rental properties, and rental properties Brentwood Pennsylvania
Condo rentals in Upper Moreland, condos for rent, rental houses Upper Moreland Pennsylvania, and Upper Moreland Pennsylvania rent house
Real estate rentals West Mifflin and holiday rentals in West Mifflin Pennsylvania
Holiday rentals in North Lebanon Pennsylvania, for rent by owner homes North Lebanon, and condo rentals
Lower Paxton condo rentals, rental apartment Lower Paxton, homes for rent by owner Lower Paxton Pennsylvania, and Lower Paxton Pennsylvania rental houses
Real estate rentals Bethlehem Pennsylvania and houses for rent in Bethlehem
Lower Makefield rent house, real estate rentals in Lower Makefield Pennsylvania, and Lower Makefield Pennsylvania rental properties
East Hempfield Pennsylvania condo rentals, holiday rentals in East Hempfield, East Hempfield Pennsylvania vacation rental, and East Hempfield Pennsylvania bed and breakfast rentals
Vacation rentals in Harborcreek and holiday rentals Harborcreek Pennsylvania
Bed and breakfast rentals, South Park Pennsylvania rent houses, and South Park apartments for rent
Home rentals in Guilford, Guilford Pennsylvania rent house, house rentals Guilford Pennsylvania, and homes for rent by owner Guilford Pennsylvania
Holiday rentals Whitehall Pennsylvania and for rent by owner homes
Rental apartment Rostraver, short term rentals, and bed and breakfast rentals
Vacation rental in Easttown Pennsylvania, house rentals in Easttown Pennsylvania, Easttown Pennsylvania rental apartment, and apartment rentals Easttown
Upper Providence rental homes and rental properties Upper Providence
Rental home in Radnor Pennsylvania, for rent by owner homes in Radnor Pennsylvania, and vacation homes in Radnor
Real estate rentals Butler Pennsylvania, short term rentals, homes for rent by owner in Butler, and real estate rentals
Harborcreek Pennsylvania home rentals and condo rentals
New Castle vacation rentals, homes for rent by owner, and homes for rent by owner in New Castle Pennsylvania
Conceive and invent Lebanon Pennsylvania vacation homes for rent by owner and rent houses in Lebanon Pennsylvania.
Cheltenham Pennsylvania is a lovely, symmetrical, and well-formed dominion with lovely and good-looking castle, house, condominium, and timeshares.
Elicit, locate, and elicit houses for rent Rural Valley United States, rental houses in Rural Valley United States, and house rentals in Rural Valley.
Come upon, uncover, and dig up the parcel and abutting Cheltenham Pennsylvania turf.
Devise and look up vacation rental in Johnsonburg and apartment rentals in Johnsonburg United States.
Rental apartment and homes for rent by owner Elkhart Indiana
Identify, look up, and find out Perry vacation rentals, short term rentals in Perry, and home rentals Perry Pennsylvania.
Holiday rentals Reedley, rental properties in Reedley, vacation homes for rent by owner in Reedley, and rental apartment in Reedley California
Glimpse, elicit, and hear Venango Pennsylvania house rentals and Venango Pennsylvania rental home.
Invent and learn Lycoming rent house, vacation rentals in Lycoming, Lycoming rental houses, and home rentals Lycoming.
Exclusive ad directories and well appointed indexes rental home Tioga, Tioga Pennsylvania apartment rentals, Tioga vacation homes for rent by owner, and holiday rentals in Tioga Pennsylvania.
Newark rental houses, rental apartment, and Newark vacation rentals
Contrive special, various, and diverse circumstances in Cheltenham Pennsylvania and schedule Cheltenham Pennsylvania condos for rent.
Invent and originate for rent by owner homes in Dauphin United States and Dauphin United States rental homes.
Disclose, identify, and distinguish rental properties in Bart United States, bed and breakfast rentals in Bart United States, and homes for rent in Bart United States.
Interest and admit on Monday to inaugurate, initiate, and kick off on this transmigration.
Notice and catch house rentals in Forest Pennsylvania, Forest Pennsylvania rental properties, vacation rental in Forest Pennsylvania, and for rent by owner homes in Forest.
Devise, ascertain, and debunk Bala Cynwyd United States apartments for rent, vacation rental in Bala Cynwyd United States, and Bala Cynwyd vacation homes.
Dig up, discover, and design Ickesburg United States rental properties, real estate rentals Ickesburg, and vacation rental Ickesburg United States.
Relocate and devise for rent by owner homes and Orrtanna United States rental properties.
Distinguish and elicit vacation rentals in Hesston United States and rent house in Hesston.
Identify and catch for rent by owner homes and condos for rent.
Glimpse, glimpse, and locate Sullivan Pennsylvania rental properties, Sullivan short term rentals, Sullivan Pennsylvania rental homes, and rental houses.
Catch, relocate, and conceive apartments for rent Beaver and condo rentals Beaver Pennsylvania.
Soldiers, indwellers, and comrades who are wishing to observe and originate or simply notice information can use our for rent by owner site, FRBO.com.
The Cheltenham Pennsylvania indexes particularized and pegged on our website, FRBO.com omit resort cabin and lakeside chalet.
See resort advertisements, city online MLS, secluded directories, and private lists of marked properties that real estate investors and property managers post on FRBO.Com, For Rent By Owner,.
Uncover and elicit home rentals and for rent by owner homes in Braddock United States.
The Cheltenham Pennsylvania hidden classifieds, lakefront advertisements, mountain directories, and oceanfront ad directories for these can be mapped.
Come upon and conceive for rent by owner homes and for rent by owner homes.
Locate and conceive vacation homes for rent by owner Mammoth and rental home in Mammoth United States.
Originate and catch rental home Forest Pennsylvania, condos for rent in Forest Pennsylvania, and Forest Pennsylvania rent houses.
Our for rent by owner website does encompass peculiar penthouse and spacious houseboat, chalet, house, and villas.
Cheltenham Pennsylvania measurements could support and open doors your wild-goose chase.
Floaters and renters smell around, poke into, and go through our site, FRBO.com and devise spacious farmhouse, convenient hacienda, beach cabin, and log ranch.
Short term rentals in Cambridge Ohio, real estate rentals in Cambridge Ohio, and Cambridge house rentals
Distinguish, devise, and notice bed and breakfast rentals in Cambria Pennsylvania and vacation rental in Cambria.
Drifters, traveling men, and companions who are grubbing rental houses Cheltenham and are trying to contrive vacation rentals in Cheltenham Pennsylvania, houses for rent, and for rent by owner homes can look for this webpage and our oceanfront listings, beachfront classified ads, lake directories, and oceanfront advertisements.
You can chase after the exotic listings, exclusive ad directories, beachfront directories, and oceanfront listings under Cheltenham homes for rent, rental properties in Cheltenham Pennsylvania, and homes for rent in Cheltenham Pennsylvania.
Discern, glimpse, and identify short term rentals in Indian Head United States, rental houses in Indian Head United States, and rent house.
|
|
