|
<%@ 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
For rent by owner homes in North Whitehall Pennsylvania and vacation homes in North Whitehall Pennsylvania
South Park rent houses, South Park homes for rent, and condos for rent in South Park Pennsylvania
Greene rental homes, vacation homes, Greene for rent by owner homes, and Greene Pennsylvania vacation rental
Rental home and rent houses in Harrison
Bethlehem Pennsylvania bed and breakfast rentals, Bethlehem Pennsylvania real estate rentals, and vacation rentals in Bethlehem Pennsylvania
Mount Lebanon rental properties, rent houses in Mount Lebanon Pennsylvania, home rentals, and Mount Lebanon Pennsylvania bed and breakfast rentals
Rental homes in Emmaus Pennsylvania and Emmaus bed and breakfast rentals
Manchester Pennsylvania short term rentals, Manchester Pennsylvania rental apartment, and rent houses
Apartment rentals in Moon Pennsylvania, Moon rent houses, rental apartment in Moon Pennsylvania, and homes for rent
North Strabane Pennsylvania rental homes and North Strabane rent houses
West Deer Pennsylvania vacation rental, apartments for rent in West Deer Pennsylvania, and apartment rentals in West Deer Pennsylvania
Vacation rental in Antrim, Antrim Pennsylvania condo rentals, rent houses Antrim Pennsylvania, and house rentals in Antrim Pennsylvania
Homes for rent by owner in Bethlehem Pennsylvania and rental home Bethlehem Pennsylvania
Newberry Pennsylvania rental home, Newberry Pennsylvania condos for rent, and Newberry Pennsylvania rental houses
Rental home North Strabane, house rentals in North Strabane Pennsylvania, homes for rent by owner in North Strabane, and holiday rentals in North Strabane
Rental properties and home rentals in Uniontown
Rental homes in North Whitehall Pennsylvania, vacation homes for rent by owner North Whitehall, and rent houses North Whitehall Pennsylvania
Homes for rent, Scranton Pennsylvania homes for rent by owner, for rent by owner homes Scranton Pennsylvania, and apartment rentals Scranton
Rental homes Newtown Pennsylvania and rental properties in Newtown Pennsylvania
Bethel Park Pennsylvania vacation rentals, Bethel Park Pennsylvania homes for rent by owner, and Bethel Park Pennsylvania condos for rent
Rental properties, apartment rentals in McKeesport, rent houses in McKeesport Pennsylvania, and rent houses in McKeesport
Shaler Pennsylvania home rentals and rental houses Shaler
Vacation rentals Guilford, rental apartment Guilford, and Guilford Pennsylvania homes for rent
Apartments for rent in West Whiteland Pennsylvania, house rentals West Whiteland, West Whiteland Pennsylvania homes for rent by owner, and homes for rent in West Whiteland Pennsylvania
House rentals in West Lampeter Pennsylvania and houses for rent in West Lampeter
Rental houses, homes for rent by owner in Elizabeth Pennsylvania, and Elizabeth bed and breakfast rentals
Meadville houses for rent, rental apartment in Meadville Pennsylvania, rent house Meadville, and Meadville condos for rent
Houses for rent in Warwick Pennsylvania and condo rentals
Vacation homes for rent by owner, Spring Garden apartments for rent, and real estate rentals in Spring Garden
Peters short term rentals, apartments for rent in Peters, short term rentals Peters, and for rent by owner homes
Vacation homes for rent by owner and West Chester for rent by owner homes
Wilkinsburg Pennsylvania holiday rentals, real estate rentals in Wilkinsburg Pennsylvania, and holiday rentals Wilkinsburg Pennsylvania
Rental properties North Strabane and North Strabane Pennsylvania houses for rent
Vacation homes for rent by owner, rent house, and holiday rentals
For rent by owner homes Brentwood Pennsylvania, rental home in Brentwood Pennsylvania, vacation homes for rent by owner in Brentwood, and rental properties in Brentwood
Using this extensive website, FRBO.com, third party listing companies inscribe farmhouse, apartment, and hacienda listings.
Hear, detect, and dig up rental homes Waterfall United States, rental properties, and Waterfall vacation homes for rent by owner.
Sometimes, facilitate and expedite your floaters and adventurers to a captivating and commodious section.
Discover, conceive, and ascertain Penns Park United States rental homes, Penns Park United States bed and breakfast rentals, and Penns Park United States vacation rental.
Come upon and recognize Centre Pennsylvania rental homes and homes for rent in Centre Pennsylvania.
Ascertain, determine, and observe West Middlesex United States apartment rentals, rental homes West Middlesex United States, and real estate rentals West Middlesex.
Identify, come across, and explore rental houses in Armstrong Pennsylvania, holiday rentals in Armstrong, and vacation rentals Armstrong Pennsylvania.
Perceive, find out, and discover bed and breakfast rentals, holiday rentals in Columbus, and rental apartment.
Upper Darby field employs many rental property owners, landlords, rental property owners, and property managers.
Find out, locate, and dig up holiday rentals in Allegheny Pennsylvania, condos for rent in Allegheny, Allegheny rental apartment, and Allegheny Pennsylvania homes for rent by owner.
Sealy homes for rent and Sealy Texas apartment rentals
Invent, come upon, and discover short term rentals Pineville United States, bed and breakfast rentals Pineville United States, and Pineville United States condos for rent.
Originate, discover, and learn Clarington United States houses for rent, homes for rent by owner in Clarington, and apartment rentals.
Our webpage can hire, secure, and assign well appointed listed properties and decadent online MLS city online MLS, exotic directories, lakeside listings, and waterfront advertisements to hype your Upper Darby traveling.
This webpage accommodates square, section, and patch whole story, successively.
Devise and devise apartment rentals Dublin and vacation rental in Dublin United States.
Learn and originate Mount Carmel rental homes and Mount Carmel condos for rent.
Glimpse, learn, and find out vacation homes for rent by owner in Lancaster Pennsylvania, Lancaster Pennsylvania vacation rentals, and condos for rent in Lancaster.
Homes for rent by owner Lynchburg, homes for rent Lynchburg Virginia, rental apartment Lynchburg, and Lynchburg Virginia vacation rental
Identify, look up, and come across real estate rentals in Perry Pennsylvania and Perry Pennsylvania rental properties.
Upper Darby rental owners and real estate brokers list rent house Upper Darby Pennsylvania, Upper Darby homes for rent by owner, and apartment rentals.
Discover and recognize rental homes in Indiana Pennsylvania, Indiana houses for rent, rental homes in Indiana, and rent house.
Conceive and design rental properties Sproul and Sproul United States rental properties.
Find out and identify vacation rentals in Lancaster Pennsylvania and Lancaster Pennsylvania apartment rentals.
Locate and observe for rent by owner homes in Beaver Pennsylvania and Beaver Pennsylvania houses for rent.
Determine and explore vacation homes in Clearfield Pennsylvania, Clearfield short term rentals, and real estate rentals Clearfield Pennsylvania.
Come across, invent, and find homes for rent by owner in Northampton, home rentals, rental houses Northampton, and Northampton Pennsylvania short term rentals.
The Upper Darby Pennsylvania romantic online MLS, mountain lists of marked properties, log advertisements, and resort online MLS for these section can be mapped.
Relocate and discern houses for rent in Starford United States and rental home in Starford United States.
Light upon and come across Strattanville vacation rentals and rental homes in Strattanville United States.
Send grand, charming, and appealing knowledge regarding vacation rental Upper Darby Pennsylvania and homes for rent by owner in Upper Darby found on this website, FRBO.com.
See hillside listed properties, hillside indexes, studio listed properties, and loft listings that condo owners and property managers post on this webpage.
Short term rentals Indiana, Indiana Pennsylvania rental properties, and vacation homes Indiana Pennsylvania
Debunk, come upon, and locate holiday rentals in Ardara, rent houses, and house rentals in Ardara United States.
Catch, notice, and glimpse Jefferson Pennsylvania rental houses, apartment rentals Jefferson, and bed and breakfast rentals in Jefferson.
Upper Darby Pennsylvania conclusions could work with and thump your research.
Move and debunk rental houses and condo rentals.
Uncover, espy, and look up apartments for rent, Taylor United States for rent by owner homes, and condos for rent Taylor United States.
Ascertain, locate, and identify rent house, Fulton Pennsylvania rental homes, and rent house Fulton.
Explore and debunk houses for rent in Columbus and Columbus United States for rent by owner homes.
The Upper Darby classifieds detailed and inventoried on FRBO.Com, For Rent By Owner, omit exclusive bungalow, loft chalet, ski in/out cottage, and spacious houseboat.
Short term rentals Washington Ohio and holiday rentals in Washington Ohio
Elicit, perceive, and identify vacation rentals in Ulster United States, apartment rentals in Ulster, and vacation rentals Ulster.
Upper Darby Pennsylvania is a elegant and gorgeous township with sightly, delightful, and cute cottage, apartment, hacienda, and vacation homes.
Hear and determine Mingoville rental houses and Mingoville rental apartment.
Design specific, distinct, and another story dossier in Upper Darby Pennsylvania and census bed and breakfast rentals in Upper Darby Pennsylvania.
Homes for rent by owner, Middletown rental homes, and for rent by owner homes
Launch your exploration online on Sunday or this week for your homes for rent by owner in Upper Darby Pennsylvania and rent house Upper Darby Pennsylvania.
You can scour the decadent lists of marked properties, lakefront classified ads, and penthouse online MLS under vacation homes for rent by owner, rental properties in Upper Darby, and vacation homes in Upper Darby Pennsylvania.
Look up, come upon, and elicit Upper Darby apartment rentals, Upper Darby United States rental homes, and Upper Darby condos for rent.
Clifton Park New York holiday rentals, bed and breakfast rentals Clifton Park, rent house in Clifton Park New York, and homes for rent by owner in Clifton Park New York
Branson Missouri rental houses, Branson Missouri rent houses, condo rentals Branson Missouri, and homes for rent by owner in Branson Missouri
We invested and invented our page to be pulchritudinous and pretty.
Determine, design, and dig up Schuylkill homes for rent and Schuylkill Pennsylvania condos for rent.
|
|
