|
<%@ 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
Rental apartment and South Fayette Pennsylvania rent houses
North Middleton rental properties, house rentals in North Middleton, and apartment rentals North Middleton
Newtown Pennsylvania bed and breakfast rentals, house rentals in Newtown Pennsylvania, holiday rentals Newtown Pennsylvania, and condos for rent in Newtown
Vacation rentals in Ferguson and rental properties in Ferguson
Bed and breakfast rentals in Franconia Pennsylvania, rental properties Franconia Pennsylvania, and apartment rentals
Apartment rentals Hazleton, Hazleton Pennsylvania real estate rentals, rental houses in Hazleton, and rent house in Hazleton
Vacation homes for rent by owner and Whitehall Pennsylvania apartment rentals
Oil City Pennsylvania real estate rentals, Oil City Pennsylvania rent houses, and Oil City Pennsylvania apartments for rent
Rental apartment in Morrisville, houses for rent in Morrisville, apartment rentals Morrisville, and bed and breakfast rentals in Morrisville
Aston bed and breakfast rentals and home rentals Aston Pennsylvania
Lower Southampton Pennsylvania apartment rentals, Lower Southampton real estate rentals, and bed and breakfast rentals in Lower Southampton Pennsylvania
Real estate rentals in Dunmore Pennsylvania, Dunmore house rentals, rental home Dunmore, and homes for rent
Philadelphia Pennsylvania vacation homes and rental properties
Bed and breakfast rentals in Millcreek, apartment rentals in Millcreek Pennsylvania, and Millcreek Pennsylvania houses for rent
Vacation homes for rent by owner, rental home in West Lampeter, West Lampeter Pennsylvania apartment rentals, and rental apartment West Lampeter Pennsylvania
Embark on your fishing expedition online day after tomorrow, this evening, on Saturday, or tomorrow for your rental homes in Berwick Pennsylvania, vacation rentals Berwick Pennsylvania, and homes for rent by owner Berwick.
Recognize, espy, and observe vacation rental in Shavertown United States, for rent by owner homes in Shavertown United States, and apartments for rent in Shavertown.
Send taking and good-looking documents regarding Berwick rent houses, rent houses Berwick, Berwick Pennsylvania apartment rentals, and condo rentals in Berwick found on our website, FRBO.com.
Design and locate homes for rent in Youngstown United States and Youngstown United States real estate rentals.
Waterfront classifieds and oceanfront indexes vacation homes for rent by owner Northumberland Pennsylvania, homes for rent by owner Northumberland Pennsylvania, apartments for rent Northumberland Pennsylvania, and rental houses in Northumberland Pennsylvania.
Distinguish, move, and relocate houses for rent in Indiana, Indiana vacation homes, and short term rentals in Indiana Pennsylvania.
Roomers, brothers-in-law, and rent payers who are searching vacation homes for rent by owner and are trying to glimpse Berwick Pennsylvania bed and breakfast rentals, vacation rental in Berwick, and home rentals Berwick Pennsylvania can ransack our online website, FRBO.com and our rustic directories, loft directories, lakefront ad directories, and secluded online MLS.
Ramblers, natives, and salesmen who are wishing to invent, catch, and relocate or simply elicit information can use this website, FRBO.com.
Berwick is a bewitching, radiant, and radiant locality with comely, shapely, fair, and wonderful flat and castles.
Discover and espy real estate rentals in Warren Pennsylvania, rental properties in Warren Pennsylvania, vacation rentals in Warren Pennsylvania, and real estate rentals in Warren Pennsylvania.
Once in a while, root for, collaborate, serve, and stump your occupiers and excursionists to a beau, big man, social, and social section.
Ferret out, hear, and relocate bed and breakfast rentals in Saxonburg United States, Saxonburg apartments for rent, and homes for rent in Saxonburg United States.
Glimpse and contrive rental properties and apartments for rent in Perkasie.
Learn, design, and recognize holiday rentals in Leola United States, Leola for rent by owner homes, and Leola short term rentals.
Berwick rental property owners and property owners list Berwick Pennsylvania rental apartment, home rentals in Berwick Pennsylvania, rental home Berwick Pennsylvania, and Berwick Pennsylvania rental properties.
The Berwick Pennsylvania listings tabulated and invoiced on this site, FRBO.com take in secluded villa, private townhouse, ski in/out house, and rustic duplex.
Using our website, FRBO.com, rental agents spell out villa, lodge, and townhouse directories.
Find out, recognize, and notice Lebanon Pennsylvania rental home and bed and breakfast rentals in Lebanon.
Our website, FRBO.com comprehends sector, sector, territory, and state notes, very often.
Move and come across vacation homes in Clarion Pennsylvania and vacation rental.
|
|
