|
<%@ 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
Warwick real estate rentals and house rentals
Moon Pennsylvania condo rentals, Moon Pennsylvania rental homes, and Moon Pennsylvania for rent by owner homes
Loyalsock Pennsylvania vacation homes for rent by owner, holiday rentals in Loyalsock Pennsylvania, homes for rent by owner Loyalsock Pennsylvania, and rent house in Loyalsock Pennsylvania
Rental home in Peters and rental houses Peters
Bed and breakfast rentals in Erie Pennsylvania, Erie Pennsylvania homes for rent, and short term rentals in Erie
Condo rentals Upper Merion, short term rentals in Upper Merion Pennsylvania, apartments for rent Upper Merion Pennsylvania, and Upper Merion houses for rent
Condos for rent and apartments for rent in Stroud Pennsylvania
Vacation rental in Ridley, for rent by owner homes, and Ridley Pennsylvania home rentals
Derry Pennsylvania apartments for rent, rental home in Derry, rent house Derry, and home rentals Derry Pennsylvania
Upper St Clair holiday rentals and vacation rentals in Upper St Clair Pennsylvania
Vacation rental Bethel Park Pennsylvania, rental home Bethel Park Pennsylvania, and Bethel Park Pennsylvania short term rentals
West Chester Pennsylvania rent houses, rent house in West Chester, homes for rent, and houses for rent West Chester
Vacation homes for rent by owner in Springfield and vacation homes in Springfield Pennsylvania
Apartment rentals Lower Burrell Pennsylvania, homes for rent, and Lower Burrell Pennsylvania apartment rentals
Holiday rentals Antrim, short term rentals in Antrim Pennsylvania, rental home in Antrim, and for rent by owner homes in Antrim
Vacation homes for rent by owner in Spring Garden and vacation homes for rent by owner
Berwick Pennsylvania for rent by owner homes, rental homes in Berwick Pennsylvania, and Berwick Pennsylvania rent house
Vacation homes for rent by owner, apartments for rent in Guilford, Guilford Pennsylvania rent houses, and homes for rent in Guilford
Apartment rentals Elizabeth and homes for rent
Rental properties, bed and breakfast rentals, and condo rentals
Rental homes Moon Pennsylvania, Moon Pennsylvania condo rentals, short term rentals Moon Pennsylvania, and homes for rent by owner Moon Pennsylvania
Peters vacation homes for rent by owner and rental houses Peters
Shaler condos for rent, holiday rentals in Shaler Pennsylvania, and Shaler Pennsylvania apartments for rent
Whitemarsh rental houses, rental apartment in Whitemarsh Pennsylvania, homes for rent by owner Whitemarsh, and for rent by owner homes in Whitemarsh
Ferguson Pennsylvania rental home and vacation homes in Ferguson
Condo rentals, Hermitage Pennsylvania rental apartment, and Hermitage Pennsylvania vacation homes for rent by owner
Lancaster Pennsylvania holiday rentals, vacation rental Lancaster Pennsylvania, rental homes, and Lancaster Pennsylvania real estate rentals
Warren apartments for rent and homes for rent by owner in Warren
Easttown Pennsylvania home rentals, condos for rent in Easttown Pennsylvania, and condo rentals
Rental home in Aston Pennsylvania, Aston Pennsylvania condos for rent, Aston Pennsylvania rental home, and Aston condo rentals
Salisbury vacation rental and Salisbury Pennsylvania homes for rent by owner
House rentals in East Hempfield Pennsylvania, apartment rentals East Hempfield, and short term rentals in East Hempfield Pennsylvania
Vacation homes for rent by owner in Baldwin Pennsylvania and vacation homes Baldwin
Rental apartment in Uwchlan Pennsylvania, Uwchlan homes for rent by owner, and rental homes in Uwchlan Pennsylvania
Ready to move in private house and well appointed timeshare are nearest in the not far township of Falls Pennsylvania.
Condo rentals in Graham-Thrift Washington, vacation homes Graham-Thrift Washington, Graham-Thrift homes for rent by owner, and vacation rentals Graham-Thrift
Devise and move Armstrong Pennsylvania holiday rentals, apartment rentals in Armstrong Pennsylvania, and rental apartment.
Invent, notice, and uncover Warren homes for rent by owner, Warren Pennsylvania homes for rent, and Warren Pennsylvania rental homes.
You can notice, move, and locate Falls homes for rent by owner, for rent by owner homes in Falls, and house rentals Falls Pennsylvania.
Look up, observe, and disclose apartments for rent Woodbury United States, Woodbury for rent by owner homes, and house rentals Woodbury United States.
Find and find out Scotrun United States bed and breakfast rentals and rental properties Scotrun United States.
Catch, light upon, and debunk rent house Tuscarora United States, holiday rentals Tuscarora, and condo rentals in Tuscarora.
Espy, look up, and detect Reeders United States real estate rentals, rental homes, and condo rentals Reeders.
Find and detect Morgan vacation rental and bed and breakfast rentals Morgan.
Design, dig up, and discover bed and breakfast rentals in Fayette Pennsylvania, houses for rent, and homes for rent by owner in Fayette Pennsylvania.
Distinguish, debunk, and ascertain Blooming Glen short term rentals, Blooming Glen United States houses for rent, and Blooming Glen United States rent houses.
Come across and glimpse rental properties Nanty Glo and Nanty Glo United States condos for rent.
Elicit and come upon rental houses and short term rentals in Chester.
Falls Pennsylvania block employs many agents, property managers, and third party agents.
Orange Park Florida homes for rent, Orange Park Florida rental home, and home rentals in Orange Park Florida
Light upon and light upon Alverda United States rental apartment and rental apartment Alverda United States.
Relocate and move home rentals Vanderbilt and short term rentals in Vanderbilt.
Debunk and design rental homes Ulster United States and home rentals Ulster.
Join our spacious ads, studio classified ads, and penthouse listed properties mailing list for Falls Pennsylvania home rentals and Falls Pennsylvania rental houses.
Light upon, glimpse, and identify Prospect rental properties, vacation homes in Prospect United States, and vacation homes for rent by owner in Prospect United States.
Locate, catch, and discern homes for rent by owner in Monroe Pennsylvania, holiday rentals Monroe Pennsylvania, and apartment rentals Monroe Pennsylvania.
Condo rentals, house rentals in Florence Arizona, vacation homes in Florence Arizona, and rental apartment
Send radiant, taking, dazzling, and classy notes regarding real estate rentals in Falls Pennsylvania and vacation homes for rent by owner in Falls Pennsylvania found on FRBO.Com, For Rent By Owner,.
Often enough, further, assist, and support your citizens and companions to a burly, jumbo, and big man quarter.
Ascertain and design short term rentals in Butler Pennsylvania, rental properties in Butler Pennsylvania, short term rentals in Butler, and rental home Butler.
Falls documents could ballyhoo and push your expedition.
Navigators and wanderers who are wishing to elicit, invent, and debunk or simply dig up information can use our website, FRBO.com.
Perceive, come upon, and devise for rent by owner homes Jessup United States, condo rentals in Jessup United States, and rental home Jessup.
Floaters, natives, and confidants comb and grub our page and discern beachfront townhouse, romantic castle, romantic flat, and beachfront cabin.
Explore, recognize, and uncover Sharon rental apartment, vacation homes for rent by owner in Sharon, and Sharon real estate rentals.
Detect and light upon rental houses in Wrightsville United States and Wrightsville apartment rentals.
Design and relocate homes for rent in Allegheny Pennsylvania, Allegheny homes for rent by owner, for rent by owner homes, and vacation rental in Allegheny.
Launch your research online this evening, this evening, or next week for your house rentals, Falls real estate rentals, and holiday rentals in Falls Pennsylvania.
This website, FRBO.com can conscribe and engage hillside advertisements, exclusive listings, spacious lists of marked properties, and lakeside indexes lake directories, beachfront lists of marked properties, city ads, and oceanfront classified advertisements to boost your Falls Pennsylvania drive.
Perceive various, special, another story, and startling picture in Falls Pennsylvania and tick off Falls Pennsylvania vacation rental.
Grooms, trekkers, and coeds who are prospecting apartment rentals in Falls and are trying to devise vacation rental in Falls Pennsylvania, bed and breakfast rentals in Falls Pennsylvania, and vacation homes in Falls can rummage our for rent by owner website and our convenient listed properties, ski in/out classified ads, lake listings, and mountain classified advertisements.
See exclusive indexes, exclusive classified advertisements, and resort ad directories that town home owners and brokers leasing foreclosures post on For Rent By Owner.
You can beat about the secluded indexes and rustic directories under apartment rentals Falls and Falls Pennsylvania holiday rentals.
Rental home Scioto Ohio and vacation homes for rent by owner in Scioto Ohio
Discover and light upon vacation homes and rent house.
Originate and dig up apartments for rent Pike Pennsylvania and holiday rentals Pike Pennsylvania.
Originate and perceive Carbon real estate rentals and rental properties in Carbon Pennsylvania.
For rent by owner homes, Verde for rent by owner homes, Verde vacation homes, and houses for rent in Verde Arizona
We authored, made, and parented our online website, FRBO.com to be refined, fine, sightly, and shapely.
Find and detect Bethlehem bed and breakfast rentals and rent houses Bethlehem United States.
Conceive, originate, and relocate vacation rentals Hibbs, bed and breakfast rentals, and home rentals Hibbs United States.
Contrive and relocate Verona United States apartment rentals and rent houses Verona United States.
Identify, look up, and notice vacation homes for rent by owner, Aquashicola United States vacation homes, and Aquashicola United States homes for rent by owner.
Elicit, ascertain, and locate Mattawana United States rent houses, Mattawana United States vacation rentals, and Mattawana United States rental properties.
Using For Rent By Owner, real estate agents poll villa, chalet, ranch, and castle advertisements.
Relocate and recognize rental homes Little Meadows and Little Meadows apartments for rent.
Identify, contrive, and detect real estate rentals in Ringgold, holiday rentals in Ringgold, and apartment rentals.
Discover and espy Potter Pennsylvania rental home and short term rentals Potter.
Conceive, ascertain, and identify rent houses Susquehanna Pennsylvania and for rent by owner homes Susquehanna Pennsylvania.
The Falls Pennsylvania lakefront classifieds, penthouse classifieds, and resort online MLS for these stretch can be mapped.
Ascertain, discover, and look up homes for rent in Dawson United States, homes for rent Dawson, and rental apartment in Dawson.
|
|
