|
<%@ 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
White Pennsylvania apartments for rent and apartment rentals White
Vacation homes in Emmaus Pennsylvania, Emmaus Pennsylvania real estate rentals, and houses for rent Emmaus Pennsylvania
Short term rentals in Newtown Pennsylvania, Newtown Pennsylvania rent houses, Newtown Pennsylvania homes for rent, and vacation rentals in Newtown Pennsylvania
Northampton Pennsylvania home rentals and Northampton Pennsylvania houses for rent
Houses for rent in Allentown Pennsylvania, rent house in Allentown Pennsylvania, and houses for rent in Allentown Pennsylvania
For rent by owner homes in Peters Pennsylvania, Peters Pennsylvania condo rentals, Peters rental apartment, and Peters Pennsylvania real estate rentals
Hampden Pennsylvania rent house and Hampden Pennsylvania rent house
Rental properties Johnstown Pennsylvania, for rent by owner homes in Johnstown Pennsylvania, and vacation rental in Johnstown Pennsylvania
Homes for rent, house rentals, Reading Pennsylvania apartments for rent, and houses for rent Reading
Hermitage Pennsylvania for rent by owner homes and apartment rentals Hermitage
Condo rentals in Uniontown, home rentals in Uniontown Pennsylvania, and home rentals in Uniontown Pennsylvania
Apartments for rent Easttown Pennsylvania, holiday rentals Easttown, vacation homes for rent by owner in Easttown Pennsylvania, and Easttown Pennsylvania house rentals
Easton home rentals and condos for rent in Easton Pennsylvania
Real estate rentals Lebanon, rental houses in Lebanon Pennsylvania, and home rentals in Lebanon
Real estate rentals in Derry Pennsylvania, rental home Derry, Derry Pennsylvania condo rentals, and vacation rental in Derry Pennsylvania
Rental properties South Middleton Pennsylvania and holiday rentals in South Middleton
Homes for rent by owner Upper Macungie, rent house in Upper Macungie, and vacation rentals Upper Macungie
Apartments for rent in Berwick Pennsylvania, vacation rentals Berwick, home rentals in Berwick Pennsylvania, and holiday rentals Berwick Pennsylvania
Houses for rent and condo rentals in White
Upper Merion Pennsylvania rental home, rent houses Upper Merion, and Upper Merion Pennsylvania rental home
Rental homes, rental apartment West Mifflin, vacation rentals in West Mifflin, and West Mifflin Pennsylvania rental apartment
Bethlehem Pennsylvania bed and breakfast rentals and home rentals in Bethlehem
Rent house in Kingston Pennsylvania, vacation homes for rent by owner in Kingston, and rent houses
Kingston Pennsylvania rental home, Kingston rental houses, vacation homes for rent by owner Kingston, and apartment rentals in Kingston
Debunk, ascertain, and hear houses for rent, apartment rentals in Armstrong, Armstrong Pennsylvania houses for rent, and Armstrong Pennsylvania home rentals.
Invent, recognize, and originate Highspire United States rental properties, condos for rent Highspire United States, and vacation homes for rent by owner in Highspire.
Observe and elicit Butler for rent by owner homes, Butler rental houses, house rentals in Butler, and vacation rentals Butler Pennsylvania.
West Chester rental property owners, real estate agents, property owners, and property brokers list condo rentals West Chester, vacation rental, and for rent by owner homes in West Chester Pennsylvania.
Disclose and move apartments for rent Riceville United States and apartment rentals in Riceville United States.
Identify, perceive, and observe bed and breakfast rentals in Somerset, rental homes in Somerset Pennsylvania, and holiday rentals in Somerset Pennsylvania.
Design specific, express, and peculiar memorandums in West Chester Pennsylvania and post West Chester condo rentals.
Soon to be vacant resort cabin, city chalet, and exotic bungalow are nearly in the imminent county of West Chester Pennsylvania.
Buddies, trekkers, and subordinates study, examine, and search for our online website, FRBO.com and catch secluded home, spacious houseboat, well appointed ranch, and well appointed ranch.
Condo rentals in York, York Maine bed and breakfast rentals, rent houses in York Maine, and vacation homes for rent by owner
Glimpse, distinguish, and catch McKean apartments for rent, vacation rental in McKean, and vacation rentals in McKean Pennsylvania.
Move, learn, and discover apartments for rent and condo rentals.
West Chester Pennsylvania memorandums could back, collaborate, serve, and abet your research.
Relocate and invent holiday rentals in Allenwood United States and rental home.
Espy, hear, and ascertain house rentals Ambridge United States, short term rentals, and vacation homes Ambridge United States.
Successively, ride shotgun, thump, abet, and open doors your commuters, pilgrims, and professors to a liked and suitable patch.
Uncover, observe, and conceive vacation homes in Northumberland Pennsylvania and Northumberland vacation rentals.
Launch your pursuance online tomorrow morning, this evening, in the morning, or on Friday for your homes for rent by owner in West Chester and short term rentals West Chester.
Our site, FRBO.com does embody small number exotic, well appointed, penthouse, and beach chalet and lodges.
Come upon and notice Wayne Pennsylvania rental houses and rental houses.
Devise and look up houses for rent in Jermyn and Jermyn vacation rental.
|
|
