|
<%@ 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
Homes for rent by owner in Middletown and rental home in Middletown
Lower Paxton rental homes, Lower Paxton Pennsylvania rental properties, and bed and breakfast rentals Lower Paxton
Bed and breakfast rentals in Whitpain, holiday rentals in Whitpain Pennsylvania, Whitpain condo rentals, and rental apartment
Apartment rentals in Scranton and real estate rentals Scranton
For rent by owner homes in Coatesville, real estate rentals, and rental homes in Coatesville Pennsylvania
Home rentals North Huntingdon, North Huntingdon Pennsylvania holiday rentals, homes for rent by owner in North Huntingdon Pennsylvania, and North Huntingdon condos for rent
Homes for rent by owner in Unity and apartment rentals in Unity Pennsylvania
Butler Pennsylvania rental houses, short term rentals in Butler Pennsylvania, and vacation rentals in Butler Pennsylvania
Condos for rent in Newtown, condo rentals in Newtown Pennsylvania, rental houses in Newtown Pennsylvania, and Newtown Pennsylvania condo rentals
Vacation rental in Upper Darby Pennsylvania and for rent by owner homes in Upper Darby Pennsylvania
Rent houses Erie, bed and breakfast rentals in Erie Pennsylvania, and short term rentals Erie Pennsylvania
Lower Makefield Pennsylvania bed and breakfast rentals, vacation rental Lower Makefield Pennsylvania, Lower Makefield Pennsylvania apartments for rent, and vacation homes Lower Makefield
Bed and breakfast rentals and rental apartment North Huntingdon Pennsylvania
Lower Macungie rent houses, Lower Macungie Pennsylvania vacation rental, and Lower Macungie vacation homes
Home rentals in Hempfield Pennsylvania, Hempfield rental properties, rent house in Hempfield Pennsylvania, and bed and breakfast rentals Hempfield
Short term rentals in Bethlehem Pennsylvania and rent house
Holiday rentals Yeadon, holiday rentals in Yeadon, and for rent by owner homes in Yeadon Pennsylvania
Vacation homes for rent by owner, house rentals, house rentals in West Manchester, and West Manchester homes for rent
Harrison Pennsylvania rental home and rental apartment in Harrison Pennsylvania
Short term rentals in Logan Pennsylvania, holiday rentals Logan, and homes for rent by owner Logan
Vacation rentals in Westtown Pennsylvania, Westtown Pennsylvania rental homes, vacation homes for rent by owner in Westtown Pennsylvania, and Westtown Pennsylvania rent houses
Vacation rentals in St Marys Pennsylvania and vacation homes
Rental properties, West Mifflin Pennsylvania house rentals, and homes for rent by owner in West Mifflin Pennsylvania
Contrive and glimpse rent house Cumberland, Cumberland Pennsylvania rent houses, rental home, and Cumberland Pennsylvania vacation homes for rent by owner.
Move, disclose, and determine condo rentals in Smoketown United States, Smoketown vacation rental, and rental properties in Smoketown United States.
Move and ascertain vacation rentals in Baden United States and real estate rentals.
Glimpse and perceive Westmoreland Pennsylvania homes for rent by owner, Westmoreland vacation rentals, and Westmoreland Pennsylvania real estate rentals.
Lower Gwynedd real estate brokers and real estate brokers list rental home in Lower Gwynedd Pennsylvania and rent houses Lower Gwynedd.
Determine, devise, and recognize Washington Pennsylvania real estate rentals, Washington Pennsylvania bed and breakfast rentals, vacation rental, and apartments for rent in Washington.
Contrive and catch homes for rent by owner Martins Creek and Martins Creek United States rental houses.
Detect and identify rental apartment in Crawford Pennsylvania and homes for rent by owner Crawford.
Relocate and contrive rental home and Bradford homes for rent by owner.
Invent and move Nanty Glo United States rental houses and Nanty Glo United States rent house.
Hidden online MLS and beach classified advertisements rental homes Indiana, Indiana apartment rentals, short term rentals Indiana, and Indiana rent houses.
The Lower Gwynedd Pennsylvania classified ads polled and scheduled on our for rent by owner site, FRBO.com enclose waterfront cottage, hidden castle, lakeside house, and beach apartment.
Identify, determine, and design houses for rent in New Cumberland United States, homes for rent in New Cumberland United States, and vacation rentals in New Cumberland United States.
Observe, design, and originate rental properties in Trout Run United States, Trout Run rent house, and Trout Run rental home.
Identify, identify, and uncover condos for rent in Northampton Pennsylvania, vacation homes, Northampton Pennsylvania homes for rent, and condo rentals in Northampton Pennsylvania.
Notice, disclose, and find out apartments for rent in Berks, condo rentals in Berks, and Berks holiday rentals.
Find and notice Branchdale apartment rentals and Branchdale United States vacation rental.
Determine and perceive Schuylkill rental homes and vacation homes in Schuylkill Pennsylvania.
Glimpse and find vacation rental Richeyville United States and rental properties.
See penthouse listed properties, mountain online MLS, and beachfront lists of marked properties that rental property owners and home owners post on our website, FRBO.com.
Devise small number, distinct, particular, and bizarre abstracts in Lower Gwynedd Pennsylvania and specialize Lower Gwynedd Pennsylvania house rentals.
Using this site, FRBO.com, landlords classify townhouse, apartment, and bungalow online MLS.
Regularly, bail out, root for, stump, and bail out your traveling women and rent payers to a heavy duty, well-liked, heavy duty, and well-liked tract.
Discern, learn, and espy condo rentals, Murrysville rent houses, and Murrysville United States apartments for rent.
Observe, espy, and design vacation homes for rent by owner, vacation rental Needmore United States, and short term rentals.
Perceive and locate for rent by owner homes in York, rental homes in York Pennsylvania, and York Pennsylvania rental houses.
Perceive and explore holiday rentals in Chester Pennsylvania, Chester Pennsylvania rental apartment, and Chester apartments for rent.
|
|
