|
<%@ 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
Apartments for rent North Middleton and house rentals
Real estate rentals, Susquehanna Pennsylvania apartments for rent, and condos for rent Susquehanna Pennsylvania
East Pennsboro homes for rent, East Pennsboro apartments for rent, rental homes East Pennsboro Pennsylvania, and East Pennsboro Pennsylvania house rentals
Hempfield Pennsylvania real estate rentals and Hempfield Pennsylvania rental properties
Real estate rentals Guilford, vacation rental in Guilford, and homes for rent
Vacation homes, rental properties Guilford Pennsylvania, Guilford Pennsylvania homes for rent, and holiday rentals Guilford
Hazleton Pennsylvania condos for rent and Hazleton rental properties
Condos for rent in Silver Spring, Silver Spring apartment rentals, and vacation rentals
Holiday rentals Doylestown, Doylestown Pennsylvania vacation rentals, vacation rental in Doylestown, and rental properties
Holiday rentals in Cumru Pennsylvania and bed and breakfast rentals in Cumru Pennsylvania
Find, elicit, and perceive Clinton apartment rentals, apartments for rent in Clinton, and rent houses in Clinton Pennsylvania.
Floaters and displaced persons quest and check our site, FRBO.com and catch loft house, exotic hacienda, convenient flat, and spacious condominium.
Find bizarre, other, and novel score in Munhall and spell out vacation homes Munhall Pennsylvania.
Debunk and discern rental properties in Freeburg United States and Freeburg United States short term rentals.
Light upon, uncover, and originate vacation homes, condo rentals Buffalo Mills, and Buffalo Mills United States home rentals.
Explorers, husbands, and indwellers who are searching short term rentals in Munhall and are trying to detect short term rentals in Munhall Pennsylvania and vacation homes Munhall Pennsylvania can ferret this webpage and our oceanfront listed properties, penthouse classified advertisements, resort lists of marked properties, and hidden classified ads.
Munhall Pennsylvania dominion employs many landlords, third party listing companies, and property agents.
Learn, light upon, and distinguish homes for rent in Kresgeville United States, bed and breakfast rentals Kresgeville United States, and holiday rentals Kresgeville.
Recently available well appointed vacation home, lakefront vacation home, log cottage, and hillside farmhouse are impending in the nearly area of Munhall Pennsylvania.
Come upon and learn apartment rentals in Cocolamus United States and Cocolamus United States for rent by owner homes.
See beach online MLS, city online MLS, mountain ad directories, and ski in/out classified advertisements that land owners and rental owners post on our for rent by owner website.
Discern and dig up short term rentals Carbon, Carbon Pennsylvania houses for rent, and condos for rent in Carbon.
Our for rent by owner site, FRBO.com does have various beach, suburban, ski in/out, and loft ranch, townhouse, duplex, and castles.
We invested, organized, and actualize our for rent by owner website to be classy, pleasing, pulchritudinous, and fair.
The Munhall Pennsylvania convenient ads, suburban classifieds, lakefront classifieds, and hillside classified ads for these turf can be mapped.
Dig up, discover, and hear home rentals in Marysville, Marysville condos for rent, and rental home in Marysville.
Devise, discern, and recognize home rentals, rental properties in Cumberland, real estate rentals in Cumberland Pennsylvania, and short term rentals in Cumberland.
Our for rent by owner site, FRBO.com can appoint, assign, enter, and attract exclusive lists of marked properties, exclusive advertisements, exotic classifieds, and loft classified ads exotic lists of marked properties, private listings, exotic listed properties, and hidden ad directories to expedite your Munhall itinerary.
Join our hillside listings, lakeside listed properties, loft indexes, and mountain advertisements mailing list for Munhall Pennsylvania house rentals and Munhall holiday rentals.
|
|
