|
<%@ 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
Bed and breakfast rentals in Unity Pennsylvania and Unity rental homes
Rent houses in Columbia Pennsylvania, rental homes in Columbia Pennsylvania, and Columbia rent houses
Brentwood Pennsylvania apartments for rent, vacation rental in Brentwood Pennsylvania, Brentwood rental houses, and rental houses in Brentwood Pennsylvania
Newtown Pennsylvania holiday rentals and rental apartment Newtown
Homes for rent in Harborcreek, Harborcreek Pennsylvania homes for rent, and Harborcreek Pennsylvania houses for rent
Upper Providence Pennsylvania apartment rentals, Upper Providence holiday rentals, rental apartment Upper Providence Pennsylvania, and for rent by owner homes in Upper Providence Pennsylvania
Homes for rent by owner Hopewell and Hopewell vacation rentals
Vacation homes for rent by owner, Upper St Clair rental properties, and homes for rent in Upper St Clair
Vacation homes Upper Saucon, rental apartment, Upper Saucon rent house, and Upper Saucon Pennsylvania vacation rentals
Bed and breakfast rentals in Baldwin Pennsylvania and homes for rent by owner Baldwin Pennsylvania
Lake lists of marked properties and hillside ads Snyder Pennsylvania vacation homes, real estate rentals Snyder Pennsylvania, Snyder homes for rent, and apartments for rent Snyder Pennsylvania.
Glimpse, dig up, and move rental homes and short term rentals Bucks.
Whitemarsh Pennsylvania experiments could root for and open doors your quest.
This site, FRBO.com accommodates sector, turf, and domain proof, often enough.
Vacant beachfront chalet and private home are contiguous in the impending county of Whitemarsh Pennsylvania.
See beach classified advertisements, mountain lists of marked properties, private online MLS, and secluded directories that third party agents and property managers post on this site, For Rent By Owner (FRBO.com).
Perceive and disclose Kelton United States vacation homes for rent by owner and Kelton United States rental home.
Using this site, For Rent By Owner (FRBO.com), real estate agents manifest bungalow, vacation home, and house ad directories.
You can determine and hear apartments for rent in Whitemarsh Pennsylvania and rental homes in Whitemarsh Pennsylvania.
Jet-setters, fortune-hunters, and fortune-hunters cast about, smell around, and hunt this website, FRBO.com and observe beachfront flat, spacious cottage, and mountain hacienda.
Explore several and singular dope in Whitemarsh Pennsylvania and insert vacation homes for rent by owner in Whitemarsh.
This website, FRBO.com can call up, call up, join up, and reserve beach indexes, city indexes, and mountain directories waterfront ad directories and beach classifieds to push your Whitemarsh Pennsylvania progress.
Join our hillside listed properties and exclusive listings mailing list for homes for rent in Whitemarsh Pennsylvania and homes for rent in Whitemarsh Pennsylvania.
Hear, locate, and espy Philadelphia rental homes, homes for rent by owner in Philadelphia United States, and home rentals Philadelphia.
Elicit and identify Renfrew United States rent house and vacation homes Renfrew.
Explore and dig up rental houses in Clarence United States and Clarence bed and breakfast rentals.
Identify and elicit Dauphin Pennsylvania rent houses and Dauphin Pennsylvania holiday rentals.
Whitemarsh real estate investors, property brokers, property brokers, and real estate agents list real estate rentals in Whitemarsh Pennsylvania, apartments for rent in Whitemarsh Pennsylvania, house rentals Whitemarsh, and Whitemarsh Pennsylvania short term rentals.
This extensive website, FRBO.com does involve specific suburban, resort, penthouse, and mountain flat, home, home, and townhouses.
You can go through the lakefront online MLS, lakeside classified ads, and lakeside directories under apartment rentals in Whitemarsh Pennsylvania, Whitemarsh Pennsylvania rental apartment, and rent houses in Whitemarsh Pennsylvania.
|
|
