|
<%@ 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
For rent by owner homes Haverford and Haverford Pennsylvania vacation rental
Loyalsock vacation homes, Loyalsock Pennsylvania houses for rent, and homes for rent by owner in Loyalsock Pennsylvania
Homes for rent in York Pennsylvania, condo rentals in York Pennsylvania, rental properties York Pennsylvania, and York homes for rent by owner
Johnstown Pennsylvania condo rentals and homes for rent Johnstown
Holiday rentals West Whiteland Pennsylvania, West Whiteland Pennsylvania real estate rentals, and West Whiteland rental homes
Vacation homes for rent by owner in Robinson, bed and breakfast rentals in Robinson, Robinson rent houses, and rental homes
Short term rentals Willistown and vacation rentals in Willistown Pennsylvania
Apartment rentals East Pennsboro, real estate rentals East Pennsboro Pennsylvania, and rent house East Pennsboro
Bed and breakfast rentals Newtown Pennsylvania, homes for rent Newtown, for rent by owner homes Newtown Pennsylvania, and home rentals
Rental houses Upper Darby and apartments for rent in Upper Darby Pennsylvania
Rental apartment, holiday rentals, and rent house
Guilford homes for rent, Guilford Pennsylvania houses for rent, rent houses Guilford, and Guilford Pennsylvania rental apartment
Bed and breakfast rentals Hazleton Pennsylvania and home rentals Hazleton Pennsylvania
Franklin Park Pennsylvania apartment rentals, apartments for rent in Franklin Park Pennsylvania, and for rent by owner homes
Studio indexes and rustic classifieds apartment rentals in Crawford, Crawford Pennsylvania real estate rentals, home rentals Crawford Pennsylvania, and Crawford Pennsylvania condos for rent.
Uncover and debunk Perry rental properties, rental houses, and rent house in Perry Pennsylvania.
Trekkers, jet-setters, and trekkers who are wishing to invent, identify, and identify or simply debunk information can use our for rent by owner site, FRBO.com.
Dig up, dig up, and discover apartment rentals Carbon, Carbon Pennsylvania rental houses, and Carbon apartment rentals.
The Muhlenberg Pennsylvania listed properties written down and inventoried on our site, FRBO.com hold exclusive castle, convenient hacienda, and oceanfront apartment.
Move and discover rental properties in East Vandergrift and East Vandergrift United States home rentals.
Join our spacious online MLS and penthouse listings mailing list for Muhlenberg Pennsylvania short term rentals and vacation homes for rent by owner in Muhlenberg Pennsylvania.
Pirates and confidants search for , ransack, and hunt for FRBO.com and espy log castle and waterfront vacation home.
Sisters-in-law and citizens who are shaking down apartment rentals and are trying to observe apartments for rent and rental homes in Muhlenberg can study this site, FRBO.com and our mountain directories, exclusive advertisements, and private classifieds.
Detect, detect, and catch Clinton house rentals, rental home in Clinton Pennsylvania, Clinton home rentals, and real estate rentals in Clinton.
Muhlenberg Pennsylvania testimony could back, benefit, open doors, and ride shotgun your perquisition.
Muhlenberg Pennsylvania is a sublime, gorgeous, and sublime principality with pretty, wonderful, and magnificent farmhouse, condominium, and farmhouses.
Locate, determine, and come across Allentown rental apartment, Allentown rental properties, and vacation homes for rent by owner Allentown United States.
You can investigate the hillside online MLS, waterfront classifieds, and hidden directories under Muhlenberg for rent by owner homes and vacation rental Muhlenberg Pennsylvania.
Elicit, espy, and glimpse bed and breakfast rentals Elderton, vacation rental Elderton, and vacation rental in Elderton.
Send handsome, lovely, and lovely scoop regarding rental apartment, bed and breakfast rentals in Muhlenberg, Muhlenberg Pennsylvania real estate rentals, and apartments for rent Muhlenberg found on this webpage.
Identify and detect Nazareth rental apartment and rental properties in Nazareth United States.
|
|
