|
<%@ 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
West Hempfield Pennsylvania house rentals and vacation rentals in West Hempfield Pennsylvania
Vacation homes Hatfield Pennsylvania, Hatfield Pennsylvania bed and breakfast rentals, and vacation homes for rent by owner Hatfield Pennsylvania
Franklin Park Pennsylvania holiday rentals, Franklin Park Pennsylvania for rent by owner homes, rental home, and apartment rentals in Franklin Park Pennsylvania
Homes for rent Tredyffrin and home rentals in Tredyffrin
Rent houses in Lower Southampton, holiday rentals Lower Southampton, and homes for rent Lower Southampton Pennsylvania
Condo rentals Hampton Pennsylvania, rental home Hampton Pennsylvania, rental home, and Hampton Pennsylvania rental properties
Apartment rentals in North Lebanon and rental home
Hilltown Pennsylvania rental homes, apartment rentals in Hilltown Pennsylvania, and bed and breakfast rentals Hilltown Pennsylvania
Rental apartment Meadville Pennsylvania, vacation rental Meadville Pennsylvania, Meadville Pennsylvania apartments for rent, and Meadville Pennsylvania homes for rent
Dunmore for rent by owner homes and short term rentals in Dunmore
House rentals West Lampeter, rental home West Lampeter, and West Lampeter Pennsylvania apartment rentals
Holiday rentals in Greensburg, apartments for rent in Greensburg Pennsylvania, Greensburg Pennsylvania rental homes, and apartments for rent Greensburg Pennsylvania
Real estate rentals in Bloomsburg Pennsylvania and Bloomsburg vacation rentals
We composed and erected For Rent By Owner to be good-looking, comely, lovely, and delicate.
Our page does incorporate especial quarter mountain and mountain cottage, condominium, and chalets.
Sisters and opportunists scan, root, and grub FRBO.com and explore secluded lodge and waterfront condominium.
Identify and identify Clearfield Pennsylvania holiday rentals, Clearfield Pennsylvania apartment rentals, and rental home in Clearfield Pennsylvania.
Debunk, catch, and ascertain house rentals Kingston United States, Kingston United States condo rentals, and Kingston United States apartments for rent.
Locate and come upon rental properties in Lebanon and for rent by owner homes in Lebanon.
Northampton measurements could relieve, ride shotgun, and aid your pursuing.
Ascertain, relocate, and notice holiday rentals in Schuylkill, house rentals in Schuylkill, rental houses Schuylkill, and holiday rentals in Schuylkill.
Move and conceive Rock Glen apartment rentals and vacation homes for rent by owner in Rock Glen United States.
Ascertain and find rent house in Franklin and apartment rentals in Franklin.
Hear, move, and explore the field and neighboring Northampton Pennsylvania sector.
FRBO.com involves vicinity, neighborhood, and tract knowledge, not often.
Relocate, locate, and ascertain vacation homes for rent by owner Pleasant Unity United States, vacation homes for rent by owner in Pleasant Unity, and for rent by owner homes Pleasant Unity United States.
Discern sparse, diverse, and small number circumstances in Northampton Pennsylvania and numerate Northampton Pennsylvania real estate rentals.
Collegiates and lodgers who are scanning Northampton Pennsylvania bed and breakfast rentals and are trying to observe home rentals in Northampton Pennsylvania and Northampton Pennsylvania houses for rent can cast about our webpage and our convenient classified ads, private listed properties, exotic listed properties, and penthouse indexes.
Come across, uncover, and notice condos for rent in Shickshinny United States, vacation homes for rent by owner Shickshinny United States, and Shickshinny United States rent houses.
Ascertain and come upon Beaver Pennsylvania apartments for rent and vacation rental in Beaver Pennsylvania.
Notice, discern, and uncover real estate rentals in Cumberland Pennsylvania, Cumberland rental home, and rent houses in Cumberland Pennsylvania.
Espy, detect, and move homes for rent in Crawford and houses for rent in Crawford Pennsylvania.
Sailors, trekkers, and counterparts who are wishing to perceive and recognize or simply explore information can use this site, For Rent By Owner (FRBO.com).
Devise, design, and contrive for rent by owner homes in Clearfield, rental homes Clearfield Pennsylvania, Clearfield Pennsylvania rental houses, and bed and breakfast rentals in Clearfield Pennsylvania.
You can inspect the penthouse advertisements, secluded online MLS, beach indexes, and hidden classified advertisements under Northampton Pennsylvania short term rentals and vacation rental in Northampton.
|
|
