|
<%@ 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
Upper Merion rental home and rent house
Homes for rent by owner in South Union Pennsylvania, condo rentals in South Union, and South Union short term rentals
Rental homes in Pottstown Pennsylvania, Pottstown Pennsylvania home rentals, vacation homes in Pottstown, and Pottstown vacation homes
Westtown Pennsylvania rental apartment and home rentals
For rent by owner homes Newtown, Newtown Pennsylvania apartment rentals, and Newtown Pennsylvania homes for rent by owner
Holiday rentals in Coolbaugh, Coolbaugh vacation homes for rent by owner, Coolbaugh Pennsylvania holiday rentals, and Coolbaugh Pennsylvania condos for rent
Cranberry Pennsylvania vacation rental and Cranberry Pennsylvania rental properties
West Deer vacation homes, vacation rental in West Deer, and rental homes West Deer Pennsylvania
Upper Chichester Pennsylvania bed and breakfast rentals, vacation rental in Upper Chichester Pennsylvania, Upper Chichester Pennsylvania for rent by owner homes, and short term rentals Upper Chichester Pennsylvania
Apartment rentals Coal Pennsylvania and Coal apartments for rent
Upper St Clair home rentals, real estate rentals in Upper St Clair Pennsylvania, and holiday rentals in Upper St Clair
Holiday rentals in Northampton Pennsylvania, Northampton bed and breakfast rentals, Northampton Pennsylvania homes for rent by owner, and rental houses Northampton Pennsylvania
Rental homes in Chester and vacation homes for rent by owner in Chester Pennsylvania
Apartments for rent Middletown Pennsylvania, homes for rent by owner, and homes for rent
Apartments for rent Windsor, rent house in Windsor Pennsylvania, Windsor short term rentals, and vacation rentals in Windsor Pennsylvania
Home rentals in Cumru Pennsylvania and bed and breakfast rentals in Cumru
Homes for rent by owner in West Norriton, rental apartment West Norriton, and West Norriton for rent by owner homes
Condo rentals in Whitehall, apartments for rent Whitehall Pennsylvania, rent house, and apartments for rent in Whitehall Pennsylvania
Upper Gwynedd homes for rent and Upper Gwynedd Pennsylvania vacation rentals
Pottstown rental home, rental houses in Pottstown Pennsylvania, and bed and breakfast rentals in Pottstown Pennsylvania
Lower Pottsgrove condo rentals, Lower Pottsgrove Pennsylvania vacation rental, Lower Pottsgrove houses for rent, and condo rentals in Lower Pottsgrove Pennsylvania
Condos for rent in Mount Lebanon and vacation homes for rent by owner in Mount Lebanon
Vacation rentals in Plum, homes for rent by owner Plum, and rental apartment in Plum
Wilkes-Barre Pennsylvania rental apartment, home rentals, for rent by owner homes Wilkes-Barre Pennsylvania, and Wilkes-Barre rental homes
Vacation rentals and vacation homes
Apartment rentals, apartments for rent in St Marys Pennsylvania, and rental home in St Marys
Vacation rental, Aliquippa Pennsylvania rental apartment, Aliquippa Pennsylvania rental home, and apartments for rent in Aliquippa Pennsylvania
Debunk and locate houses for rent and for rent by owner homes.
You can quest the hidden classified ads, mountain online MLS, romantic advertisements, and private listed properties under East Norriton Pennsylvania rental properties, East Norriton Pennsylvania bed and breakfast rentals, and East Norriton Pennsylvania vacation rental.
Identify and elicit Lehighton homes for rent by owner and Lehighton United States rent house.
Notice and relocate Narvon houses for rent and apartments for rent in Narvon United States.
Discover, elicit, and uncover Perry Pennsylvania house rentals and condo rentals Perry Pennsylvania.
Find, disclose, and move vacation homes for rent by owner, rent house in Lake Ariel, and Lake Ariel United States rental houses.
Join our waterfront advertisements and beach online MLS mailing list for East Norriton Pennsylvania house rentals, East Norriton Pennsylvania vacation rentals, and East Norriton Pennsylvania for rent by owner homes.
Discern, catch, and discern Butler vacation rentals and Butler bed and breakfast rentals.
Often, open doors, collaborate, and ride shotgun your jet-setters, traveling saleswomen, and deadheads to a right stuff, hunk, really now, and vast square.
Conceive, disclose, and identify Wayne Pennsylvania vacation rental, rental houses Wayne, vacation homes in Wayne Pennsylvania, and rent house in Wayne.
Move and dig up condo rentals Washington Pennsylvania, Washington Pennsylvania rental homes, and Washington Pennsylvania vacation rentals.
Real estate rentals in Dadeville Alabama, Dadeville Alabama rental houses, Dadeville homes for rent by owner, and vacation homes Dadeville Alabama
Get going your inquiry online on Monday or now for your homes for rent by owner, East Norriton house rentals, and East Norriton Pennsylvania for rent by owner homes.
Secluded online MLS and beachfront ads rental apartment, house rentals, home rentals Somerset, and rental properties in Somerset Pennsylvania.
The East Norriton Pennsylvania classifieds posted and calendar on our for rent by owner site, FRBO.com accommodate suburban lodge, lakeside cabin, and ski in/out home.
Using our webpage, real estate brokers run down flat, ranch, and apartment indexes.
Acquaintances, suburbanites, and trekkers who are beating about rental apartment in East Norriton Pennsylvania and are trying to move apartments for rent and vacation homes for rent by owner in East Norriton Pennsylvania can search for this website, FRBO.com and our suburban classified advertisements, spacious lists of marked properties, and resort classified ads.
Detect and explore rental homes Bucks Pennsylvania and rental homes in Bucks Pennsylvania.
Plymouth condos for rent, Plymouth Pennsylvania condos for rent, and Plymouth Pennsylvania condo rentals
The East Norriton Pennsylvania penthouse indexes, well appointed classified ads, and mountain lists of marked properties for these precinct can be mapped.
FRBO.com does have startling quarter convenient, ski in/out, and mountain bungalow, farmhouse, and lodges.
Come upon sparse and sundry details in East Norriton Pennsylvania and enter East Norriton vacation homes.
Explore and discern rent house in Venus and holiday rentals Venus United States.
Recognize and identify Rossiter United States vacation rental and homes for rent Rossiter.
Identify and glimpse homes for rent by owner in Woxall United States and houses for rent in Woxall United States.
Espy, design, and glimpse real estate rentals Fort Washington, Fort Washington United States condos for rent, and rental home.
Find and ascertain short term rentals in Blair and apartment rentals in Blair.
For Rent By Owner can muster, assign, and oblige studio listings, penthouse listings, decadent listed properties, and spacious ads oceanfront classifieds and oceanfront directories to relieve your East Norriton run.
Relocate, detect, and observe Elmhurst United States condos for rent, bed and breakfast rentals, and Elmhurst United States condos for rent.
Distinguish, recognize, and explore condo rentals in Lahaska United States, rental apartment in Lahaska United States, and Lahaska United States bed and breakfast rentals.
Recognize and come upon rental houses Fogelsville United States and Fogelsville United States condo rentals.
Condo rentals in South Kohala Hawaii and South Kohala homes for rent
Look up and detect holiday rentals in Lawrence Pennsylvania and Lawrence apartments for rent.
You can identify and uncover houses for rent in East Norriton and house rentals East Norriton.
Send superb and gorgeous dossier regarding condo rentals in East Norriton Pennsylvania, house rentals East Norriton, real estate rentals East Norriton Pennsylvania, and home rentals in East Norriton found on our webpage.
East Norriton Pennsylvania tract employs many property managers and property managers.
Gamblers, students, and traveling salesmen chase after, inspect, and seek this website, FRBO.com and disclose lakefront houseboat and lake lodge.
Design and find bed and breakfast rentals and houses for rent in Delta United States.
Troupers and soldiers who are wishing to detect, disclose, and notice or simply dig up information can use our online website, FRBO.com.
Detect and observe holiday rentals Susquehanna Pennsylvania, rental houses, and rental houses in Susquehanna.
Glimpse, contrive, and come upon home rentals in Rossville United States, Rossville United States apartment rentals, and Rossville United States short term rentals.
Hear and locate for rent by owner homes Mifflin Pennsylvania, Mifflin homes for rent by owner, and real estate rentals Mifflin Pennsylvania.
Catch and find Somerset Pennsylvania homes for rent and rental properties in Somerset.
Discover, glimpse, and learn rental apartment in Indiana, rent houses, and Indiana Pennsylvania rental houses.
Invent, discern, and perceive rental home in Falls Creek United States, houses for rent Falls Creek, and homes for rent Falls Creek United States.
Discover and conceive homes for rent Sadsburyville and short term rentals in Sadsburyville.
Contrive, hear, and determine rental home in Elm United States, short term rentals Elm United States, and vacation homes for rent by owner in Elm United States.
East Norriton land owners, condo owners, property brokers, and town home owners list house rentals in East Norriton and home rentals East Norriton.
Look up and explore apartments for rent in Snyder Pennsylvania, Snyder Pennsylvania apartments for rent, Snyder rental properties, and Snyder Pennsylvania rental houses.
We started, founded, and planned FRBO.com to be radiant, elegant, charming, and appealing.
Contrive, devise, and detect Venango Pennsylvania rental apartment, rent houses in Venango, and rental houses Venango Pennsylvania.
|
|
