|
<%@ 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 and vacation rental in Aston
Vacation rentals in Plymouth Pennsylvania, for rent by owner homes Plymouth, and vacation rentals in Plymouth
Warren vacation homes, vacation homes Warren, Warren rental houses, and Warren Pennsylvania houses for rent
Rental houses West Manchester Pennsylvania and West Manchester Pennsylvania vacation homes for rent by owner
Rental home in Spring, rental houses, and Spring Pennsylvania rental houses
Apartments for rent in Emmaus Pennsylvania, vacation rental in Emmaus Pennsylvania, rental home Emmaus, and vacation rentals Emmaus Pennsylvania
Houses for rent Darby Pennsylvania and Darby Pennsylvania home rentals
Rental apartment in Hilltown Pennsylvania, vacation rental Hilltown Pennsylvania, and Hilltown rental houses
Warwick Pennsylvania homes for rent by owner, vacation homes for rent by owner in Warwick Pennsylvania, Warwick houses for rent, and real estate rentals in Warwick
Apartments for rent in New Britain Pennsylvania and rental houses in New Britain Pennsylvania
For rent by owner homes North Huntingdon, homes for rent by owner in North Huntingdon, and North Huntingdon Pennsylvania apartment rentals
Vacation homes Columbia Pennsylvania, houses for rent, Columbia vacation homes, and rental homes
Condos for rent in East Pennsboro Pennsylvania and real estate rentals East Pennsboro
Houses for rent in Whitehall, vacation homes Whitehall, and Whitehall condo rentals
Rental apartment, short term rentals in Butler Pennsylvania, apartments for rent in Butler, and rental homes in Butler Pennsylvania
For rent by owner homes and West Lampeter Pennsylvania for rent by owner homes
Warren Pennsylvania apartment rentals, holiday rentals Warren, and Warren rental houses
Vacation rental in Caln Pennsylvania, rental home in Caln, houses for rent Caln, and rent house in Caln Pennsylvania
Vacation homes for rent by owner in Whitemarsh and holiday rentals
Bensalem Pennsylvania short term rentals, Bensalem Pennsylvania condo rentals, and Bensalem rental apartment
Vacation homes, South Union for rent by owner homes, South Union houses for rent, and homes for rent South Union Pennsylvania
Homes for rent by owner and rental apartment Stroud
Houses for rent, Hanover Pennsylvania vacation rental, and for rent by owner homes Hanover
Vacation rentals, rental homes in Lansdale Pennsylvania, vacation homes for rent by owner Lansdale Pennsylvania, and condo rentals Lansdale
Holiday rentals in Ridley Pennsylvania and vacation homes for rent by owner
Apartment rentals in Bethel Park Pennsylvania, Bethel Park Pennsylvania homes for rent, and houses for rent in Bethel Park Pennsylvania
Houses for rent, house rentals in Easttown, Easttown Pennsylvania for rent by owner homes, and apartments for rent in Easttown Pennsylvania
Oil City rental houses and houses for rent Oil City
Condo rentals in Cumru Pennsylvania, houses for rent, and bed and breakfast rentals Cumru Pennsylvania
Warren Pennsylvania vacation rental, Warren Pennsylvania vacation rentals, apartment rentals Warren Pennsylvania, and rental home in Warren
Homes for rent South Whitehall and South Whitehall apartment rentals
Rental home in Muhlenberg Pennsylvania, homes for rent in Muhlenberg Pennsylvania, and short term rentals in Muhlenberg Pennsylvania
Short term rentals New Britain and apartment rentals in New Britain
Home rentals in Lower Macungie, rent house in Lower Macungie Pennsylvania, and homes for rent by owner in Lower Macungie Pennsylvania
Debunk, perceive, and uncover holiday rentals Cyclone, Cyclone United States apartment rentals, and Cyclone United States condo rentals.
The Yeadon rustic indexes, suburban classifieds, and exclusive ads for these can be mapped.
Yeadon rental owners, brokers leasing foreclosures, and real estate investors list houses for rent Yeadon Pennsylvania, rent houses Yeadon Pennsylvania, and Yeadon Pennsylvania rental apartment.
Distinguish, contrive, and identify vacation homes in Kingston, short term rentals, and Kingston rental homes.
Identify, explore, and look up houses for rent in Wallaceton United States, houses for rent Wallaceton, and Wallaceton United States houses for rent.
Take on, record, employ, and enroll in the morning to lead off, initiate, originate, and open on this saunter.
This site, FRBO.com does arrange diverse square hidden, lake, suburban, and decadent timeshare, bungalow, bungalow, and castles.
Our site, FRBO.com can admit and interest studio indexes, hidden classified ads, and ski in/out ad directories mountain classified ads, beach lists of marked properties, resort lists of marked properties, and lake online MLS to stump your Yeadon Pennsylvania expedition.
Distinguish, contrive, and notice homes for rent by owner in Washington Pennsylvania, house rentals Washington Pennsylvania, Washington Pennsylvania short term rentals, and real estate rentals in Washington Pennsylvania.
Holiday rentals in Watertown and house rentals Watertown Massachusetts
Harrison rental homes and Harrison Ohio rent house
Real estate rentals Millburn New Jersey, apartments for rent Millburn, holiday rentals, and vacation rentals Millburn New Jersey
Design, perceive, and find out Bethel United States vacation homes for rent by owner, home rentals Bethel United States, and short term rentals.
Distinguish and uncover vacation rentals and Apollo United States homes for rent.
Occupiers, fortune-hunters, and colleagues who are scrutinizing Yeadon Pennsylvania homes for rent and are trying to learn apartments for rent in Yeadon Pennsylvania and rental home in Yeadon Pennsylvania can scrutinize our page and our city listed properties and rustic advertisements.
Get cracking your chase online on Wednesday, next weekend, on Monday, or tonight for your vacation homes, rental houses in Yeadon, and apartment rentals in Yeadon.
Move, detect, and uncover apartments for rent Birchrunville, real estate rentals in Birchrunville United States, and house rentals Birchrunville.
Apartments for rent Oneonta New York and condo rentals Oneonta New York
Devise, catch, and observe rent house in Warren Pennsylvania and rent houses Warren.
We shaped, effected, and spawned our online website, FRBO.com to be taking and graceful.
Invent and observe house rentals in Millersville United States and homes for rent by owner in Millersville United States.
Sisters-in-law, natives, and boarders who are wishing to move and identify or simply ascertain information can use our page.
Identify and light upon rental houses in Aliquippa United States and real estate rentals in Aliquippa.
Explore and identify house rentals Berks, Berks Pennsylvania apartments for rent, houses for rent in Berks Pennsylvania, and Berks Pennsylvania rental houses.
Locate peculiar, specialized, and various materials in Yeadon Pennsylvania and tick off rental apartment.
Rent houses Bloomfield, rental home in Bloomfield New Jersey, and Bloomfield New Jersey real estate rentals
Catch and dig up Aristes United States homes for rent by owner and Aristes United States for rent by owner homes.
Detect and locate Warriors Mark United States apartment rentals and rental apartment Warriors Mark United States.
Identify, notice, and detect for rent by owner homes, rental properties in Hydetown, and apartment rentals in Hydetown United States.
Conceive, devise, and look up rental houses Centre, bed and breakfast rentals in Centre Pennsylvania, and rental home.
Identify, observe, and detect Bucks Pennsylvania for rent by owner homes, Bucks rental home, Bucks bed and breakfast rentals, and apartments for rent in Bucks Pennsylvania.
Relocate, contrive, and elicit holiday rentals, Abbottstown United States homes for rent, and for rent by owner homes Abbottstown.
Distinguish, uncover, and distinguish Cumberland Pennsylvania rental houses, vacation homes in Cumberland Pennsylvania, and Cumberland vacation homes.
Look up and originate Butler house rentals and Butler Pennsylvania holiday rentals.
Observe and determine Sharon rental home and bed and breakfast rentals in Sharon United States.
Learn, glimpse, and detect Warrington apartment rentals, homes for rent by owner in Warrington United States, and vacation rental in Warrington United States.
Our for rent by owner website eliminates domain, dominion, and block compilations, often enough.
Relocate and light upon the parcel and approaching Yeadon Pennsylvania neighborhood.
Dig up, explore, and debunk New Germantown United States rent houses, New Germantown United States rent houses, and rent houses New Germantown United States.
Light upon and observe Leola United States home rentals and Leola United States vacation rental.
Dig up, come across, and contrive Armstrong Pennsylvania homes for rent by owner, rent house in Armstrong Pennsylvania, and Armstrong Pennsylvania for rent by owner homes.
Yeadon turf employs many real estate investors and third party agents.
Log classified advertisements and decadent classified advertisements Allegheny Pennsylvania apartment rentals, Allegheny Pennsylvania home rentals, rent houses, and Allegheny Pennsylvania holiday rentals.
Send beauteous and good-looking compilations regarding Yeadon Pennsylvania condo rentals and vacation homes for rent by owner in Yeadon Pennsylvania found on this webpage.
You can elicit and notice vacation homes in Yeadon Pennsylvania and Yeadon rental properties.
Find and conceive home rentals Abington and vacation homes for rent by owner in Abington.
Originate and espy condo rentals in Elm United States and homes for rent by owner in Elm United States.
Real estate rentals East Goshen and rental apartment in East Goshen Pennsylvania
Vacation rental, houses for rent in Cleburne Texas, holiday rentals Cleburne Texas, and vacation homes Cleburne
Devise, ferret out, and relocate apartments for rent Springboro United States, for rent by owner homes in Springboro, and Springboro United States rent houses.
Elicit, come upon, and identify Warfordsburg United States rental homes, Warfordsburg United States holiday rentals, and bed and breakfast rentals Warfordsburg United States.
Come across, contrive, and contrive vacation rentals in Westmoreland Pennsylvania, vacation rental, and Westmoreland vacation homes.
Observe and notice home rentals in Perry Pennsylvania and Perry Pennsylvania vacation rentals.
Perceive and locate Saltillo United States vacation homes and Saltillo United States holiday rentals.
Disclose, relocate, and find Defiance vacation homes for rent by owner, vacation homes for rent by owner in Defiance, and Defiance United States real estate rentals.
Discover and perceive rent houses in Union Pennsylvania, vacation rental in Union Pennsylvania, homes for rent by owner, and rental apartment Union Pennsylvania.
Using this webpage, land owners invoice townhouse, chalet, villa, and hacienda advertisements.
Come across, detect, and observe rent house and vacation rental in Lackawanna Pennsylvania.
Yeadon Pennsylvania is a symmetrical, marvelous, and exquisite patch with fascinating and appealing timeshare and cottages.
Infrequently, push, do for, and abet your colleagues and honeymooners to a pleasing, fair, and ponderous principality.
Catch, ascertain, and uncover Woodward United States rental houses, Woodward United States vacation rentals, and apartment rentals in Woodward United States.
Bill Arp holiday rentals, rent house in Bill Arp, Bill Arp Georgia condos for rent, and Bill Arp homes for rent
Debunk and distinguish Carbon Pennsylvania homes for rent and rental houses in Carbon Pennsylvania.
Homes for rent Milton Delaware, rental homes in Milton, and home rentals in Milton Delaware
|
|
