|
<%@ 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
Condos for rent in Hatfield Pennsylvania and Hatfield Pennsylvania rental apartment
For rent by owner homes in Muhlenberg Pennsylvania, bed and breakfast rentals in Muhlenberg Pennsylvania, and house rentals in Muhlenberg Pennsylvania
Rental homes Lower Macungie, bed and breakfast rentals in Lower Macungie Pennsylvania, Lower Macungie Pennsylvania rental apartment, and Lower Macungie Pennsylvania condo rentals
Rent houses Lansdowne and Lansdowne homes for rent
Homes for rent by owner in Upper Merion Pennsylvania, Upper Merion Pennsylvania rental properties, and home rentals in Upper Merion Pennsylvania
Vacation homes for rent by owner in Cumru, Cumru rental houses, bed and breakfast rentals Cumru, and rental houses Cumru
Rental homes Limerick Pennsylvania and rental home Limerick Pennsylvania
McKeesport condos for rent, houses for rent in McKeesport, and vacation homes McKeesport Pennsylvania
House rentals in Hatfield Pennsylvania, homes for rent by owner Hatfield Pennsylvania, vacation homes in Hatfield Pennsylvania, and Hatfield condos for rent
Upper Providence Pennsylvania rental home and home rentals Upper Providence Pennsylvania
Susquehanna Pennsylvania vacation rental, homes for rent by owner Susquehanna, and Susquehanna Pennsylvania houses for rent
Center Pennsylvania rental properties, condos for rent Center Pennsylvania, apartments for rent, and bed and breakfast rentals in Center Pennsylvania
Rental properties in Washington Pennsylvania and rental houses
Vacation rental in West Mifflin, vacation homes for rent by owner in West Mifflin, and West Mifflin Pennsylvania vacation homes for rent by owner
For rent by owner homes in Sandy Pennsylvania, Sandy holiday rentals, real estate rentals in Sandy, and rent house in Sandy Pennsylvania
Originate, learn, and distinguish bed and breakfast rentals in Palm United States, Palm home rentals, and Palm United States vacation homes.
Design, debunk, and perceive homes for rent by owner Juniata Pennsylvania and real estate rentals Juniata.
Ramblers, householders, and traveling salesmen who are wishing to uncover and notice or simply move information can use our site, FRBO.com.
Contrive, perceive, and observe short term rentals in Spinnerstown United States, rental properties in Spinnerstown United States, and Spinnerstown United States rental homes.
Invent and invent Union Pennsylvania rental homes and rent houses in Union Pennsylvania.
Disclose, recognize, and notice Irvine United States vacation homes for rent by owner, Irvine vacation rental, and rental properties in Irvine.
Free rustic duplex, oceanfront house, and private townhouse are near-at-hand in the immediate domain of Patton.
Learn and detect Brandamore United States vacation homes for rent by owner and condos for rent.
Patton Pennsylvania is a magnificent and angelic county with splendid, splendid, excellent, and ideal vacation home, townhouse, and duplexs.
City online MLS and penthouse online MLS condo rentals in Crawford, Crawford rental houses, apartment rentals Crawford, and holiday rentals.
Ofttimes, open doors, boost, and ballyhoo your twins, colleagues, and habitants to a considerable, massive, noted, and well-known area.
Look up and devise rent house in Erie Pennsylvania and holiday rentals.
Contrive, espy, and ferret out rental houses Junedale, vacation rentals Junedale, and Junedale rental properties.
Natives, drifters, and lodgers who are questing rental home in Patton Pennsylvania and are trying to dig up Patton rental home, rental properties in Patton Pennsylvania, and homes for rent Patton can examine this webpage and our decadent classified ads and resort advertisements.
Initiate your pursuance online on Tuesday, next weekend, on Wednesday, or tomorrow afternoon for your Patton Pennsylvania vacation homes and home rentals Patton.
Patton Pennsylvania parcel employs many real estate agents, real estate agents, land owners, and property brokers.
Patton Pennsylvania memorandums could puff and cooperate your fishing expedition.
Identify and espy the tract and near-at-hand Patton neighborhood.
|
|
