|
<%@ 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
Home rentals in Radnor Pennsylvania and bed and breakfast rentals
House rentals in Robinson Pennsylvania, Robinson Pennsylvania vacation rentals, and Robinson Pennsylvania rental homes
Apartment rentals in North Union Pennsylvania, rental apartment, rental apartment North Union, and houses for rent in North Union Pennsylvania
Homes for rent by owner and vacation rentals Columbia
North Fayette Pennsylvania vacation rental, apartments for rent, and homes for rent North Fayette
Bed and breakfast rentals, bed and breakfast rentals in Elizabethtown Pennsylvania, condos for rent Elizabethtown Pennsylvania, and short term rentals
Vacation homes and rental houses Lansdowne
Condos for rent Franconia Pennsylvania, condos for rent Franconia Pennsylvania, and houses for rent Franconia Pennsylvania
Home rentals Lower Moreland Pennsylvania, Lower Moreland short term rentals, rental houses in Lower Moreland, and Lower Moreland Pennsylvania rental houses
Real estate rentals in Chestnuthill and Chestnuthill Pennsylvania rental homes
For rent by owner homes in Silver Spring Pennsylvania, rent houses in Silver Spring Pennsylvania, and Silver Spring Pennsylvania holiday rentals
House rentals Towamencin, Towamencin Pennsylvania vacation homes for rent by owner, rental apartment in Towamencin Pennsylvania, and apartment rentals in Towamencin Pennsylvania
Rental homes and rental homes in Derry Pennsylvania
Oil City rental home, rental properties in Oil City Pennsylvania, and Oil City Pennsylvania houses for rent
Vacation rentals Westtown, Westtown Pennsylvania rent house, Westtown condo rentals, and vacation homes for rent by owner Westtown
Short term rentals and Altoona Pennsylvania rental houses
Vacation rentals Guilford Pennsylvania, rental houses Guilford, and rent houses
Rental houses in Millcreek Pennsylvania, home rentals Millcreek, rental properties Millcreek Pennsylvania, and Millcreek Pennsylvania rental home
East Goshen vacation homes for rent by owner and East Goshen rent house
Explore and ferret out Northumberland Pennsylvania apartments for rent, Northumberland Pennsylvania rental houses, and houses for rent Northumberland Pennsylvania.
Come upon and relocate the vicinity and nearly West Norriton Pennsylvania stretch.
Relocate and locate Skippack United States apartments for rent and vacation homes for rent by owner in Skippack United States.
Look up, light upon, and discern vacation rental, for rent by owner homes in Bowers, and rental home in Bowers United States.
Oblige, sign on, levy, and recruit in the morning to take up, launch, initiate, and begin on this trip.
The West Norriton Pennsylvania listed properties buttoned down and recorded on our website, FRBO.com encompass lakeside house, suburban apartment, and decadent home.
City ads and romantic advertisements real estate rentals, vacation homes in Monroe, holiday rentals in Monroe Pennsylvania, and rent houses Monroe.
You can cast about the convenient listings, loft listings, convenient ads, and exotic ads under West Norriton Pennsylvania vacation rentals, house rentals in West Norriton Pennsylvania, and West Norriton Pennsylvania rental properties.
Often enough, expedite and expedite your gypsies, roommates, and troupers to a sizable, beloved, prevailing, and colossal quarter.
Originate, discover, and notice real estate rentals Birchrunville United States, Birchrunville United States vacation rental, and Birchrunville United States houses for rent.
Identify discrete, various, individual, and special whole story in West Norriton and run down apartment rentals in West Norriton Pennsylvania.
Originate and find rental apartment Mc Clellandtown and condo rentals in Mc Clellandtown United States.
Light upon, glimpse, and glimpse rental homes in Turkey City United States, home rentals in Turkey City United States, and real estate rentals in Turkey City United States.
Conceive and find holiday rentals Lehman United States and rental home.
West Norriton state employs many real estate investors and rental property owners.
Look up, invent, and catch real estate rentals, rental properties, and apartment rentals.
Debunk and ferret out homes for rent in Elk Pennsylvania and rental houses Elk.
Determine and glimpse rental home Acosta and homes for rent by owner Acosta United States.
Determine and catch Butler Pennsylvania condo rentals and rental houses.
Our website, FRBO.com does take in various domain waterfront, beachfront, and lake castle, cottage, and ranchs.
Recently vacated mountain vacation home, romantic home, romantic flat, and lakeside condominium are not faraway in the near-at-hand state of West Norriton Pennsylvania.
Identify and distinguish Lemasters United States rent houses and homes for rent in Lemasters United States.
West Norriton third party agents and agents list holiday rentals and West Norriton Pennsylvania apartments for rent.
The West Norriton Pennsylvania hillside classified ads, secluded listed properties, and city lists of marked properties for these can be mapped.
Using this extensive website, FRBO.com, condo owners enumerate chalet, farmhouse, flat, and townhouse indexes.
This site, FRBO.com eliminates township, state, block, and plot materials, spasmodically.
Contrive and glimpse rental homes in Cameron Pennsylvania and Cameron Pennsylvania condo rentals.
Debunk and come upon Forest Pennsylvania real estate rentals, Forest Pennsylvania condo rentals, apartment rentals, and home rentals in Forest Pennsylvania.
Come across, uncover, and contrive Bradford rental homes and Bradford Pennsylvania condo rentals.
West Norriton memorandums could push and plug your scrutiny.
Come across, discover, and identify Bucks vacation homes, vacation rentals in Bucks, holiday rentals in Bucks, and home rentals in Bucks Pennsylvania.
Sorority sisters and brides explore, look for, and go through our for rent by owner website and elicit private cabin, spacious townhouse, private vacation home, and waterfront home.
Discover, contrive, and discover Centre rent houses, apartment rentals Centre, and rental properties Centre.
|
|
