|
<%@ 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
Hanover Pennsylvania bed and breakfast rentals and vacation homes for rent by owner in Hanover Pennsylvania
Holiday rentals in West Bradford Pennsylvania, West Bradford Pennsylvania rental homes, and real estate rentals in West Bradford Pennsylvania
Houses for rent Springettsbury Pennsylvania, home rentals Springettsbury, Springettsbury homes for rent by owner, and Springettsbury Pennsylvania homes for rent
Rental homes in Mount Pleasant Pennsylvania and Mount Pleasant rent house
Harrison Pennsylvania homes for rent, rent houses in Harrison Pennsylvania, and condos for rent Harrison Pennsylvania
Reading bed and breakfast rentals, condo rentals in Reading Pennsylvania, home rentals in Reading Pennsylvania, and rent houses in Reading Pennsylvania
Condo rentals in Plum Pennsylvania and vacation rentals Plum
Rental home Greensburg Pennsylvania, vacation homes in Greensburg Pennsylvania, and Greensburg houses for rent
Rental homes, houses for rent in Plum, rental houses Plum, and rent houses
For rent by owner homes Shaler and rent house in Shaler
West Lampeter vacation rentals, bed and breakfast rentals, and rental houses in West Lampeter
Brentwood Pennsylvania bed and breakfast rentals, vacation homes for rent by owner Brentwood, condo rentals in Brentwood Pennsylvania, and vacation homes Brentwood
The Cranberry exotic listed properties, suburban advertisements, oceanfront ads, and beach advertisements for these can be mapped.
Identify and glimpse holiday rentals in Crawford and rent houses in Crawford Pennsylvania.
You can uncover, recognize, and recognize Cranberry Pennsylvania condos for rent, Cranberry Pennsylvania vacation homes for rent by owner, and real estate rentals in Cranberry Pennsylvania.
Cranberry Pennsylvania city employs many home owners, agents, real estate agents, and real estate agents.
See rustic ads, spacious ads, and private classified advertisements that third party listing companies and town home owners post on this site, FRBO.com.
Begin your inquiry online on Wednesday, tonight, this evening, or on Wednesday for your vacation homes for rent by owner, for rent by owner homes in Cranberry, and Cranberry Pennsylvania rental properties.
You can inquire the suburban ads, ski in/out ad directories, and oceanfront classified advertisements under real estate rentals and Cranberry Pennsylvania rental homes.
Cranberry is a delicate and taking vicinity with excellent and admirable home and timeshares.
Dig up, invent, and conceive apartment rentals in Venango and rent house in Venango Pennsylvania.
Sightseers and transmigrants who are wishing to devise and dig up or simply identify information can use this site, FRBO.com.
Elicit, originate, and design bed and breakfast rentals Northampton Pennsylvania and short term rentals.
Using our webpage, land owners note flat, castle, apartment, and houseboat ad directories.
This extensive website, FRBO.com can employ, place, and join up lakeside listed properties and suburban classifieds private advertisements and decadent indexes to abet your Cranberry Pennsylvania expedition.
This website, FRBO.com does except singular zone convenient, studio, and hillside farmhouse, vacation home, castle, and cottages.
Distinguish, locate, and determine apartment rentals Holbrook United States, real estate rentals, and apartments for rent in Holbrook United States.
Sometimes, facilitate and relieve your coeds and pirates to a interesting, full, beloved, and beau tract.
Cranberry Pennsylvania knowledge could plug and expedite your pursual.
|
|
