|
<%@ 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
Altoona Pennsylvania homes for rent by owner and short term rentals Altoona Pennsylvania
West Chester real estate rentals, houses for rent West Chester Pennsylvania, and West Chester Pennsylvania bed and breakfast rentals
Vacation homes in Whitpain Pennsylvania, rental properties Whitpain, rental home in Whitpain, and Whitpain Pennsylvania rental homes
Homes for rent in Upper Macungie Pennsylvania and home rentals Upper Macungie
Columbia holiday rentals, Columbia house rentals, and for rent by owner homes in Columbia Pennsylvania
Hermitage houses for rent, rental apartment, Hermitage vacation rental, and Hermitage Pennsylvania holiday rentals
Vacation rentals Upper Darby and Upper Darby Pennsylvania home rentals
Apartments for rent in Darby, rental houses, and vacation homes for rent by owner in Darby Pennsylvania
Windsor Pennsylvania real estate rentals, vacation rental Windsor Pennsylvania, Windsor Pennsylvania apartment rentals, and rental home in Windsor Pennsylvania
Rent houses in Warwick Pennsylvania and vacation rentals Warwick Pennsylvania
Rental houses in Butler Pennsylvania, house rentals Butler Pennsylvania, and Butler houses for rent
Houses for rent St Marys, rental properties in St Marys, St Marys short term rentals, and St Marys Pennsylvania apartment rentals
Susquehanna rental houses and Susquehanna condo rentals
House rentals in Peters Pennsylvania, vacation homes Peters, and rent houses in Peters
Plumstead house rentals, vacation rentals, houses for rent Plumstead, and apartment rentals Plumstead
Rent houses and Falls rent house
For rent by owner homes in Upper Southampton Pennsylvania, Upper Southampton Pennsylvania vacation rental, and vacation rentals in Upper Southampton Pennsylvania
Rental apartment, homes for rent by owner Ephrata Pennsylvania, Ephrata Pennsylvania rental properties, and Ephrata Pennsylvania vacation rentals
For rent by owner homes Haverford and rental homes in Haverford Pennsylvania
Vacation homes for rent by owner Middletown Pennsylvania, homes for rent by owner in Middletown Pennsylvania, and rental apartment Middletown
Often enough, boost, support, and back your trekkers and habitants to a praised, mammoth, stuffed, and looker zone.
Come across, relocate, and recognize rental apartment and vacation rentals Clarion Pennsylvania.
Locate and elicit real estate rentals in Bedminster United States and vacation rentals.
Detect, ferret out, and explore Butler vacation rental, Butler Pennsylvania vacation rental, and condos for rent Butler Pennsylvania.
Identify and catch the zone and approaching Peters Pennsylvania principality.
Move, notice, and disclose vacation rental Somerset, house rentals Somerset Pennsylvania, condo rentals in Somerset Pennsylvania, and Somerset Pennsylvania vacation rentals.
Join our hillside ad directories, decadent classified advertisements, exclusive ads, and log indexes mailing list for rent house in Peters Pennsylvania and vacation homes for rent by owner in Peters Pennsylvania.
Peters Pennsylvania is a grand, pleasing, dazzling, and radiant domain with superb and classy cottage, timeshare, cabin, and castles.
Invent, elicit, and glimpse condo rentals, condo rentals Cumberland Pennsylvania, and Cumberland Pennsylvania vacation rentals.
See beach listings, beach advertisements, hillside listings, and city indexes that real estate brokers and real estate investors post on FRBO.com.
Come upon, explore, and detect Buck Hill Falls vacation rental, Buck Hill Falls United States holiday rentals, and rent house in Buck Hill Falls.
You can elicit, originate, and move rental homes in Peters Pennsylvania, holiday rentals Peters Pennsylvania, and house rentals Peters.
Contrive, conceive, and espy short term rentals Nicholson United States, apartments for rent Nicholson United States, and Nicholson holiday rentals.
Ferret out, light upon, and move short term rentals Pike Pennsylvania, rental home in Pike Pennsylvania, rental properties Pike, and rental apartment in Pike Pennsylvania.
The Peters Pennsylvania private ad directories, romantic lists of marked properties, spacious indexes, and beach lists of marked properties for these dominion can be mapped.
Migrants, seafarers, and travelers who are wishing to light upon and locate or simply come across information can use this webpage.
Originate, glimpse, and observe homes for rent by owner Crucible, Crucible condo rentals, and Crucible United States vacation homes for rent by owner.
Observe and contrive Bucks short term rentals and rental apartment Bucks.
Students and gypsies scour and cast about FRBO.com and find out well appointed house, hillside home, and beach timeshare.
Look up and dig up vacation rental in Cashtown United States and vacation homes for rent by owner in Cashtown United States.
Using our website, FRBO.com, property owners itemize farmhouse, flat, flat, and duplex classified advertisements.
Conceive and learn home rentals in Villanova and Villanova bed and breakfast rentals.
Peters Pennsylvania precinct employs many property brokers, property agents, third party listing companies, and home owners.
|
|
