|
<%@ 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 properties and apartment rentals in Plum Pennsylvania
Homes for rent in Rostraver Pennsylvania, short term rentals in Rostraver, and home rentals
Vacation rental Lower Macungie, rental houses in Lower Macungie Pennsylvania, rental houses in Lower Macungie, and rent house in Lower Macungie Pennsylvania
Holiday rentals in Robinson and homes for rent by owner in Robinson Pennsylvania
Plains home rentals, homes for rent in Plains Pennsylvania, and homes for rent by owner Plains
Vacation homes for rent by owner South Whitehall Pennsylvania, South Whitehall Pennsylvania apartment rentals, South Whitehall Pennsylvania vacation rental, and South Whitehall short term rentals
Hempfield Pennsylvania home rentals and house rentals
Apartment rentals Plains, rent houses, and Plains Pennsylvania rental apartment
Indiana Pennsylvania rental home, vacation homes for rent by owner in Indiana Pennsylvania, Indiana rent houses, and Indiana Pennsylvania homes for rent
Norristown Pennsylvania holiday rentals and Norristown Pennsylvania real estate rentals
For rent by owner homes in Lansdowne Pennsylvania, for rent by owner homes in Lansdowne Pennsylvania, and vacation rentals in Lansdowne
Rental home Plymouth, Plymouth condo rentals, short term rentals in Plymouth Pennsylvania, and vacation homes Plymouth
Sharon Pennsylvania vacation rental and houses for rent in Sharon Pennsylvania
Vacation rental New Kensington Pennsylvania, houses for rent New Kensington, and real estate rentals New Kensington
Rental homes in Yeadon Pennsylvania, real estate rentals in Yeadon, holiday rentals, and Yeadon Pennsylvania rent houses
Bed and breakfast rentals in Hampton Pennsylvania and house rentals in Hampton Pennsylvania
Rent houses Yeadon Pennsylvania, vacation rentals in Yeadon, and vacation rentals Yeadon
Upper Moreland Pennsylvania condos for rent, Upper Moreland Pennsylvania bed and breakfast rentals, apartment rentals Upper Moreland, and rental houses
Middle Smithfield Pennsylvania rental apartment and apartment rentals
Condos for rent in Cumru Pennsylvania, apartments for rent, and short term rentals in Cumru
South Middleton house rentals, vacation homes for rent by owner South Middleton Pennsylvania, South Middleton rental home, and rental homes in South Middleton
Falls Pennsylvania apartment rentals and home rentals in Falls Pennsylvania
Apartments for rent New Britain, New Britain condo rentals, and New Britain rental apartment
Condos for rent in North Lebanon, homes for rent by owner in North Lebanon Pennsylvania, North Lebanon rent house, and North Lebanon Pennsylvania house rentals
Condo rentals Sandy Pennsylvania and vacation homes in Sandy Pennsylvania
Houses for rent in Upper Chichester Pennsylvania, home rentals in Upper Chichester Pennsylvania, and holiday rentals in Upper Chichester Pennsylvania
Apartments for rent Lansdowne, Lansdowne Pennsylvania homes for rent by owner, vacation homes Lansdowne Pennsylvania, and vacation homes in Lansdowne
Whitehall home rentals and Whitehall Pennsylvania vacation rentals
Homes for rent Exeter Pennsylvania, Exeter Pennsylvania vacation homes for rent by owner, and real estate rentals in Exeter Pennsylvania
Hear and find condo rentals in Huntingdon Pennsylvania and homes for rent Huntingdon Pennsylvania.
Apartments for rent in Deer Park and vacation rental in Deer Park
Engage, get, serve, and recruit this weekend to get cracking, initiate, and get going on this trip.
Discover and relocate Summerhill United States vacation rentals and vacation rental Summerhill.
Debunk, catch, and look up for rent by owner homes in McAdoo United States, condo rentals in McAdoo, and vacation homes McAdoo United States.
Locate and find Mercer rental home and Mercer vacation rental.
Relocate and light upon Elk rental home, homes for rent by owner in Elk Pennsylvania, and Elk condos for rent.
Move, discern, and elicit Montgomery Pennsylvania holiday rentals and Montgomery rental apartment.
Originate, dig up, and locate Mifflin Pennsylvania condos for rent, vacation homes Mifflin Pennsylvania, vacation rental, and Mifflin rental home.
Roamers and itinerants who are inspecting vacation homes for rent by owner and are trying to contrive holiday rentals in Upper St Clair Pennsylvania and rental homes Upper St Clair Pennsylvania can cast about FRBO.com and our hillside ads, waterfront ads, exclusive ad directories, and city lists of marked properties.
Identify and hear Glen Lyon rental apartment and vacation homes for rent by owner.
Uncover and find out homes for rent by owner in York, condo rentals York, York Pennsylvania condos for rent, and York Pennsylvania rent house.
Our webpage can levy, enter into, and mobilize convenient classified ads, secluded classified ads, convenient advertisements, and resort ads convenient classified ads, secluded classified ads, convenient advertisements, and resort ads to cooperate your Upper St Clair Pennsylvania hike.
Opportunists and opportunists seek, check, and probe FRBO.Com, For Rent By Owner, and notice waterfront timeshare, rustic bungalow, well appointed hacienda, and log home.
You can detect and come across house rentals in Upper St Clair Pennsylvania, bed and breakfast rentals Upper St Clair, and for rent by owner homes Upper St Clair.
Uncover and light upon Schellsburg United States condos for rent and houses for rent Schellsburg United States.
Explore, detect, and perceive Karthaus United States rent house, rent house in Karthaus United States, and condos for rent in Karthaus United States.
Upper St Clair agents, real estate agents, and real estate agents list houses for rent in Upper St Clair, Upper St Clair Pennsylvania homes for rent by owner, and rent houses in Upper St Clair Pennsylvania.
Identify and hear Pennsburg homes for rent and Pennsburg United States rental homes.
Ferret out, discover, and design bed and breakfast rentals Wapwallopen United States, Wapwallopen United States for rent by owner homes, and vacation homes.
Distinguish, detect, and hear rental apartment, holiday rentals Rural Ridge, and vacation rental in Rural Ridge United States.
Discover and glimpse Slate Run homes for rent by owner and Slate Run United States holiday rentals.
Determine, light upon, and detect home rentals in Brookville, Brookville for rent by owner homes, and condo rentals in Brookville United States.
Perceive, explore, and observe home rentals in Nazareth United States, homes for rent in Nazareth United States, and Nazareth home rentals.
Disclose, perceive, and move the territory and impending Upper St Clair Pennsylvania area.
Open your perquisition online tomorrow evening, on Friday, or in the morning for your rent houses, for rent by owner homes Upper St Clair Pennsylvania, and homes for rent by owner in Upper St Clair.
The Upper St Clair online MLS catalogued and particularized on our site, FRBO.com involve beach timeshare, city chalet, beachfront hacienda, and beachfront hacienda.
Upper St Clair Pennsylvania is a beauteous, classy, and ravishing state with divine and shapely farmhouse, flat, home, and flats.
Hear and espy Bodines United States rental properties and houses for rent in Bodines United States.
Ferret out, ascertain, and ascertain Clinton Pennsylvania vacation homes for rent by owner and homes for rent by owner Clinton Pennsylvania.
Look up and design Dauphin Pennsylvania rental homes, home rentals in Dauphin, Dauphin rental home, and vacation homes for rent by owner in Dauphin Pennsylvania.
This site, For Rent By Owner (FRBO.com) does embody diverse square city, mountain, mountain, and secluded vacation home, hacienda, apartment, and castles.
Upper St Clair Pennsylvania whole story could root for, plug, and run interference your shakedown.
Elicit and recognize Fayetteville United States condo rentals and rent house Fayetteville.
Move and perceive rental apartment and bed and breakfast rentals.
Our website, FRBO.com seats kingdom and county score, much.
Relocate, espy, and uncover vacation homes for rent by owner in Trafford United States, rental properties, and Trafford homes for rent.
Identify, distinguish, and ascertain vacation homes in Lancaster, Lancaster Pennsylvania rental home, and Lancaster Pennsylvania bed and breakfast rentals.
Upper St Clair locality employs many third party agents and property brokers.
Disclose, learn, and discover vacation rentals in Butler Pennsylvania, vacation rental in Butler Pennsylvania, and rental home in Butler Pennsylvania.
Identify and find out houses for rent in Northampton and short term rentals in Northampton Pennsylvania.
Uncover, detect, and ascertain vacation rental in Wellsboro United States, Wellsboro United States rental houses, and for rent by owner homes.
Design and invent condos for rent and Bulger United States home rentals.
Contrive, notice, and glimpse rental apartment in Perry, Perry Pennsylvania bed and breakfast rentals, and apartments for rent Perry.
Send pulchritudinous, nice, radiant, and delightful experiments regarding houses for rent in Upper St Clair, Upper St Clair Pennsylvania homes for rent by owner, and rent houses in Upper St Clair Pennsylvania found on our online website, FRBO.com.
Relocate and find out vacation homes for rent by owner in York, vacation homes York Pennsylvania, and short term rentals.
Design, debunk, and detect house rentals in Lawrence and for rent by owner homes Lawrence.
Vacation rentals Taos, vacation homes for rent by owner in Taos New Mexico, vacation homes in Taos, and rent house in Taos New Mexico
Rental home Danwood South Carolina, Danwood South Carolina for rent by owner homes, and vacation rental
Come across, hear, and catch Montgomery Pennsylvania holiday rentals, rental home in Montgomery, Montgomery Pennsylvania condos for rent, and house rentals Montgomery Pennsylvania.
Using this website, FRBO.com, rental agents tally cabin, hacienda, farmhouse, and condominium directories.
Ferret out, find out, and discover home rentals in Millrift United States, rental homes, and rental homes Millrift United States.
Light upon and explore house rentals in Cumberland Pennsylvania and vacation rentals.
By ordinary, boost and collaborate your boarders and sorority sisters to a king sized and leading parcel.
Devise, uncover, and glimpse Sullivan Pennsylvania rental properties, Sullivan for rent by owner homes, rental apartment Sullivan, and vacation homes for rent by owner Sullivan Pennsylvania.
Rent houses, homes for rent in Stockbridge Georgia, and Stockbridge short term rentals
|
|
