|
<%@ 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
South Park Pennsylvania vacation homes and homes for rent by owner South Park
Condo rentals, Windsor Pennsylvania rental properties, and Windsor Pennsylvania home rentals
Real estate rentals Swatara Pennsylvania, Swatara house rentals, vacation homes in Swatara Pennsylvania, and Swatara Pennsylvania condo rentals
Condos for rent in Chestnuthill and vacation homes for rent by owner in Chestnuthill Pennsylvania
Homes for rent in Logan, Logan bed and breakfast rentals, and homes for rent in Logan Pennsylvania
Homes for rent in New Castle Pennsylvania, home rentals New Castle Pennsylvania, vacation homes for rent by owner in New Castle, and homes for rent in New Castle Pennsylvania
Vacation rental in Robinson and Robinson vacation rentals
Rental homes Ferguson Pennsylvania, Ferguson rent houses, and apartments for rent in Ferguson Pennsylvania
Apartment rentals in Towamencin, house rentals in Towamencin Pennsylvania, Towamencin Pennsylvania rental properties, and condos for rent in Towamencin
Pottstown apartments for rent and homes for rent by owner Pottstown Pennsylvania
Locate, recognize, and find out rent house Woxall, Woxall United States rental homes, and Woxall United States apartment rentals.
Learn and conceive condo rentals Potter Pennsylvania, rental homes in Potter Pennsylvania, for rent by owner homes in Potter, and Potter Pennsylvania rental properties.
Ascertain, contrive, and espy real estate rentals in Dewart, for rent by owner homes, and homes for rent by owner in Dewart.
Discover and come upon rent house in Monessen and Monessen short term rentals.
Learn and devise for rent by owner homes in Erie Pennsylvania and Erie Pennsylvania rent houses.
We performed and conceived this extensive website, FRBO.com to be taking, magnificent, splendid, and dazzling.
The Lancaster Pennsylvania classified ads registered and charted on this site, FRBO.com involve lakeside hacienda, log townhouse, lakefront hacienda, and secluded houseboat.
Lancaster Pennsylvania is a ravishing, nice, and angelic locality with pretty, fine, and comely flat, bungalow, condominium, and chalets.
This extensive website, FRBO.com can secure, serve, and oblige decadent ad directories, beachfront lists of marked properties, loft listed properties, and exotic lists of marked properties resort classified advertisements and lakefront listings to thump your Lancaster Pennsylvania saunter.
Ferret out, explore, and relocate Bradford Pennsylvania real estate rentals, Bradford for rent by owner homes, Bradford Pennsylvania holiday rentals, and home rentals Bradford Pennsylvania.
Hear, recognize, and devise for rent by owner homes in Mifflin and real estate rentals in Mifflin Pennsylvania.
Our online website, FRBO.com does subsume various field convenient and exclusive cabin, townhouse, cabin, and timeshares.
Identify and disclose Porters Sideling vacation rentals and Porters Sideling United States rental homes.
|
|
