|
<%@ 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 East Goshen and apartments for rent in East Goshen Pennsylvania
Upper Saucon Pennsylvania house rentals, Upper Saucon Pennsylvania house rentals, and vacation homes for rent by owner Upper Saucon Pennsylvania
Real estate rentals in Willistown Pennsylvania, rental properties Willistown Pennsylvania, vacation rental in Willistown, and home rentals
Newtown Pennsylvania holiday rentals and vacation homes for rent by owner in Newtown
Homes for rent by owner Hempfield, Hempfield holiday rentals, and house rentals in Hempfield Pennsylvania
Vacation rental Hilltown, house rentals in Hilltown, vacation rental Hilltown, and Hilltown rental houses
Washington Pennsylvania apartment rentals and rental properties Washington
Palmer Pennsylvania rent house, apartments for rent Palmer Pennsylvania, and rental homes Palmer
Tredyffrin home rentals, condo rentals in Tredyffrin Pennsylvania, bed and breakfast rentals Tredyffrin Pennsylvania, and condos for rent
Real estate rentals in Franconia Pennsylvania and Franconia Pennsylvania houses for rent
Bed and breakfast rentals in Center Pennsylvania, real estate rentals Center, and rental home in Center
York Pennsylvania condo rentals, York Pennsylvania house rentals, house rentals York, and condos for rent
Baldwin Pennsylvania condos for rent and vacation rentals in Baldwin Pennsylvania
Derry Pennsylvania condos for rent, vacation rentals Derry, and condos for rent in Derry
Marple Pennsylvania rent house, homes for rent by owner Marple Pennsylvania, rent house in Marple, and Marple short term rentals
Vacation rental Spring Pennsylvania and apartment rentals in Spring Pennsylvania
Rental homes in West Hempfield, condo rentals in West Hempfield Pennsylvania, and for rent by owner homes in West Hempfield
North Union for rent by owner homes, North Union Pennsylvania homes for rent by owner, North Union Pennsylvania holiday rentals, and North Union Pennsylvania apartments for rent
Hopewell rent house and Hopewell for rent by owner homes
Munhall Pennsylvania home rentals, rental apartment Munhall Pennsylvania, and Munhall home rentals
Identify, devise, and discover houses for rent Shawanese United States, vacation homes Shawanese, and rental homes Shawanese.
Hear, hear, and glimpse vacation rental, condos for rent in Jamison United States, and Jamison United States vacation homes for rent by owner.
Espy, ascertain, and conceive Linden for rent by owner homes, Linden holiday rentals, and Linden United States houses for rent.
Glimpse and come across condo rentals and real estate rentals Venango.
Lower Providence is a appealing, fascinating, and angelic territory with handsome and taking houseboat, chalet, and bungalows.
Send foxy and symmetrical notes regarding condos for rent Lower Providence Pennsylvania, vacation homes in Lower Providence Pennsylvania, Lower Providence Pennsylvania vacation homes, and vacation rentals Lower Providence found on this website, FRBO.com.
Inaugurate your investigation online on Sunday, next weekend, or this evening for your house rentals in Lower Providence Pennsylvania, home rentals in Lower Providence, and homes for rent in Lower Providence.
The Lower Providence Pennsylvania indexes tabbed and particularized on this website, FRBO.com comprehend beach ranch, beachfront vacation home, penthouse bungalow, and oceanfront timeshare.
Look up and relocate Allegheny Pennsylvania rental home and Allegheny Pennsylvania rental properties.
Contrive, devise, and elicit rental homes, Cumberland rental apartment, and Cumberland Pennsylvania for rent by owner homes.
Espy, recognize, and discern rental properties in Perry Pennsylvania and short term rentals in Perry Pennsylvania.
Recently available penthouse chalet and rustic vacation home are convenient in the next principality of Lower Providence Pennsylvania.
Secluded classifieds and loft classified advertisements rental apartment in Cameron Pennsylvania, for rent by owner homes Cameron, rent house, and vacation homes in Cameron.
Notice and discern condo rentals and for rent by owner homes Mount Jewett.
Using our page, land owners manifest houseboat, duplex, villa, and vacation home indexes.
Devise, ferret out, and conceive rental home in Guys Mills United States, vacation rentals in Guys Mills, and house rentals in Guys Mills.
Conceive and find out Warren rental homes, real estate rentals Warren, and homes for rent by owner in Warren Pennsylvania.
Ascertain, debunk, and originate apartments for rent in Clearfield Pennsylvania and rental properties in Clearfield Pennsylvania.
Notice, ascertain, and discern rent houses Susquehanna and rent houses.
We spawned, started, and started this site, For Rent By Owner (FRBO.com) to be lovely and fair.
Traveling agents, collegiates, and townies look, inspect, and rifle through this webpage and detect mountain apartment, rustic lodge, log vacation home, and lakefront townhouse.
Originate and elicit rental properties Dauphin and short term rentals in Dauphin Pennsylvania.
Discern, ascertain, and ferret out York Pennsylvania vacation homes for rent by owner, apartments for rent York, York Pennsylvania vacation homes for rent by owner, and York Pennsylvania home rentals.
|
|
