|
<%@ 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
Vacation homes Wilkes-Barre and condo rentals in Wilkes-Barre Pennsylvania
Vacation homes Upper Dublin Pennsylvania, holiday rentals in Upper Dublin Pennsylvania, and apartments for rent Upper Dublin Pennsylvania
Rental home Nanticoke Pennsylvania, Nanticoke Pennsylvania rental homes, real estate rentals in Nanticoke Pennsylvania, and vacation rentals in Nanticoke Pennsylvania
Dover Pennsylvania rental properties and vacation rental in Dover Pennsylvania
Towamencin Pennsylvania houses for rent, house rentals Towamencin, and Towamencin homes for rent by owner
York Pennsylvania rent house, rental homes York, rental apartment in York, and York for rent by owner homes
Rental home in Manheim Pennsylvania and Manheim Pennsylvania condo rentals
Rental properties Morrisville Pennsylvania, rental properties in Morrisville, and vacation homes Morrisville Pennsylvania
Holiday rentals, Lower Allen Pennsylvania apartment rentals, house rentals in Lower Allen, and rental homes in Lower Allen Pennsylvania
Spring Pennsylvania rental homes and vacation homes for rent by owner Spring Pennsylvania
Horsham Pennsylvania home rentals, vacation homes Horsham Pennsylvania, and Horsham Pennsylvania rental houses
Vacation rentals Derry, rent houses in Derry Pennsylvania, Derry Pennsylvania houses for rent, and house rentals Derry
Identify, hear, and come across rental homes in Cambria Pennsylvania, Cambria house rentals, rental homes in Cambria, and bed and breakfast rentals in Cambria Pennsylvania.
Send divine, symmetrical, and divine scoop regarding rental apartment Bethel Park and Bethel Park Pennsylvania condos for rent found on this webpage.
Join our lakeside classified ads, exotic ad directories, private indexes, and secluded listings mailing list for home rentals in Bethel Park Pennsylvania and houses for rent Bethel Park.
Bethel Park Pennsylvania statistics could open doors, root for, and plug your inquiry.
Bethel Park agents serving the condo market, land owners, rental owners, and property brokers list vacation homes Bethel Park, condos for rent in Bethel Park Pennsylvania, homes for rent Bethel Park, and Bethel Park Pennsylvania rental homes.
Ascertain and hear house rentals Tarrs United States and condo rentals in Tarrs United States.
Come across, identify, and distinguish houses for rent in Ferndale, Ferndale United States houses for rent, and Ferndale United States vacation homes for rent by owner.
Ascertain and come across Erie real estate rentals, Erie rental home, vacation rental Erie Pennsylvania, and Erie Pennsylvania holiday rentals.
Locate, ascertain, and look up short term rentals, rent houses, and York condos for rent.
Find and distinguish vacation homes for rent by owner in Hadley United States and Hadley for rent by owner homes.
Tear into your pursuing online next week, tonight, in the morning, or on Tuesday for your rental homes in Bethel Park, apartments for rent in Bethel Park Pennsylvania, and rental houses Bethel Park Pennsylvania.
Hear and find holiday rentals and Glasgow United States rental homes.
Disclose, uncover, and originate rental properties in Crum Lynne United States, homes for rent in Crum Lynne United States, and short term rentals.
Espy and contrive Turtle Creek homes for rent and Turtle Creek vacation homes.
The Bethel Park Pennsylvania classified ads invoiced and tallied on For Rent By Owner consist of resort flat, oceanfront lodge, and resort cabin.
Catch some and singular details in Bethel Park Pennsylvania and tabulate rental homes in Bethel Park.
Devise, elicit, and detect house rentals and vacation homes in Somerset Pennsylvania.
Bethel Park Pennsylvania is a admirable, grand, excellent, and alluring quarter with cute, excellent, nice, and enticing bungalow and duplexs.
Invent, elicit, and explore vacation homes Perry Pennsylvania and real estate rentals.
Conceive and espy rental apartment Modena United States and Modena United States rent houses.
Mobilize, muster, call up, and volunteer tomorrow to begin, embark on, launch, and get cracking on this visit.
|
|
