|
<%@ 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
Short term rentals in Pottstown Pennsylvania and condo rentals Pottstown
Rental properties Exeter, vacation rental in Exeter, and rental properties Exeter Pennsylvania
Apartment rentals in Warren, houses for rent Warren Pennsylvania, houses for rent in Warren, and houses for rent in Warren Pennsylvania
Vacation homes for rent by owner in North Middleton Pennsylvania and vacation rental in North Middleton Pennsylvania
North Versailles house rentals, North Versailles Pennsylvania for rent by owner homes, and for rent by owner homes North Versailles Pennsylvania
Johnstown Pennsylvania rent house, rental properties Johnstown, real estate rentals in Johnstown, and rental apartment Johnstown Pennsylvania
Bed and breakfast rentals in Susquehanna Pennsylvania and Susquehanna Pennsylvania home rentals
Rental properties in Towamencin Pennsylvania, houses for rent in Towamencin, and Towamencin Pennsylvania rental apartment
Upper Gwynedd rental home, Upper Gwynedd Pennsylvania rent houses, Upper Gwynedd Pennsylvania bed and breakfast rentals, and vacation rental Upper Gwynedd
West Norriton Pennsylvania condos for rent and West Norriton Pennsylvania for rent by owner homes
Rental houses West Chester, rent houses West Chester, and West Chester vacation homes
Tredyffrin Pennsylvania vacation rental, Tredyffrin Pennsylvania short term rentals, Tredyffrin Pennsylvania vacation rental, and houses for rent in Tredyffrin Pennsylvania
Condos for rent in Uwchlan Pennsylvania and holiday rentals in Uwchlan
Municipality of Monroeville Pennsylvania rental houses, Municipality of Monroeville rental houses, and Municipality of Monroeville Pennsylvania homes for rent
Lower Paxton Pennsylvania homes for rent by owner, homes for rent in Lower Paxton Pennsylvania, holiday rentals in Lower Paxton, and Lower Paxton Pennsylvania house rentals
East Hempfield Pennsylvania apartment rentals and for rent by owner homes in East Hempfield Pennsylvania
Reading Pennsylvania homes for rent by owner, homes for rent in Reading Pennsylvania, and Reading Pennsylvania bed and breakfast rentals
Real estate rentals in Cheltenham Pennsylvania, vacation rental, house rentals in Cheltenham Pennsylvania, and home rentals Cheltenham
Short term rentals Baldwin Pennsylvania and Baldwin Pennsylvania real estate rentals
Rent houses, homes for rent Limerick, and Limerick rental home
Norristown Pennsylvania vacation rentals, vacation rental in Norristown Pennsylvania, homes for rent by owner Norristown, and Norristown short term rentals
Vacation homes for rent by owner Lower Makefield Pennsylvania and apartments for rent
Hatfield Pennsylvania house rentals, holiday rentals in Hatfield Pennsylvania, and Hatfield Pennsylvania home rentals
Yeadon Pennsylvania rental apartment, rental houses in Yeadon Pennsylvania, rent house Yeadon Pennsylvania, and Yeadon vacation homes for rent by owner
Vacation rental in Westtown Pennsylvania and Westtown Pennsylvania apartment rentals
Homes for rent by owner in Manor, Manor home rentals, and Manor short term rentals
Apartments for rent Moon Pennsylvania, homes for rent by owner Moon Pennsylvania, for rent by owner homes in Moon, and Moon rent house
Northampton Pennsylvania for rent by owner homes and rental properties
Spring Pennsylvania short term rentals, bed and breakfast rentals Spring Pennsylvania, and rental homes Spring Pennsylvania
Hilltown Pennsylvania rental homes, Hilltown holiday rentals, Hilltown house rentals, and Hilltown home rentals
Hampton for rent by owner homes and Hampton Pennsylvania house rentals
Vacation homes, rent houses Springettsbury Pennsylvania, and Springettsbury Pennsylvania home rentals
Take on and engage day after tomorrow to kick off and launch on this march.
Find out and elicit rental properties Allegheny Pennsylvania and Allegheny Pennsylvania home rentals.
Uncover, light upon, and originate homes for rent in Turkey City, holiday rentals Turkey City, and Turkey City United States rental apartment.
The Pottstown studio ads, loft lists of marked properties, and mountain online MLS for these locality can be mapped.
Vacation homes North Hempstead New York and North Hempstead New York rental homes
Contrive and espy rental home, Franklin Pennsylvania holiday rentals, house rentals Franklin Pennsylvania, and Franklin Pennsylvania apartments for rent.
We contrived, composed, and authored our webpage to be splendid, splendid, admirable, and shapely.
Elicit, relocate, and find vacation rentals in Washington and homes for rent by owner.
Explore and determine rental apartment in Delta United States and rental properties in Delta United States.
Usually, support, push, and plug your voyagers, pirates, and companions to a pleasant, captivating, and husky county.
Light upon, learn, and observe Warminster house rentals, Warminster United States condo rentals, and Warminster United States vacation rentals.
Dig up and distinguish rental home in Tioga and Tioga holiday rentals.
Roomers and collegiates who are investigating real estate rentals Pottstown and are trying to hear rent houses, bed and breakfast rentals, and condos for rent in Pottstown can look our for rent by owner site, FRBO.com and our beachfront directories and city listings.
Discern and move Lehigh Pennsylvania vacation homes and rental properties in Lehigh Pennsylvania.
Our for rent by owner site, FRBO.com arranges zone and township dope, oftentimes.
Condos for rent in Olathe, vacation rental Olathe, Olathe Kansas home rentals, and Olathe Kansas houses for rent
Dig up and catch Monroe homes for rent, rent houses in Monroe, and bed and breakfast rentals in Monroe Pennsylvania.
Explore, perceive, and contrive the neighborhood and adjoining Pottstown stretch.
See exclusive listed properties, waterfront listed properties, and beach lists of marked properties that real estate agents and agents post on this extensive website, FRBO.com.
You can chase after the oceanfront classifieds, resort classified ads, loft indexes, and romantic listings under vacation rentals and Pottstown Pennsylvania apartment rentals.
Our for rent by owner website does exclude uncommon ski in/out, oceanfront, and lakeside ranch and chalets.
Ascertain, come upon, and detect rental apartment in Chester Pennsylvania and bed and breakfast rentals Chester.
Devise uncommon, ad hoc, unique, and express poop sheet in Pottstown Pennsylvania and docket homes for rent by owner Pottstown.
Pottstown Pennsylvania compilations could root for, further, support, and collaborate your inquiry.
Find, move, and determine condos for rent Schuylkill Pennsylvania, house rentals in Schuylkill Pennsylvania, and Schuylkill Pennsylvania real estate rentals.
Determine, detect, and find out Llewellyn apartment rentals, vacation homes, and vacation rental in Llewellyn United States.
Design and originate Southview United States rental homes and holiday rentals in Southview.
Send fair and symmetrical poop sheet regarding homes for rent by owner in Pottstown, vacation homes for rent by owner in Pottstown Pennsylvania, real estate rentals in Pottstown Pennsylvania, and Pottstown Pennsylvania home rentals found on this site, FRBO.com.
Come upon and explore Dry Run United States rental apartment and rental apartment in Dry Run.
Pleasant Prairie Wisconsin rental apartment, Pleasant Prairie vacation rental, Pleasant Prairie Wisconsin condo rentals, and rental properties Pleasant Prairie
Buffalo rental apartment, houses for rent, and Buffalo Minnesota houses for rent
Look up and conceive homes for rent in Pocopson and rent house Pocopson.
Rental apartment in Neabsco and Neabsco Virginia condo rentals
Espy and catch Mount Morris United States homes for rent by owner and condo rentals in Mount Morris United States.
Discover, glimpse, and identify rental properties in Home United States, rent houses in Home United States, and short term rentals in Home United States.
Originate and determine rental apartment and vacation rentals in Jenkintown United States.
Join our decadent directories, resort listings, mountain online MLS, and exotic ads mailing list for vacation rental, rental homes Pottstown Pennsylvania, and condo rentals.
Light upon, light upon, and explore for rent by owner homes in Columbus United States, houses for rent Columbus, and homes for rent by owner in Columbus.
House rentals in Hampton Pennsylvania, rental apartment in Hampton Pennsylvania, and vacation rentals Hampton Pennsylvania
Rental apartment, rent houses, and Lower Merion house rentals
Find out and catch homes for rent by owner Youngwood and rent houses in Youngwood.
Rent house Kalispell Montana, Kalispell rental apartment, rent house in Kalispell Montana, and Kalispell condos for rent
Hear, come across, and identify home rentals, Lebanon Pennsylvania homes for rent, vacation homes for rent by owner in Lebanon Pennsylvania, and real estate rentals in Lebanon Pennsylvania.
Pottstown zone employs many real estate agents and land owners.
Using this webpage, rental property owners manifest vacation home, lodge, home, and lodge online MLS.
Move and ferret out rental properties in Venango Pennsylvania, Venango rent house, and apartments for rent in Venango Pennsylvania.
Dig up and determine condo rentals and rental home Marshalls Creek.
Invent, come across, and ferret out Kulpsville vacation homes for rent by owner, Kulpsville United States vacation rentals, and houses for rent in Kulpsville.
Espy, come across, and light upon Beach Lake United States for rent by owner homes, condo rentals in Beach Lake United States, and vacation rental in Beach Lake United States.
Recently vacated exotic bungalow, spacious hacienda, and penthouse condominium are near-at-hand in the not to distant township of Pottstown Pennsylvania.
Debunk and ferret out Drumore rental properties and Drumore United States houses for rent.
|
|
