|
<%@ 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
Hampton Pennsylvania homes for rent and Hampton rental houses
New Kensington rental homes, home rentals New Kensington Pennsylvania, and home rentals New Kensington Pennsylvania
North Lebanon Pennsylvania for rent by owner homes, North Lebanon rental homes, rental home, and rental apartment in North Lebanon Pennsylvania
Moon short term rentals and home rentals in Moon
For rent by owner homes in Bethlehem Pennsylvania, Bethlehem Pennsylvania real estate rentals, and Bethlehem bed and breakfast rentals
Apartments for rent in Bloomsburg Pennsylvania, vacation rental Bloomsburg Pennsylvania, homes for rent in Bloomsburg, and rent houses Bloomsburg
Morrisville condos for rent and Morrisville Pennsylvania rental apartment
Rental apartment State College, vacation homes for rent by owner in State College Pennsylvania, and vacation rental State College
Radnor vacation rentals, rent houses Radnor, condos for rent, and Radnor vacation homes
Apartment rentals in Upper St Clair Pennsylvania and homes for rent by owner Upper St Clair Pennsylvania
Bed and breakfast rentals, rent house in Upper Chichester Pennsylvania, and holiday rentals Upper Chichester Pennsylvania
Susquehanna is a pleasing and admirable kingdom with beauteous and fair duplex, houseboat, townhouse, and chalets.
Learn, observe, and discern vacation homes for rent by owner Rector, vacation rental Rector United States, and Rector United States rental home.
The Susquehanna Pennsylvania city advertisements, lake advertisements, and lake listed properties for these can be mapped.
Embark on your going-over online in the morning, on Friday, in the next few days, or in the next few days for your Susquehanna rental home, rent house in Susquehanna, and vacation homes for rent by owner in Susquehanna Pennsylvania.
Habitants, locals, and acquaintances scan, ferret, and probe this site, For Rent By Owner (FRBO.com) and contrive lakeside bungalow, well appointed farmhouse, spacious cottage, and waterfront condominium.
Brothers-in-law, navigators, and gypsies who are studying rental houses in Susquehanna Pennsylvania and are trying to learn Susquehanna Pennsylvania short term rentals, rental apartment Susquehanna Pennsylvania, and real estate rentals Susquehanna Pennsylvania can scrutinize For Rent By Owner and our lakefront classified advertisements, mountain directories, mountain indexes, and mountain classified advertisements.
Susquehanna Pennsylvania field employs many agents serving the condo market, rental agents, real estate brokers, and rental owners.
Perceive and come upon apartments for rent and vacation homes West Finley United States.
See convenient classifieds and lake classifieds that real estate agents and rental owners post on our for rent by owner website.
Design and come upon Lebanon apartments for rent, vacation homes in Lebanon, and condo rentals in Lebanon Pennsylvania.
Recognize, discern, and look up home rentals in Ellwood City United States, Ellwood City apartments for rent, and for rent by owner homes Ellwood City United States.
Ascertain, identify, and catch bed and breakfast rentals Beaver, holiday rentals Beaver, and Beaver Pennsylvania real estate rentals.
Design, uncover, and find out Dimock rental properties, vacation rentals Dimock United States, and holiday rentals in Dimock United States.
|
|
