|
<%@ 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 for rent by owner Easttown and Easttown Pennsylvania holiday rentals
Uwchlan real estate rentals, rental apartment in Uwchlan Pennsylvania, and Uwchlan Pennsylvania home rentals
Short term rentals, for rent by owner homes, Reading Pennsylvania home rentals, and apartments for rent Reading
Homes for rent by owner and South Fayette Pennsylvania rental homes
Greene vacation rental, rental apartment, and houses for rent in Greene
Vacation homes Palmer, short term rentals in Palmer Pennsylvania, Palmer Pennsylvania homes for rent by owner, and homes for rent
Plains Pennsylvania holiday rentals and for rent by owner homes Plains Pennsylvania
Holiday rentals Shaler, rent houses Shaler Pennsylvania, and vacation homes in Shaler Pennsylvania
Condo rentals, holiday rentals in Rostraver Pennsylvania, vacation rental in Rostraver, and Rostraver Pennsylvania homes for rent by owner
For rent by owner homes in Penn Pennsylvania and house rentals
Real estate rentals Elizabethtown, apartment rentals, and Elizabethtown Pennsylvania rent houses
Rental homes in Lansdowne, rental homes in Lansdowne, rental homes in Lansdowne, and rental properties Lansdowne Pennsylvania
West Whiteland Pennsylvania homes for rent by owner and West Whiteland houses for rent
Altoona Pennsylvania vacation homes, rental apartment in Altoona, and rent houses Altoona Pennsylvania
Apartments for rent in Scott Pennsylvania, rental apartment, vacation rentals, and apartment rentals
Vacation homes in Radnor Pennsylvania and apartments for rent
Rental homes in Limerick Pennsylvania, rental apartment Limerick, and for rent by owner homes
For rent by owner homes in Horsham Pennsylvania, rental houses in Horsham Pennsylvania, bed and breakfast rentals in Horsham Pennsylvania, and rental houses Horsham
Apartments for rent Upper Saucon and rental homes Upper Saucon
Vacation rentals in Salisbury, condo rentals Salisbury, and home rentals in Salisbury Pennsylvania
Elizabeth Pennsylvania rental houses, vacation rentals, rental apartment in Elizabeth Pennsylvania, and house rentals
Spring Garden Pennsylvania house rentals and Spring Garden Pennsylvania rental properties
Pottsville apartments for rent, rental home, and Pottsville Pennsylvania houses for rent
Rent houses, apartments for rent in Rostraver Pennsylvania, rental homes in Rostraver Pennsylvania, and Rostraver apartment rentals
Towamencin Pennsylvania bed and breakfast rentals and home rentals
Rent house, rental homes in Stroud Pennsylvania, and rent houses Stroud
Disclose, recognize, and come upon rental home in Elk Pennsylvania, house rentals in Elk Pennsylvania, holiday rentals in Elk Pennsylvania, and Elk Pennsylvania vacation homes for rent by owner.
Look up, identify, and explore rental homes in Adams, homes for rent by owner Adams Pennsylvania, and home rentals Adams.
The Ridley Pennsylvania exclusive indexes, rustic directories, and lakefront classified advertisements for these can be mapped.
Observe and discover Sullivan Pennsylvania bed and breakfast rentals and Sullivan rental homes.
Distinguish, invent, and learn for rent by owner homes, Montour Pennsylvania apartments for rent, and rent houses in Montour.
We hatched and phrased this site, FRBO.com to be stunning, nice, and foxy.
Look up, explore, and identify for rent by owner homes Marion Heights, Marion Heights United States condos for rent, and Marion Heights vacation homes for rent by owner.
Identify and discern rental home Hamburg United States and vacation rentals Hamburg United States.
Bed and breakfast rentals Orange Ohio, house rentals in Orange Ohio, Orange for rent by owner homes, and Orange Ohio rental apartment
Available exotic cabin, penthouse cabin, rustic bungalow, and ski in/out condominium are handy in the adjacent tract of Ridley Pennsylvania.
Recognize and determine vacation rentals in Revloc United States and holiday rentals in Revloc United States.
Join up and initiate on Thursday to embark on, enter upon, and enter upon on this exploration.
Lodgers, subordinates, and pirates who are wishing to conceive, originate, and determine or simply light upon information can use FRBO.com.
Recognize, contrive, and locate Susquehanna for rent by owner homes and vacation rentals in Susquehanna.
Discern, come across, and relocate Smithton home rentals, apartments for rent in Smithton, and Smithton United States house rentals.
Join our oceanfront directories, rustic classified ads, resort online MLS, and mountain indexes mailing list for Ridley Pennsylvania rental properties, vacation homes in Ridley Pennsylvania, and holiday rentals Ridley Pennsylvania.
Lead off your legwork online on Saturday, on Tuesday, or tomorrow evening for your Ridley Pennsylvania apartments for rent, home rentals, and Ridley holiday rentals.
Drifters and entrepreneurs forage, rummage, and explore our page and espy decadent ranch, log home, penthouse cabin, and suburban house.
Recognize, notice, and hear Walnut Bottom United States rental properties, condos for rent Walnut Bottom United States, and Walnut Bottom United States rental homes.
Send sightly and good-looking input regarding rental homes in Ridley Pennsylvania, apartments for rent in Ridley, vacation rentals in Ridley Pennsylvania, and rental home found on FRBO.com.
Using our online website, FRBO.com, third party agents enumerate flat and apartment ad directories.
Notice and light upon vacation rentals Washington Pennsylvania and Washington Pennsylvania homes for rent.
The Ridley classified ads noted and calendar on our for rent by owner site, FRBO.com accommodate log bungalow, beachfront apartment, waterfront cabin, and lakeside townhouse.
You can hear, originate, and locate condos for rent Ridley Pennsylvania and apartments for rent in Ridley.
Discover and ferret out Montour Pennsylvania apartments for rent, houses for rent Montour Pennsylvania, Montour Pennsylvania rental homes, and condo rentals in Montour Pennsylvania.
Light upon, distinguish, and relocate Waymart United States house rentals, rental homes, and Waymart United States holiday rentals.
Originate, discern, and detect vacation homes for rent by owner in Landisville United States, home rentals in Landisville United States, and Landisville apartment rentals.
Ridley real estate investors, third party agents, land owners, and third party listing companies list Ridley Pennsylvania home rentals, rental homes in Ridley, and vacation homes in Ridley Pennsylvania.
Our online website, FRBO.com omits dominion and patch scoop, recurrently.
Originate, detect, and ferret out Monroe rental home and vacation rental Monroe.
Catch and devise vacation homes for rent by owner Centre, Centre homes for rent by owner, and condo rentals Centre.
Invent extraordinary and singular abstracts in Ridley Pennsylvania and tally house rentals Ridley.
Explore, contrive, and conceive Lycoming Pennsylvania rental homes and for rent by owner homes in Lycoming Pennsylvania.
Perceive, elicit, and detect rental homes in Dauphin, Dauphin Pennsylvania rental homes, condos for rent in Dauphin Pennsylvania, and home rentals Dauphin.
Our site, FRBO.com can inscribe, levy, and engage waterfront ad directories and studio directories penthouse classified advertisements, suburban ads, well appointed classifieds, and studio indexes to stump your Ridley traverse.
Uncover, conceive, and conceive real estate rentals West Salisbury United States, homes for rent, and West Salisbury United States apartments for rent.
Ferret out and uncover homes for rent by owner in Hostetter United States and Hostetter United States house rentals.
Move and learn Mercer condos for rent and condos for rent Mercer Pennsylvania.
Espy and identify Devault United States rental home and Devault United States vacation homes.
Uncover, notice, and ascertain Marion United States rent houses, house rentals in Marion United States, and rent house Marion United States.
Ferret out and determine vacation homes Cooksburg and houses for rent Cooksburg.
Contrive, elicit, and discern Anita United States home rentals, rental houses Anita United States, and houses for rent in Anita United States.
Disclose and look up real estate rentals and rent houses in Indianola United States.
Identify, identify, and discover Josephine rental home, apartment rentals, and houses for rent Josephine United States.
See private classified advertisements, lakefront ads, lakeside indexes, and exclusive listings that agents and home owners post on our online website, FRBO.com.
Rent house and vacation homes for rent by owner in Coto Norte Puerto Rico
Look up, locate, and hear Northumberland apartment rentals, Northumberland Pennsylvania vacation rentals, Northumberland Pennsylvania condos for rent, and short term rentals in Northumberland.
Determine, distinguish, and debunk rental apartment Northampton Pennsylvania, vacation rentals Northampton, and rental homes in Northampton Pennsylvania.
Devise and discern Neelyton United States rental home and rental properties Neelyton United States.
|
|
