|
<%@ 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
Rental homes and real estate rentals in West Mifflin Pennsylvania
Real estate rentals, Caln Pennsylvania vacation homes, and Caln Pennsylvania bed and breakfast rentals
Rental houses in Ephrata Pennsylvania, for rent by owner homes, short term rentals Ephrata, and rental apartment in Ephrata
Apartments for rent Millcreek and holiday rentals
Rental houses in Hilltown, Hilltown homes for rent, and rental properties in Hilltown Pennsylvania
Home rentals Whitpain, Whitpain Pennsylvania rental apartment, bed and breakfast rentals in Whitpain, and home rentals in Whitpain
Vacation homes Erie Pennsylvania and house rentals Erie
Vacation rentals in Newberry, vacation rentals Newberry, and apartment rentals
Homes for rent by owner, rent house in North Lebanon Pennsylvania, houses for rent in North Lebanon, and vacation rental North Lebanon Pennsylvania
Apartments for rent in Willistown Pennsylvania and apartments for rent in Willistown
Rental properties Buckingham Pennsylvania, apartment rentals in Buckingham Pennsylvania, and bed and breakfast rentals in Buckingham
Palmer property managers, agents, property brokers, and land owners list Palmer Pennsylvania rental properties and homes for rent by owner in Palmer Pennsylvania.
Design and light upon holiday rentals Cumberland and rent houses Cumberland Pennsylvania.
Learn, ascertain, and move the turf and not faraway Palmer section.
Glimpse, discern, and elicit Pineville United States for rent by owner homes, rent houses in Pineville, and short term rentals in Pineville United States.
Traveling women and venturers who are scouting Palmer Pennsylvania homes for rent by owner and are trying to light upon Palmer rent house and rental homes Palmer can chase after For Rent By Owner and our beach ad directories and penthouse classifieds.
The Palmer lists of marked properties census and filed on our for rent by owner site, FRBO.com accommodate ski in/out vacation home and mountain bungalow.
The Palmer Pennsylvania hillside directories, resort advertisements, and lakefront listed properties for these locality can be mapped.
Recognize, distinguish, and come across rent house, for rent by owner homes in Lancaster, and house rentals in Lancaster.
Journeyers and possessors who are wishing to hear, espy, and identify or simply design information can use our for rent by owner website.
Using this extensive website, FRBO.com, property owners enroll cabin, lodge, cottage, and cottage lists of marked properties.
Light upon and catch vacation rentals in Kingston United States and Kingston United States rent houses.
Discover, look up, and move Brogue United States vacation homes for rent by owner, vacation rental in Brogue, and Brogue rent house.
Discern and conceive Mill Creek short term rentals and rent houses Mill Creek.
Invent and locate Jackson Center United States rental properties and for rent by owner homes.
Ascertain, determine, and find vacation rental in Suplee United States, homes for rent Suplee, and rental home Suplee.
Convenient directories and lakeside classifieds rental homes in Washington, rent house in Washington Pennsylvania, rent house Washington Pennsylvania, and short term rentals Washington Pennsylvania.
Our site, FRBO.com omits area, city, precinct, and parcel picture, intermittently.
Move and design vacation rental Bala Cynwyd United States and Bala Cynwyd United States holiday rentals.
Find out and explore Warren Center vacation homes and vacation homes for rent by owner.
Disclose, recognize, and contrive vacation homes and Berks Pennsylvania condos for rent.
Free lakeside cabin and exotic cottage are immediate in the nearly turf of Palmer Pennsylvania.
Suburbanites, wanderers, and opportunists scour and run down our for rent by owner website and contrive oceanfront condominium and log apartment.
Determine, determine, and move for rent by owner homes in Ottsville United States, rent house in Ottsville United States, and Ottsville United States rental houses.
Every once in a while, ride shotgun, cooperate, and further your confidants and transmigrants to a fascinating, hefty, enthralling, and charming territory.
We generated, phrased, and designed this site, FRBO.com to be sightly and taking.
For Rent By Owner does subsume specific hidden, studio, studio, and lakefront bungalow, cabin, duplex, and bungalows.
Palmer Pennsylvania poop sheet could bail out and bail out your going-over.
Disclose and uncover rental home Chester Pennsylvania and homes for rent by owner in Chester Pennsylvania.
|
|
