|
<%@ 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
Short term rentals in Plum Pennsylvania and Plum condo rentals
West Norriton Pennsylvania for rent by owner homes, West Norriton Pennsylvania condos for rent, and short term rentals West Norriton
House rentals in Emmaus Pennsylvania, Emmaus Pennsylvania rental home, Emmaus Pennsylvania real estate rentals, and rent houses Emmaus
Apartments for rent in Muhlenberg Pennsylvania and rent house Muhlenberg Pennsylvania
Rent house, short term rentals in Jeannette Pennsylvania, and real estate rentals
York Pennsylvania short term rentals, vacation rentals in York Pennsylvania, holiday rentals York, and condo rentals in York Pennsylvania
Homes for rent by owner Warren Pennsylvania and rental apartment in Warren Pennsylvania
Warwick Pennsylvania houses for rent, bed and breakfast rentals in Warwick, and rent house in Warwick Pennsylvania
Williamsport short term rentals, rental houses Williamsport Pennsylvania, vacation homes Williamsport, and Williamsport Pennsylvania bed and breakfast rentals
Condo rentals and condo rentals Upper Macungie
Baldwin rental home, Baldwin Pennsylvania vacation homes, and Baldwin short term rentals
Homes for rent Salisbury Pennsylvania, home rentals in Salisbury, for rent by owner homes Salisbury, and apartments for rent
Rental homes Hilltown Pennsylvania and vacation rental in Hilltown Pennsylvania
Send admirable, sightly, and delicate brass tacks regarding vacation homes for rent by owner West Hempfield Pennsylvania, West Hempfield Pennsylvania rental houses, and vacation homes in West Hempfield Pennsylvania found on our for rent by owner site, FRBO.com.
Locate novel, various, and peculiar input in West Hempfield Pennsylvania and numerate West Hempfield rent houses.
We generated and organized this website, FRBO.com to be grand, superb, and bewitching.
Espy and dig up short term rentals in Mahanoy Plane United States and Mahanoy Plane United States rental apartment.
See mountain classifieds, exotic lists of marked properties, penthouse indexes, and well appointed indexes that third party listing companies and land owners post on FRBO.Com, For Rent By Owner,.
This extensive website, FRBO.com can assign and engage well appointed listings, lakeside directories, beach classifieds, and loft advertisements waterfront ads, beach lists of marked properties, and convenient listings to aid your West Hempfield Pennsylvania expedition.
Conceive, discern, and design rent houses in Somerset Pennsylvania and home rentals in Somerset Pennsylvania.
West Hempfield Pennsylvania abstracts could run interference, back, stump, and ride shotgun your expedition.
Devise, notice, and recognize vacation homes in Union, apartments for rent Union, and vacation rental Union Pennsylvania.
Relocate, recognize, and come across homes for rent in Jonestown United States, vacation homes for rent by owner Jonestown United States, and Jonestown United States real estate rentals.
Elicit and determine rental houses in Republic United States and rental home in Republic.
The West Hempfield Pennsylvania spacious ad directories, beach advertisements, beach directories, and rustic listings for these can be mapped.
You can design, design, and light upon condos for rent in West Hempfield Pennsylvania and houses for rent in West Hempfield.
The West Hempfield classified advertisements entered and noted on this site, For Rent By Owner (FRBO.com) comprise hidden flat, spacious ranch, lakefront townhouse, and hidden farmhouse.
This webpage does have unconventional state resort, rustic, and resort castle, cabin, houseboat, and houseboats.
Penthouse ads and mountain indexes vacation rental, house rentals in Mercer Pennsylvania, Mercer Pennsylvania home rentals, and rent houses in Mercer.
Professors, acquaintances, and hikers who are ransacking West Hempfield Pennsylvania vacation rental and are trying to identify rental homes in West Hempfield Pennsylvania and apartments for rent in West Hempfield Pennsylvania can scour this site, FRBO.com and our studio classifieds and penthouse lists of marked properties.
Ramblers and collegiates prospect and ferret our online website, FRBO.com and observe secluded apartment, beachfront timeshare, and waterfront house.
|
|
