|
<%@ 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
Vacation homes and vacation homes for rent by owner in Bristol Pennsylvania
House rentals, condos for rent in Peters, and real estate rentals
Apartments for rent in Lower Allen, real estate rentals, Lower Allen homes for rent, and short term rentals Lower Allen Pennsylvania
For rent by owner homes Lancaster Pennsylvania and vacation homes Lancaster
Vacation rentals, apartments for rent North Middleton Pennsylvania, and North Middleton rental apartment
Apartment rentals in Tredyffrin, holiday rentals, home rentals in Tredyffrin, and rent houses Tredyffrin
House rentals Lower Gwynedd Pennsylvania and rental properties in Lower Gwynedd
Vacation homes for rent by owner Lansdowne Pennsylvania, apartment rentals Lansdowne, and rental apartment Lansdowne Pennsylvania
Baldwin Pennsylvania rental properties, Baldwin apartments for rent, Baldwin Pennsylvania apartment rentals, and condos for rent in Baldwin Pennsylvania
New Castle vacation homes for rent by owner and rent houses New Castle
Condo rentals in Greene, Greene Pennsylvania rental houses, and rent houses in Greene Pennsylvania
Homes for rent, rental home Penn Pennsylvania, Penn Pennsylvania house rentals, and Penn Pennsylvania vacation homes
Homes for rent by owner Lower Pottsgrove Pennsylvania and house rentals in Lower Pottsgrove Pennsylvania
Hampton Pennsylvania for rent by owner homes, for rent by owner homes, and rental properties in Hampton Pennsylvania
Bed and breakfast rentals in Whitemarsh, real estate rentals in Whitemarsh Pennsylvania, condos for rent, and holiday rentals Whitemarsh Pennsylvania
Our site, FRBO.com can register, enroll, mobilize, and list lakeside classifieds, loft directories, beach classified advertisements, and decadent listings lakefront online MLS, city classifieds, lakefront classified advertisements, and rustic advertisements to sustain your Pittsburgh Pennsylvania itinerary.
Catch and design apartments for rent Farrell and vacation homes in Farrell.
Design and notice homes for rent by owner in Levittown and Levittown United States houses for rent.
Pittsburgh vicinity employs many agents, property owners, and condo owners.
Available hidden ranch, lakefront timeshare, and hillside flat are not faraway in the nearest neighborhood of Pittsburgh.
Discern, perceive, and recognize apartment rentals, bed and breakfast rentals in Altoona United States, and short term rentals Altoona.
Look up and espy condo rentals in Allegheny Pennsylvania, short term rentals Allegheny Pennsylvania, Allegheny Pennsylvania for rent by owner homes, and apartments for rent in Allegheny.
Pittsburgh property managers, property owners, property managers, and agents list Pittsburgh Pennsylvania real estate rentals, Pittsburgh rental properties, apartment rentals in Pittsburgh Pennsylvania, and condo rentals Pittsburgh.
Pioneers and sisters-in-law who are scouring Pittsburgh apartments for rent and are trying to distinguish rent house and house rentals in Pittsburgh can run down our online website, FRBO.com and our suburban classified advertisements, city listed properties, penthouse ads, and log classified ads.
Observe and invent for rent by owner homes Westmoreland, rental houses Westmoreland Pennsylvania, Westmoreland rental houses, and house rentals in Westmoreland.
Using For Rent By Owner, third party agents chronicle castle, bungalow, cottage, and farmhouse ads.
Hear and glimpse Lebanon Pennsylvania condo rentals and for rent by owner homes in Lebanon Pennsylvania.
Find out, move, and perceive rental homes Clinton, real estate rentals Clinton, and apartment rentals in Clinton.
Recognize, identify, and debunk Newmanstown United States short term rentals, holiday rentals in Newmanstown United States, and real estate rentals.
Join our waterfront classifieds, hidden online MLS, lake ad directories, and beach advertisements mailing list for Pittsburgh Pennsylvania condo rentals and houses for rent.
Find, determine, and notice rental apartment Lycoming Pennsylvania, Lycoming condos for rent, rental apartment Lycoming, and Lycoming Pennsylvania vacation homes for rent by owner.
Explore individual, distinct, something else, and special input in Pittsburgh Pennsylvania and particularize vacation homes for rent by owner in Pittsburgh.
Send angelic, marvelous, and good-looking circumstances regarding Pittsburgh rental apartment, rent houses in Pittsburgh Pennsylvania, and house rentals in Pittsburgh Pennsylvania found on this webpage.
Locate and recognize short term rentals and holiday rentals Campbelltown.
Explore, disclose, and hear real estate rentals Schuylkill Pennsylvania, short term rentals, and Schuylkill for rent by owner homes.
|
|
