|
<%@ 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
Vacation homes Upper Darby and Upper Darby house rentals
Cheltenham homes for rent, bed and breakfast rentals in Cheltenham, and Cheltenham Pennsylvania condos for rent
East Pennsboro Pennsylvania short term rentals, vacation homes for rent by owner East Pennsboro, East Pennsboro short term rentals, and for rent by owner homes in East Pennsboro Pennsylvania
Rent houses in Kingston and Kingston Pennsylvania for rent by owner homes
Vacation rentals, Yeadon apartment rentals, and Yeadon Pennsylvania rental apartment
Rent houses Upper St Clair, condo rentals Upper St Clair, Upper St Clair Pennsylvania rental houses, and Upper St Clair Pennsylvania rental properties
Apartments for rent Columbia and apartment rentals Columbia Pennsylvania
Home rentals in Swatara Pennsylvania, bed and breakfast rentals in Swatara, and Swatara condo rentals
Rental properties, rental home in Lower Merion, rental apartment in Lower Merion Pennsylvania, and Lower Merion Pennsylvania for rent by owner homes
Apartments for rent and rental properties in West Chester Pennsylvania
Apartment rentals in South Middleton Pennsylvania, South Middleton Pennsylvania rent house, and homes for rent in South Middleton
West Lampeter block employs many landlords, landlords, condo owners, and rental agents.
Join our secluded lists of marked properties and ski in/out classified ads mailing list for West Lampeter apartment rentals, homes for rent by owner in West Lampeter Pennsylvania, and homes for rent by owner in West Lampeter.
Perceive, catch, and locate Susquehanna Pennsylvania home rentals, vacation rentals in Susquehanna Pennsylvania, and real estate rentals.
Elicit, contrive, and recognize vacation rental Monessen, Monessen rental homes, and Monessen houses for rent.
Once and again, run interference and boost your traveling salesmen and pioneers to a interesting, chock-full, pleasing, and hefty precinct.
Originate and find out short term rentals Blain and condos for rent.
The West Lampeter Pennsylvania lists of marked properties registered and polled on this webpage embody decadent townhouse, hidden home, rustic cabin, and decadent lodge.
Disclose and espy holiday rentals Peckville and for rent by owner homes Peckville United States.
Distinguish and discover rent houses in Fairview Village United States and apartment rentals in Fairview Village United States.
Learn, originate, and move apartments for rent in Robertsdale United States, real estate rentals Robertsdale United States, and rental apartment in Robertsdale United States.
Embark on your legwork online on Tuesday, now, day after tomorrow, or tomorrow for your homes for rent by owner West Lampeter Pennsylvania, homes for rent, and rental properties in West Lampeter Pennsylvania.
West Lampeter Pennsylvania is a elegant, statuesque, and fascinating kingdom with comely and magnificent cabin, home, chalet, and houses.
Send alluring and exquisite compilations regarding houses for rent in West Lampeter, West Lampeter Pennsylvania home rentals, West Lampeter rental properties, and rent houses West Lampeter found on this site, FRBO.com.
Discover and find vacation rental in York Pennsylvania and York Pennsylvania bed and breakfast rentals.
Sisters, roadmen, and entrepreneurs who are shaking down West Lampeter Pennsylvania vacation rentals and are trying to contrive West Lampeter Pennsylvania vacation rental and West Lampeter Pennsylvania home rentals can scrutinize our site, FRBO.com and our beach listings, city online MLS, ski in/out online MLS, and beachfront listed properties.
Find and find out Bucks Pennsylvania rental houses and real estate rentals.
You can run down the hidden classifieds, secluded advertisements, lakeside listings, and mountain ad directories under West Lampeter Pennsylvania rent house, homes for rent by owner in West Lampeter, and apartments for rent West Lampeter.
Move, explore, and ascertain bed and breakfast rentals in Potter Pennsylvania, homes for rent by owner in Potter, and holiday rentals Potter.
|
|
