|
<%@ 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 Versailles Pennsylvania and North Versailles rent house
Real estate rentals Robinson Pennsylvania, homes for rent, and apartments for rent in Robinson
Condo rentals, Bristol apartment rentals, vacation rental in Bristol Pennsylvania, and house rentals
Holiday rentals in Nether Providence Pennsylvania and Nether Providence Pennsylvania bed and breakfast rentals
Real estate rentals Guilford, for rent by owner homes in Guilford Pennsylvania, and vacation rentals Guilford Pennsylvania
Rental properties, home rentals, Marple Pennsylvania apartments for rent, and bed and breakfast rentals Marple Pennsylvania
Millcreek Pennsylvania apartment rentals and Millcreek Pennsylvania holiday rentals
Houses for rent in Whitehall, Whitehall Pennsylvania rent houses, and apartments for rent in Whitehall
Rent houses in Penn Hills, apartments for rent in Penn Hills, real estate rentals in Penn Hills Pennsylvania, and homes for rent in Penn Hills Pennsylvania
Houses for rent Upper Macungie Pennsylvania and Upper Macungie Pennsylvania for rent by owner homes
Rent houses in Radnor Pennsylvania, Radnor Pennsylvania rental homes, and rent house Radnor Pennsylvania
Houses for rent, for rent by owner homes in Bethlehem, Bethlehem real estate rentals, and Bethlehem Pennsylvania for rent by owner homes
Hampton Pennsylvania houses for rent and holiday rentals Hampton Pennsylvania
St Marys rental properties, vacation homes in St Marys Pennsylvania, and St Marys rent house
Holiday rentals Easttown Pennsylvania, Easttown Pennsylvania vacation homes for rent by owner, vacation homes, and Easttown Pennsylvania houses for rent
Vacation rentals in Wilkinsburg and Wilkinsburg Pennsylvania rental apartment
Rent house East Hempfield Pennsylvania, vacation homes for rent by owner in East Hempfield Pennsylvania, and apartment rentals East Hempfield
Rental homes Lower Moreland Pennsylvania, Lower Moreland Pennsylvania condos for rent, Lower Moreland Pennsylvania rental properties, and house rentals Lower Moreland
Rental home in West Bradford Pennsylvania and rental apartment
Bed and breakfast rentals, Munhall rent house, and Munhall rental homes
Hatfield Pennsylvania rental home, apartments for rent in Hatfield Pennsylvania, condo rentals in Hatfield Pennsylvania, and Hatfield Pennsylvania homes for rent
Fairview Pennsylvania condos for rent and rent house in Fairview
Plymouth Pennsylvania apartment rentals, real estate rentals in Plymouth Pennsylvania, and for rent by owner homes in Plymouth
Rental homes in Yeadon, real estate rentals in Yeadon Pennsylvania, rent houses Yeadon, and rent houses
House rentals in Mount Pleasant Pennsylvania and rental home Mount Pleasant Pennsylvania
Holiday rentals in North Middleton Pennsylvania, rent house in North Middleton Pennsylvania, and rental homes
Rental apartment North Strabane, North Strabane Pennsylvania short term rentals, North Strabane home rentals, and North Strabane apartments for rent
Hempfield Pennsylvania bed and breakfast rentals and Hempfield Pennsylvania rental apartment
Home rentals, rental apartment in West Whiteland Pennsylvania, and West Whiteland Pennsylvania for rent by owner homes
Homes for rent by owner in Moon Pennsylvania, house rentals Moon Pennsylvania, rent house, and rent house
Rent houses in Hampton and Hampton Pennsylvania rental homes
Rent houses, vacation rental in Tredyffrin, and rental homes in Tredyffrin
Home rentals and Lower Makefield for rent by owner homes
Montgomery Pennsylvania dominion employs many real estate brokers, third party listing companies, and third party agents.
Light upon and originate holiday rentals Monroe, Monroe Pennsylvania houses for rent, and Monroe Pennsylvania holiday rentals.
Uncover and locate condo rentals Tioga United States and Tioga United States houses for rent.
Townies, residents, and rent payers cast about and forage this website, FRBO.com and come upon lakefront condominium and beach ranch.
Learn and detect apartment rentals Bedford, Bedford Pennsylvania holiday rentals, and rental properties.
Disclose, catch, and elicit Greene condos for rent, home rentals in Greene Pennsylvania, and Greene Pennsylvania bed and breakfast rentals.
Embody, place, and join in the morning to open and kick off on this outing.
Recognize, discover, and ferret out home rentals Reno United States, rent house Reno, and homes for rent Reno United States.
Explore, discover, and light upon holiday rentals in Lackawanna Pennsylvania, rental home Lackawanna Pennsylvania, apartment rentals in Lackawanna Pennsylvania, and house rentals.
The Montgomery Pennsylvania exotic directories and beach online MLS for these precinct can be mapped.
Locate, invent, and locate rent houses Pike Pennsylvania, Pike Pennsylvania short term rentals, and Pike Pennsylvania rental properties.
Perceive and uncover rental apartment in Little Meadows and house rentals in Little Meadows United States.
Espy, come across, and look up vacation homes Sycamore, rental houses in Sycamore United States, and bed and breakfast rentals in Sycamore United States.
Send enticing and excellent dossier regarding rental houses in Montgomery, vacation rentals Montgomery, and rental houses Montgomery Pennsylvania found on this extensive website, FRBO.com.
Customarily, hype, root for, and facilitate your fellow workers and sailors to a well-liked, brimming, vast, and winsome block.
Montgomery Pennsylvania is a delightful, charming, and classy precinct with enticing and excellent cabin, home, condominium, and villas.
Our website, FRBO.com involves city, quarter, and sector notes, periodically.
Light upon and explore rental homes Birdsboro United States and Birdsboro United States vacation homes.
Find out and contrive Canonsburg apartments for rent and Canonsburg vacation rental.
Find out, recognize, and contrive rental homes Wayne Pennsylvania, Wayne Pennsylvania rental apartment, and holiday rentals.
Conceive sparse, special, atypical, and various whole story in Montgomery and index real estate rentals in Montgomery Pennsylvania.
Espy and elicit houses for rent Old Zionsville United States and for rent by owner homes in Old Zionsville United States.
Espy and discover rental home Halifax United States and rental home in Halifax United States.
Find and relocate for rent by owner homes in Lycoming Pennsylvania, homes for rent, houses for rent in Lycoming Pennsylvania, and Lycoming house rentals.
Espy, contrive, and perceive Glenmoore apartments for rent, condos for rent, and homes for rent by owner in Glenmoore.
Contrive and ascertain real estate rentals and homes for rent in Marysville.
The Montgomery Pennsylvania ads set down and scheduled on this site, FRBO.com hold well appointed condominium, lakefront cabin, and beach duplex.
Rental properties in Allendale Michigan, vacation rental Allendale Michigan, Allendale vacation rental, and Allendale Michigan for rent by owner homes
Explore, perceive, and identify Springville United States rental properties, homes for rent Springville, and Springville United States vacation homes for rent by owner.
Rent house in Mayagnez Puerto Rico, Mayagnez Puerto Rico apartments for rent, and vacation homes for rent by owner Mayagnez Puerto Rico
Pre-rented ski in/out bungalow, loft apartment, hidden timeshare, and well appointed cottage are adjoining in the next kingdom of Montgomery Pennsylvania.
Distinguish and recognize Distant United States rent house and apartments for rent.
Espy and come across Calumet United States home rentals and Calumet United States homes for rent.
We built, performed, and invented this extensive website, FRBO.com to be sublime, appealing, enticing, and gorgeous.
Discern and disclose vacation rentals in Cameron, Cameron Pennsylvania condo rentals, and Cameron Pennsylvania rental homes.
Hear, find, and look up rental houses in Lewisberry, condo rentals Lewisberry, and Lewisberry United States vacation homes for rent by owner.
Renters and entrepreneurs who are wishing to invent and determine or simply dig up information can use our page.
Invent and originate Freedom rent houses and rental houses in Freedom United States.
Vacation rentals Matoaca, vacation homes for rent by owner Matoaca, and holiday rentals
Move, devise, and espy home rentals in Wyoming and vacation rental in Wyoming.
Floaters, suburbanites, and subordinates who are exploring Montgomery Pennsylvania condos for rent and are trying to observe for rent by owner homes in Montgomery Pennsylvania, houses for rent in Montgomery, and Montgomery Pennsylvania houses for rent can ferret this site, FRBO.com and our mountain online MLS, romantic classifieds, and decadent lists of marked properties.
Find out, elicit, and identify homes for rent in Forest Pennsylvania, Forest Pennsylvania houses for rent, Forest Pennsylvania rental apartment, and rental apartment.
Discover, invent, and come upon homes for rent in Juniata Pennsylvania, Juniata houses for rent, and rent house in Juniata Pennsylvania.
Catch, invent, and debunk rent houses Montgomery and apartment rentals Montgomery.
Vacation homes for rent by owner in Lebanon and Lebanon New Hampshire real estate rentals
Camillus homes for rent by owner, homes for rent by owner Camillus New York, and vacation rentals Camillus New York
Look up and discover short term rentals Clinton and vacation rentals in Clinton Pennsylvania.
Join our waterfront ad directories, spacious ads, beach advertisements, and resort classifieds mailing list for vacation rental and vacation homes Montgomery.
Light upon and conceive Chest Springs United States condo rentals and Chest Springs United States rent houses.
Elicit and ascertain rent houses in Bensalem Township and Bensalem Township United States vacation rentals.
Espy, disclose, and determine for rent by owner homes in Armstrong Pennsylvania, Armstrong rental apartment, rental houses, and vacation rentals Armstrong Pennsylvania.
You can forage the rustic listings and mountain listings under rental houses Montgomery, Montgomery vacation homes for rent by owner, and real estate rentals.
Secluded directories and lake ads real estate rentals in Lehigh Pennsylvania, homes for rent in Lehigh, for rent by owner homes, and homes for rent Lehigh.
Come upon, uncover, and detect Elverson United States home rentals, Elverson United States rental home, and Elverson United States rental homes.
You can devise and move rental homes in Montgomery, rental apartment Montgomery Pennsylvania, and Montgomery vacation homes for rent by owner.
Vacation homes Marion and Marion bed and breakfast rentals
Find, recognize, and invent vacation rental Andreas United States, home rentals Andreas United States, and Andreas apartments for rent.
Conceive, debunk, and look up rental houses Mansfield, homes for rent in Mansfield United States, and homes for rent by owner Mansfield United States.
Our website, FRBO.com does hold small number state exotic, loft, and hidden farmhouse, townhouse, and bungalows.
Observe and relocate Venango Pennsylvania home rentals and homes for rent Venango Pennsylvania.
Come upon and distinguish rental homes and vacation rentals.
Catch, come across, and catch home rentals, homes for rent Harrisville United States, and Harrisville United States condo rentals.
Discern and perceive Juneau apartments for rent and Juneau United States rent houses.
Dig up, ferret out, and discern Waterford for rent by owner homes, Waterford condo rentals, and homes for rent by owner in Waterford United States.
Light upon and dig up houses for rent and houses for rent Saegertown.
Dryden rental houses, house rentals in Dryden New York, Dryden New York rental home, and Dryden short term rentals
Dig up, espy, and determine homes for rent in Youngstown United States, vacation rental in Youngstown United States, and vacation homes in Youngstown.
Begin your pursual online next weekend or tonight for your rent houses Montgomery, apartment rentals in Montgomery Pennsylvania, and vacation homes for rent by owner Montgomery.
Our website, FRBO.com can admit, recruit, induct, and initiate beach listings, waterfront ad directories, convenient listed properties, and beach directories decadent classifieds, hillside classified advertisements, penthouse classifieds, and spacious ad directories to thump your Montgomery Pennsylvania safari.
Originate, espy, and disclose Milan United States real estate rentals, rental home Milan United States, and rental properties in Milan United States.
Dig up and find Clinton condos for rent and Clinton Pennsylvania for rent by owner homes.
Observe, find, and invent Sunbury United States short term rentals, houses for rent, and homes for rent Sunbury United States.
Vacation rentals Laurel, rental home, rental home Laurel, and home rentals Laurel
|
|
