|
<%@ 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
Bed and breakfast rentals and rental houses in Logan
Rent houses, holiday rentals in Lower Makefield, and Lower Makefield Pennsylvania short term rentals
Rent houses in White Pennsylvania, homes for rent in White Pennsylvania, apartment rentals White Pennsylvania, and rent house
Bed and breakfast rentals in Plum and condos for rent
Rent house, North Versailles Pennsylvania houses for rent, and homes for rent North Versailles
Apartments for rent in West Chester Pennsylvania, apartments for rent, West Chester rental homes, and home rentals
Rental properties Newberry Pennsylvania and rental houses Newberry
Johnstown Pennsylvania vacation homes for rent by owner, short term rentals, and Johnstown Pennsylvania rental home
Bed and breakfast rentals Easttown Pennsylvania, condo rentals Easttown, condos for rent in Easttown, and rental homes in Easttown Pennsylvania
Rental apartment Middle Smithfield Pennsylvania and house rentals
Caln rent house, Caln Pennsylvania short term rentals, and Caln Pennsylvania rental home
Rental apartment in Chambersburg Pennsylvania, Chambersburg condo rentals, rental properties, and Chambersburg rental homes
Rent houses Morrisville and for rent by owner homes Morrisville Pennsylvania
Apartments for rent, Dunmore house rentals, and holiday rentals Dunmore
Vacation homes Middletown, Middletown Pennsylvania condo rentals, bed and breakfast rentals in Middletown, and homes for rent by owner in Middletown Pennsylvania
Real estate rentals and Logan vacation rentals
Condo rentals in North Strabane Pennsylvania, homes for rent by owner, and vacation homes for rent by owner
West Mifflin apartment rentals, condo rentals in West Mifflin, real estate rentals in West Mifflin Pennsylvania, and West Mifflin rental apartment
Homes for rent Logan Pennsylvania and short term rentals Logan Pennsylvania
Rental properties, bed and breakfast rentals in Harrisburg Pennsylvania, and home rentals Harrisburg
Lower Allen Pennsylvania short term rentals, condo rentals in Lower Allen, condo rentals, and Lower Allen Pennsylvania apartment rentals
Exeter Pennsylvania short term rentals and Exeter Pennsylvania rental houses
For rent by owner homes in Coal Pennsylvania, Coal Pennsylvania apartment rentals, and Coal Pennsylvania apartments for rent
Short term rentals Pottstown Pennsylvania, rent houses in Pottstown Pennsylvania, Pottstown Pennsylvania vacation rental, and Pottstown Pennsylvania bed and breakfast rentals
Caln Pennsylvania homes for rent by owner and home rentals in Caln Pennsylvania
North Huntingdon rental homes, home rentals North Huntingdon Pennsylvania, and rental apartment
Rent house, Guilford houses for rent, condo rentals, and Guilford rental properties
Moon condo rentals and vacation homes for rent by owner Moon Pennsylvania
Home rentals Municipality of Murrysville, short term rentals Municipality of Murrysville Pennsylvania, and Municipality of Murrysville Pennsylvania apartment rentals
Apartments for rent, Manchester Pennsylvania short term rentals, Manchester home rentals, and homes for rent by owner Manchester Pennsylvania
Rental houses and condo rentals Lower Gwynedd Pennsylvania
Hopewell for rent by owner homes, Hopewell Pennsylvania real estate rentals, and vacation homes for rent by owner in Hopewell
East Pennsboro agents and brokers leasing foreclosures list rental properties East Pennsboro, vacation homes in East Pennsboro Pennsylvania, apartments for rent in East Pennsboro Pennsylvania, and rent houses East Pennsboro.
Ferret out and determine Jefferson Pennsylvania condos for rent and apartment rentals Jefferson Pennsylvania.
Garfield house rentals, home rentals Garfield, and Garfield New Jersey vacation homes for rent by owner
Detect and come across vacation homes in Carbon Pennsylvania, rental home in Carbon, for rent by owner homes in Carbon, and Carbon apartment rentals.
Observe and ferret out real estate rentals Lehigh Pennsylvania, houses for rent Lehigh, and rent house in Lehigh Pennsylvania.
Contrive, discern, and conceive Allport United States bed and breakfast rentals, rental apartment in Allport United States, and real estate rentals Allport.
The East Pennsboro Pennsylvania beachfront listings, waterfront ad directories, ski in/out ads, and hillside advertisements for these can be mapped.
Santa Paula California rental houses and Santa Paula California rental houses
Record and conscribe on Saturday to inaugurate, embark on, tear into, and originate on this wandering.
Look up, glimpse, and espy bed and breakfast rentals in Blair, rental homes in Blair Pennsylvania, rental apartment in Blair Pennsylvania, and Blair Pennsylvania condo rentals.
You can relocate, ferret out, and find out East Pennsboro Pennsylvania condos for rent, East Pennsboro Pennsylvania homes for rent, and East Pennsboro rental home.
Our online website, FRBO.com excludes patch, turf, and territory info, occasionally.
Explore, observe, and learn Norristown house rentals, Norristown United States homes for rent, and Norristown United States rent house.
The East Pennsboro Pennsylvania advertisements detailed and posted on this site, For Rent By Owner (FRBO.com) eliminate resort apartment, romantic cottage, and city vacation home.
Explore and light upon Lehigh Pennsylvania for rent by owner homes and Lehigh real estate rentals.
East Pennsboro Pennsylvania is a alluring, good-looking, and exquisite vicinity with sublime, magnificent, and bewitching apartment and cabins.
Our website, FRBO.com does seat various square exotic, ski in/out, and exclusive home, timeshare, and timeshares.
Locate, identify, and uncover Delaware Pennsylvania vacation homes for rent by owner, Delaware Pennsylvania vacation homes, and home rentals.
Come across, determine, and find homes for rent by owner in Republic, homes for rent by owner, and homes for rent in Republic United States.
Learn and explore vacation homes for rent by owner and Meadow Lands United States short term rentals.
Contrive, relocate, and perceive homes for rent Cambria Pennsylvania, rental apartment in Cambria Pennsylvania, and vacation rentals.
You can rake the secluded directories and private classified advertisements under apartments for rent in East Pennsboro, holiday rentals, and house rentals.
Come upon and disclose Curllsville United States apartments for rent and apartment rentals in Curllsville United States.
Devise, ferret out, and notice Washington Pennsylvania home rentals, Washington vacation rental, house rentals, and Washington rent houses.
Expeditionists, sailors, and venturers explore and scout our for rent by owner site, FRBO.com and discover ski in/out lodge, private castle, suburban lodge, and spacious duplex.
Notice, distinguish, and identify Covington real estate rentals, condos for rent Covington United States, and vacation homes for rent by owner Covington United States.
Lake classifieds and hillside classified ads home rentals Erie Pennsylvania, rental houses Erie Pennsylvania, house rentals, and house rentals in Erie.
Observe and identify Coaldale United States rental houses and real estate rentals Coaldale.
Detect and invent rental properties in Soudersburg United States and rent houses Soudersburg United States.
Recently available exclusive ranch, convenient house, and beachfront chalet are nearest in the approaching locality of East Pennsboro Pennsylvania.
Determine and determine bed and breakfast rentals in Shade Gap United States and Shade Gap United States rental homes.
Residers and educators who are wishing to light upon and elicit or simply contrive information can use this site, For Rent By Owner (FRBO.com).
Friends, husbands, and fellow workers who are poking into apartment rentals East Pennsboro and are trying to elicit rent house in East Pennsboro Pennsylvania and apartment rentals East Pennsboro can grub this site, FRBO.com and our spacious indexes, waterfront listings, suburban advertisements, and studio classifieds.
Home rentals in Seekonk Massachusetts and bed and breakfast rentals in Seekonk
Look up, come upon, and move apartment rentals in Erie and short term rentals Erie.
Discover, relocate, and light upon Gradyville United States for rent by owner homes, vacation homes in Gradyville United States, and Gradyville United States vacation homes for rent by owner.
Conceive specific, bizarre, and rare evidence in East Pennsboro Pennsylvania and tick off apartment rentals East Pennsboro.
Perceive and ascertain homes for rent by owner in Eau Claire and houses for rent in Eau Claire United States.
Join our secluded indexes, private ads, and well appointed listed properties mailing list for short term rentals and vacation homes East Pennsboro.
Identify and detect rental home in Mc Grann and Mc Grann short term rentals.
Discover and relocate rental homes in Mainesburg United States and bed and breakfast rentals Mainesburg United States.
Find, perceive, and discover apartments for rent, apartment rentals Abington United States, and vacation homes in Abington United States.
Identify, move, and uncover vacation rentals in Jones Mills United States, homes for rent in Jones Mills, and vacation rental in Jones Mills United States.
Vacation rental in Las Cruces, vacation homes for rent by owner Las Cruces New Mexico, and for rent by owner homes in Las Cruces New Mexico
Relocate, uncover, and dig up home rentals in Venango, vacation rentals in Venango, and home rentals Venango Pennsylvania.
Catch, identify, and glimpse for rent by owner homes Forest Pennsylvania and for rent by owner homes Forest Pennsylvania.
East Pennsboro Pennsylvania picture could serve, assist, stump, and run interference your perquisition.
Find, espy, and contrive houses for rent in Dublin, holiday rentals Dublin, and Dublin United States rental properties.
Explore, debunk, and come across Cuddy United States condos for rent, vacation homes for rent by owner in Cuddy United States, and homes for rent by owner in Cuddy United States.
Discern and find Canton United States real estate rentals and Canton rental houses.
Uncover, observe, and elicit condo rentals, rental apartment, and Columbia Pennsylvania rent house.
Glimpse, contrive, and design vacation rentals Mercer, rental houses in Mercer, vacation rental, and Mercer Pennsylvania vacation homes.
Ascertain and ferret out rental properties in Frostburg United States and condo rentals in Frostburg United States.
We invested, effected, and imagined our online website, FRBO.com to be divine, admirable, and charming.
Rental homes in Bozeman and rental properties in Bozeman Montana
Uncover, disclose, and come upon vacation rentals, vacation homes for rent by owner in Milroy United States, and homes for rent in Milroy United States.
Disclose, locate, and catch Orefield short term rentals, for rent by owner homes in Orefield United States, and vacation rentals Orefield United States.
Recognize, come across, and detect the square and handy East Pennsboro Pennsylvania domain.
Locate, discern, and notice Glen Campbell vacation rental, apartments for rent in Glen Campbell, and apartment rentals in Glen Campbell.
Distinguish and find Breezewood United States rent house and rental home in Breezewood United States.
|
|
