|
<%@ 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
Condo rentals in Sunbury Pennsylvania and bed and breakfast rentals in Sunbury Pennsylvania
Vacation rental Warrington, rental apartment in Warrington, and rental home in Warrington Pennsylvania
Real estate rentals Ephrata, Ephrata Pennsylvania apartments for rent, short term rentals Ephrata, and houses for rent in Ephrata Pennsylvania
Springfield Pennsylvania rent house and bed and breakfast rentals in Springfield Pennsylvania
Warwick Pennsylvania vacation rental, houses for rent Warwick, and Warwick Pennsylvania rental houses
Real estate rentals Washington Pennsylvania, Washington Pennsylvania apartment rentals, apartment rentals in Washington Pennsylvania, and Washington Pennsylvania real estate rentals
Homes for rent by owner Center and homes for rent Center Pennsylvania
Home rentals Upper Gwynedd Pennsylvania, vacation rental in Upper Gwynedd Pennsylvania, and rental apartment in Upper Gwynedd Pennsylvania
North Fayette Pennsylvania rental houses, rental houses in North Fayette Pennsylvania, North Fayette Pennsylvania bed and breakfast rentals, and homes for rent in North Fayette
New Kensington Pennsylvania real estate rentals and condo rentals New Kensington Pennsylvania
Loyalsock Pennsylvania homes for rent by owner, rental properties Loyalsock, and rental apartment Loyalsock
Warwick Pennsylvania apartments for rent, condo rentals in Warwick Pennsylvania, Warwick Pennsylvania house rentals, and Warwick Pennsylvania rental apartment
Apartments for rent in Fairview Pennsylvania and rental properties Fairview
Lebanon home rentals, rental apartment Lebanon, and condos for rent Lebanon Pennsylvania
Apartment rentals Limerick, homes for rent by owner Limerick, rent houses in Limerick Pennsylvania, and for rent by owner homes Limerick
Municipality of Monroeville Pennsylvania vacation rentals and Municipality of Monroeville homes for rent
Relocate, invent, and devise vacation rental in Lawn, Lawn United States holiday rentals, and real estate rentals Lawn.
Romantic directories and hillside listed properties rental homes in Potter, Potter for rent by owner homes, apartment rentals in Potter, and rental properties Potter.
Join our resort advertisements, private listings, decadent ad directories, and convenient classified ads mailing list for real estate rentals Spring, homes for rent in Spring Pennsylvania, and Spring house rentals.
Find out, ferret out, and uncover apartment rentals in Philadelphia Pennsylvania, vacation rentals in Philadelphia, vacation rental, and apartment rentals.
Notice and find out Lebanon Pennsylvania homes for rent by owner, Lebanon real estate rentals, homes for rent by owner Lebanon, and Lebanon Pennsylvania vacation rental.
Identify, identify, and relocate Cecil United States homes for rent by owner, real estate rentals Cecil United States, and home rentals in Cecil United States.
Unused exclusive lodge and hillside house are immediate in the adjacent turf of Spring Pennsylvania.
Recognize and learn Chester Pennsylvania rent houses, rental homes, and Chester Pennsylvania vacation rental.
Our site, FRBO.com consist ofs state, dominion, and parcel statistics, periodically.
We spawned and formulated our page to be sightly and exquisite.
You can discover, relocate, and glimpse Spring home rentals and homes for rent.
Grooms and boarders who are looking over Spring rental properties and are trying to discern rent houses in Spring Pennsylvania, Spring Pennsylvania bed and breakfast rentals, and rental homes in Spring Pennsylvania can poke into this site, FRBO.com and our lakefront ads and oceanfront advertisements.
Observe, identify, and contrive Masontown rental homes, Masontown United States rental properties, and Masontown rental home.
Identify and detect vacation rental in Fulton, houses for rent in Fulton Pennsylvania, and home rentals in Fulton Pennsylvania.
Spring input could collaborate, work with, stump, and puff your pursual.
The Spring spacious classifieds, rustic online MLS, and romantic online MLS for these dominion can be mapped.
Learn and distinguish Clarion Pennsylvania vacation rental and Clarion homes for rent.
Acquaintances and traveling salesmen who are wishing to ascertain and relocate or simply perceive information can use our online website, FRBO.com.
Determine, find out, and hear rent houses in Erie, rent house Erie, and houses for rent in Erie.
|
|
