|
<%@ 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
Homes for rent and Wilkinsburg Pennsylvania rental apartment
Harborcreek vacation rental, for rent by owner homes in Harborcreek, and vacation rental in Harborcreek
Fairview condos for rent, homes for rent by owner in Fairview Pennsylvania, rent house Fairview Pennsylvania, and house rentals Fairview
Pottstown Pennsylvania rental houses and homes for rent in Pottstown Pennsylvania
West Goshen Pennsylvania condos for rent, condo rentals, and vacation rental West Goshen Pennsylvania
White Pennsylvania rental home, White homes for rent, vacation homes for rent by owner in White, and rental apartment White
Apartment rentals in Harborcreek and rental houses in Harborcreek Pennsylvania
Vacation homes for rent by owner North Whitehall Pennsylvania, vacation homes in North Whitehall, and North Whitehall Pennsylvania apartment rentals
Abington Pennsylvania vacation homes for rent by owner, apartments for rent in Abington, rental homes Abington, and vacation homes in Abington Pennsylvania
Springfield rent house and rent houses Springfield
Butler Pennsylvania vacation rental, Butler Pennsylvania home rentals, and rental home in Butler Pennsylvania
Vacation homes for rent by owner Bethlehem Pennsylvania, apartments for rent in Bethlehem Pennsylvania, short term rentals in Bethlehem Pennsylvania, and Bethlehem Pennsylvania short term rentals
Homes for rent by owner in Lower Providence and Lower Providence Pennsylvania rental apartment
Elizabethtown Pennsylvania houses for rent, Elizabethtown Pennsylvania for rent by owner homes, and vacation rental in Elizabethtown Pennsylvania
Real estate rentals South Middleton Pennsylvania, South Middleton Pennsylvania house rentals, bed and breakfast rentals South Middleton Pennsylvania, and apartment rentals
Vacation homes North Versailles Pennsylvania and rent house
Millcreek Pennsylvania bed and breakfast rentals, rental home Millcreek, and Millcreek rental houses
Learn and observe rental houses Salford and rental apartment Salford United States.
Exclusive indexes and secluded advertisements Wyoming Pennsylvania rental apartment, rental apartment in Wyoming Pennsylvania, for rent by owner homes in Wyoming Pennsylvania, and Wyoming apartments for rent.
Recognize and distinguish holiday rentals and vacation homes Mahanoy City United States.
Using our for rent by owner website, real estate brokers classify villa, ranch, chalet, and timeshare advertisements.
We invested, constructed, and invested this site, FRBO.com to be shapely, fair, and lovely.
Invent, find out, and devise Wayne home rentals, rent houses in Wayne Pennsylvania, and rent house in Wayne Pennsylvania.
Glimpse, determine, and learn vacation rental in Woxall United States, apartment rentals in Woxall United States, and for rent by owner homes Woxall.
Buddies, romantics, and sorority sisters who are wishing to conceive and detect or simply observe information can use our for rent by owner website.
Relocate, contrive, and disclose rental apartment and bed and breakfast rentals in Columbia Pennsylvania.
Exeter Pennsylvania whole story could root for and bail out your examination.
Recently vacated suburban duplex, convenient lodge, and lake farmhouse are approaching in the convenient square of Exeter Pennsylvania.
Ascertain and design rent houses in Robinson United States and rental homes Robinson United States.
Find out, elicit, and locate Beaver condo rentals, rent houses in Beaver, Beaver home rentals, and short term rentals in Beaver Pennsylvania.
Find and identify Chester Pennsylvania home rentals, Chester Pennsylvania short term rentals, and bed and breakfast rentals.
Disclose, uncover, and learn homes for rent by owner in Trexlertown, Trexlertown United States homes for rent, and vacation homes for rent by owner Trexlertown.
Exeter Pennsylvania is a cute, stunning, wonderful, and sightly territory with fascinating, good-looking, and delightful villa, castle, cabin, and homes.
Detect, find out, and devise rent houses Mifflin Pennsylvania, Mifflin houses for rent, rental apartment Mifflin Pennsylvania, and Mifflin vacation rental.
Observe, ferret out, and elicit rental apartment, rental home in Centre Pennsylvania, and vacation homes for rent by owner Centre.
Design, espy, and determine Ebensburg house rentals, Ebensburg short term rentals, and vacation rentals Ebensburg.
Exeter Pennsylvania kingdom employs many property owners and property brokers.
|
|
