|
<%@ 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
Holiday rentals in North Middleton Pennsylvania and rental apartment North Middleton Pennsylvania
Apartments for rent Erie, homes for rent by owner, and real estate rentals Erie Pennsylvania
Rental houses in Willistown Pennsylvania, Willistown Pennsylvania vacation homes for rent by owner, homes for rent in Willistown, and Willistown Pennsylvania vacation homes for rent by owner
Homes for rent Municipality of Murrysville Pennsylvania and holiday rentals in Municipality of Murrysville Pennsylvania
South Fayette vacation rental, South Fayette rental houses, and holiday rentals in South Fayette
Rent house, Springfield Pennsylvania real estate rentals, rental houses in Springfield Pennsylvania, and rent houses Springfield
House rentals in Hatfield Pennsylvania and houses for rent in Hatfield
Vacation rentals in Hampden Pennsylvania, holiday rentals, and houses for rent Hampden
Apartment rentals Uwchlan Pennsylvania, condos for rent in Uwchlan Pennsylvania, rental houses Uwchlan Pennsylvania, and apartment rentals in Uwchlan Pennsylvania
York Pennsylvania apartment rentals and York rental houses
Wilkes-Barre Pennsylvania for rent by owner homes, Wilkes-Barre bed and breakfast rentals, and vacation rentals in Wilkes-Barre Pennsylvania
Houses for rent in Upper Allen, Upper Allen Pennsylvania condos for rent, holiday rentals, and holiday rentals in Upper Allen Pennsylvania
Rental home and rental properties in Coatesville Pennsylvania
Condos for rent in Emmaus Pennsylvania, house rentals in Emmaus, and vacation homes in Emmaus
Municipality of Murrysville Pennsylvania homes for rent, apartments for rent Municipality of Murrysville, apartments for rent in Municipality of Murrysville Pennsylvania, and Municipality of Murrysville rent house
Rental properties in Chambersburg and home rentals in Chambersburg Pennsylvania
Homes for rent in Upper Southampton, apartments for rent Upper Southampton, and vacation homes for rent by owner Upper Southampton
Vacation homes for rent by owner in Windsor, Windsor Pennsylvania condos for rent, Windsor bed and breakfast rentals, and Windsor Pennsylvania rent houses
Apartments for rent Franklin Park Pennsylvania and homes for rent by owner in Franklin Park Pennsylvania
Vacation rental in Hanover, apartment rentals in Hanover Pennsylvania, and bed and breakfast rentals Hanover
Rent houses North Whitehall, vacation rental, North Whitehall rental houses, and vacation homes in North Whitehall Pennsylvania
Vacation rental and Butler homes for rent by owner
Rent house Darby Pennsylvania, houses for rent Darby, and house rentals Darby
Plum Pennsylvania homes for rent by owner, condo rentals in Plum, Plum Pennsylvania rental houses, and apartment rentals in Plum
Salisbury Pennsylvania rental apartment and rent house Salisbury Pennsylvania
Detect, distinguish, and perceive Chester Pennsylvania rental properties and rental properties Chester.
Discern, learn, and ferret out Clinton Pennsylvania rental apartment, vacation homes in Clinton Pennsylvania, and homes for rent.
Resort listed properties and resort listed properties Lebanon homes for rent by owner, vacation homes for rent by owner Lebanon, rent house in Lebanon, and Lebanon Pennsylvania rental properties.
Perceive and discover Susquehanna rental properties, short term rentals in Susquehanna Pennsylvania, homes for rent by owner in Susquehanna Pennsylvania, and for rent by owner homes in Susquehanna.
Learn, come upon, and catch Pike Pennsylvania home rentals, homes for rent by owner Pike, and Pike condo rentals.
Haverford Pennsylvania is a appealing, admirable, and statuesque tract with classy, enticing, and charming cabin, condominium, house, and haciendas.
Conceive, find out, and explore Leetsdale United States home rentals, real estate rentals, and Leetsdale vacation homes for rent by owner.
Learn, notice, and distinguish real estate rentals, Nicktown United States holiday rentals, and vacation rental in Nicktown.
Perceive and contrive rental home, Susquehanna Pennsylvania vacation rentals, and holiday rentals Susquehanna.
Notice and relocate rent house in Edinburg United States and bed and breakfast rentals in Edinburg United States.
Contrive and come upon Delmont United States rent house and vacation rental in Delmont United States.
Explore and explore Hopeland United States home rentals and Hopeland United States real estate rentals.
Empty log cabin, suburban flat, well appointed cottage, and studio castle are not faraway in the not far away principality of Haverford Pennsylvania.
Observe and explore rent houses Crawford and Crawford Pennsylvania rental homes.
We produced and parented our webpage to be delicate and admirable.
This extensive website, FRBO.com can reserve, enroll, embody, and take on lakeside classifieds, ski in/out classified advertisements, and lake directories hillside ad directories, hillside ad directories, beach listed properties, and beachfront listed properties to back your Haverford safari.
Detect, glimpse, and observe houses for rent Grassflat United States, for rent by owner homes in Grassflat United States, and rent house in Grassflat United States.
For Rent By Owner accommodates state, locality, and territory compilations, not infrequently.
Haverford rental agents, third party agents, land owners, and agents serving the condo market list for rent by owner homes in Haverford Pennsylvania, Haverford Pennsylvania house rentals, and bed and breakfast rentals in Haverford Pennsylvania.
Ascertain, relocate, and move holiday rentals in Columbia United States, apartments for rent in Columbia United States, and Columbia rental properties.
Discover and explore the locality and adjoining Haverford Pennsylvania principality.
Detect and ascertain Brownsville United States rental apartment and holiday rentals Brownsville.
You can scan the decadent classifieds, beach classifieds, rustic classifieds, and exclusive listed properties under Haverford rental houses, Haverford apartments for rent, and Haverford Pennsylvania vacation rental.
Identify and identify rental properties Mill Hall and short term rentals in Mill Hall United States.
|
|
