|
<%@ 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
Apartments for rent in Chestnuthill Pennsylvania and Chestnuthill Pennsylvania condo rentals
Rent house, rental houses in Berwick Pennsylvania, and rent houses Berwick Pennsylvania
Susquehanna Pennsylvania homes for rent, Susquehanna rent houses, Susquehanna Pennsylvania short term rentals, and rental properties in Susquehanna Pennsylvania
Houses for rent in New Kensington and New Kensington Pennsylvania rental home
Washington apartment rentals, rent houses in Washington Pennsylvania, and home rentals in Washington
Condos for rent in Upper Providence, houses for rent, apartment rentals, and Upper Providence Pennsylvania apartments for rent
Northampton rental apartment and holiday rentals in Northampton Pennsylvania
House rentals in Lower Southampton Pennsylvania, rent house Lower Southampton Pennsylvania, and Lower Southampton Pennsylvania vacation rentals
Philadelphia Pennsylvania vacation homes for rent by owner, Philadelphia Pennsylvania for rent by owner homes, Philadelphia Pennsylvania condo rentals, and home rentals Philadelphia
Montgomery Pennsylvania apartment rentals and homes for rent by owner
Patton Pennsylvania apartment rentals, Patton Pennsylvania apartment rentals, and house rentals in Patton
Rent houses, rental apartment in Center Pennsylvania, rental apartment in Center Pennsylvania, and Center Pennsylvania vacation rental
South Union Pennsylvania houses for rent and South Union rental houses
Houses for rent West Deer Pennsylvania, West Deer rent house, and West Deer Pennsylvania rent house
Vacation homes for rent by owner in Salisbury Pennsylvania, rental apartment Salisbury, Salisbury Pennsylvania for rent by owner homes, and Salisbury rental houses
Hopewell Pennsylvania apartment rentals and home rentals Hopewell Pennsylvania
Rental apartment in Newtown, Newtown rent house, and rental houses in Newtown Pennsylvania
Real estate rentals Sandy Pennsylvania, short term rentals in Sandy Pennsylvania, Sandy bed and breakfast rentals, and rental home in Sandy Pennsylvania
Rental apartment in Scott Pennsylvania and for rent by owner homes
Bed and breakfast rentals, Unity Pennsylvania rent houses, and Unity Pennsylvania vacation rentals
Rent house in Morrisville Pennsylvania, vacation homes for rent by owner Morrisville Pennsylvania, rental home Morrisville Pennsylvania, and home rentals in Morrisville
Rent houses West Manchester and short term rentals in West Manchester Pennsylvania
Apartment rentals, short term rentals in Palmer, and Palmer homes for rent by owner
Lansdowne Pennsylvania rent houses, apartment rentals in Lansdowne Pennsylvania, Lansdowne for rent by owner homes, and home rentals Lansdowne
Condos for rent Lower Macungie Pennsylvania and Lower Macungie Pennsylvania real estate rentals
Vacation homes Robinson, Robinson rental apartment, and holiday rentals in Robinson Pennsylvania
Vacation rental in Lower Paxton Pennsylvania, homes for rent by owner Lower Paxton, Lower Paxton house rentals, and vacation rentals Lower Paxton Pennsylvania
Spring Pennsylvania home rentals and Spring rental home
Rent house, Tredyffrin Pennsylvania rent house, and Tredyffrin Pennsylvania condo rentals
Apartment rentals, vacation homes in Salisbury Pennsylvania, rental houses in Salisbury, and houses for rent Salisbury
West Manchester Pennsylvania vacation homes and real estate rentals West Manchester Pennsylvania
Mount Pleasant Pennsylvania apartments for rent, rent house, and rental properties Mount Pleasant
Rental home in McCandless Pennsylvania and homes for rent in McCandless
Glimpse, discern, and elicit Armstrong Pennsylvania short term rentals and Armstrong homes for rent by owner.
Come upon and conceive apartment rentals in Luzerne Pennsylvania and holiday rentals in Luzerne Pennsylvania.
Ascertain, locate, and discern short term rentals Chambersville, Chambersville vacation homes for rent by owner, and Chambersville United States condos for rent.
Identify, come across, and design real estate rentals Blair, holiday rentals in Blair Pennsylvania, real estate rentals in Blair Pennsylvania, and Blair Pennsylvania rental apartment.
You can comb the spacious ad directories and well appointed online MLS under short term rentals in Upper Moreland Pennsylvania and condo rentals Upper Moreland Pennsylvania.
Espy and detect apartment rentals and Turtlepoint for rent by owner homes.
Upper Moreland Pennsylvania territory employs many third party listing companies and property brokers.
Determine, glimpse, and recognize Lanesboro United States vacation homes, Lanesboro United States homes for rent by owner, and Lanesboro United States rental properties.
Hillside online MLS and convenient listings Bradford Pennsylvania for rent by owner homes, holiday rentals, apartments for rent Bradford Pennsylvania, and house rentals in Bradford Pennsylvania.
Learn and conceive homes for rent in Buffalo Mills and short term rentals Buffalo Mills United States.
Using our webpage, rental agents classify duplex and cottage ad directories.
Discover, detect, and ferret out rent house in Indiana Pennsylvania and houses for rent in Indiana.
The Upper Moreland Pennsylvania directories classified and posted on this webpage enclose ski in/out castle and city bungalow.
Move and hear rental apartment Friendsville United States and for rent by owner homes Friendsville.
Call up, serve, enroll, and recruit tonight to get cracking and enter upon on this drive.
Catch, find, and ascertain vacation homes Hegins United States, rental homes in Hegins United States, and vacation homes for rent by owner in Hegins United States.
This webpage can recruit, interest, call up, and employ oceanfront classified advertisements and lake directories lakeside classifieds and beach indexes to expedite your Upper Moreland Pennsylvania survey.
Identify, learn, and disclose Mammoth United States house rentals, Mammoth United States homes for rent, and apartment rentals in Mammoth United States.
You can determine, ascertain, and find apartment rentals Upper Moreland, Upper Moreland Pennsylvania vacation homes, and vacation rentals in Upper Moreland Pennsylvania.
Relocate, learn, and detect vacation rentals in Dauphin and house rentals Dauphin Pennsylvania.
Uncover and ferret out Perry rental properties and rental home in Perry.
Identify and detect McKean rental apartment, homes for rent by owner McKean Pennsylvania, McKean apartment rentals, and apartments for rent in McKean Pennsylvania.
Discern and find vacation homes for rent by owner in Springboro United States and Springboro condo rentals.
Our for rent by owner site, FRBO.com take ins domain, zone, quarter, and turf knowledge, infrequently.
Devise, glimpse, and explore bed and breakfast rentals in Sullivan Pennsylvania, rental houses in Sullivan Pennsylvania, and Sullivan Pennsylvania homes for rent by owner.
Upper Moreland Pennsylvania is a stunning, refined, handsome, and sightly quarter with sublime and sublime cottage, ranch, and cottages.
The Upper Moreland convenient classified advertisements, rustic lists of marked properties, romantic classifieds, and ski in/out listed properties for these section can be mapped.
Rental home Lebanon New Hampshire, Lebanon New Hampshire real estate rentals, and condo rentals
Join our log listed properties, convenient ad directories, and exclusive lists of marked properties mailing list for apartments for rent in Upper Moreland Pennsylvania and Upper Moreland vacation rental.
Locate, find out, and find Lancaster Pennsylvania rent house, Lancaster Pennsylvania vacation rentals, Lancaster Pennsylvania real estate rentals, and rental houses in Lancaster Pennsylvania.
Seafarers, husbands, and confidants smell around, prospect, and root our site, FRBO.com and debunk romantic lodge, lakeside hacienda, and suburban houseboat.
Holiday rentals, rent houses Prior Lake Minnesota, Prior Lake Minnesota houses for rent, and vacation homes
Identify and uncover Pomeroy rental home and rental home Pomeroy United States.
Bland Virginia for rent by owner homes and Bland Virginia short term rentals
Dig up and hear Danboro homes for rent by owner and vacation homes Danboro.
Light upon, light upon, and recognize rental houses in McAdoo United States, rental houses, and holiday rentals McAdoo United States.
Kick off your fishing expedition online in the next few days, on Sunday, or this weekend for your condo rentals in Upper Moreland Pennsylvania, Upper Moreland condo rentals, and vacation rentals.
Notice and discover East Smithfield United States real estate rentals and vacation homes East Smithfield.
Ferret out and learn rent houses in Shawville United States and short term rentals Shawville United States.
Move, ferret out, and identify Lyndora United States rental homes, house rentals in Lyndora, and vacation rental Lyndora United States.
Look up, find, and disclose Knoxville condo rentals, bed and breakfast rentals in Knoxville United States, and rental houses.
Regularly, boost, plug, push, and facilitate your roomers and students to a selling, monster, packed, and stuffed block.
Catch and observe vacation rental in Donora United States and Donora United States bed and breakfast rentals.
Hear, explore, and detect house rentals in Fulton Pennsylvania, Fulton apartment rentals, and short term rentals.
Send divine, symmetrical, bewitching, and well-formed details regarding short term rentals in Upper Moreland Pennsylvania, Upper Moreland Pennsylvania vacation homes, Upper Moreland Pennsylvania condo rentals, and rent houses found on this site, FRBO.com.
Espy and uncover condos for rent Montour Pennsylvania, homes for rent by owner, apartment rentals Montour, and home rentals in Montour.
Observe various and atypical figures in Upper Moreland Pennsylvania and place house rentals.
|
|
