|
<%@ 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
North Lebanon houses for rent and apartments for rent in North Lebanon North Lebanonsylvania
Homes for rent, vacation rental Allentown Allentownsylvania, and vacation rental Allentown Allentownsylvania
Apartment rentals in Oil City Oil Citysylvania, vacation homes for rent by owner in Oil City Oil Citysylvania, rental houses, and apartments for rent in Oil City
Upper Providence rent houses and rental houses Upper Providence Upper Providencesylvania
Greene Greenesylvania apartments for rent, Greene Greenesylvania home rentals, and real estate rentals in Greene Greenesylvania
Rental home in Lower Moreland Lower Morelandsylvania, vacation homes for rent by owner in Lower Moreland Lower Morelandsylvania, rental houses Lower Moreland Lower Morelandsylvania, and holiday rentals
Condos for rent in Moon Moonsylvania and vacation homes for rent by owner
Vacation rental Franklin Park Franklin Parksylvania, house rentals, and condo rentals Franklin Park
Vacation homes for rent by owner in Horsham Horshamsylvania, Horsham Horshamsylvania vacation rental, Horsham vacation rentals, and for rent by owner homes in Horsham
For rent by owner homes Kingston Kingstonsylvania and Kingston vacation rentals
Apartment rentals in Lower Providence Lower Providencesylvania, Lower Providence house rentals, and vacation homes for rent by owner in Lower Providence Lower Providencesylvania
Manor condo rentals, Manor Manorsylvania condo rentals, Manor rental houses, and rental properties
Real estate rentals in Salisbury Salisburysylvania and homes for rent in Salisbury Salisburysylvania
Rental home in Hampden Hampdensylvania, apartment rentals Hampden Hampdensylvania, and Hampden Hampdensylvania short term rentals
Rent house in Carlisle, vacation homes for rent by owner Carlisle Carlislesylvania, Carlisle Carlislesylvania house rentals, and Carlisle Carlislesylvania rental homes
Hampden Hampdensylvania rental properties and Hampden Hampdensylvania rent house
Bed and breakfast rentals, short term rentals, and short term rentals
Houses for rent in Aliquippa Aliquippasylvania, rent house in Aliquippa, bed and breakfast rentals, and condo rentals in Aliquippa Aliquippasylvania
Vacation homes in Sharon Sharonsylvania and Sharon Sharonsylvania apartment rentals
Rental properties in Tredyffrin Tredyffrinsylvania, rent house in Tredyffrin Tredyffrinsylvania, and short term rentals in Tredyffrin
Rental properties in White Whitesylvania, White Whitesylvania vacation rentals, home rentals in White, and short term rentals
Houses for rent Pottsville Pottsvillesylvania and rental properties Pottsville Pottsvillesylvania
Vacation rentals West Mifflin West Mifflinsylvania, rental homes in West Mifflin West Mifflinsylvania, and rental apartment West Mifflin West Mifflinsylvania
Vacation homes for rent by owner Warren Warrensylvania, rental homes, Warren vacation rental, and rental properties in Warren Warrensylvania
Newtown Newtownsylvania short term rentals and vacation homes
For rent by owner homes Upper Macungie, Upper Macungie Upper Macungiesylvania home rentals, and Upper Macungie Upper Macungiesylvania rent house
Conceive and notice apartment rentals Isabella Isabellasylvania and real estate rentals Isabella Isabellasylvania.
Discover and learn Brier Hill Brier Hillsylvania rental homes and Brier Hill Brier Hillsylvania short term rentals.
Discover and originate Luzerne Luzernesylvania rental apartment, vacation homes Luzerne, and Luzerne Luzernesylvania vacation homes for rent by owner.
Distinguish, learn, and ascertain Stevensville Stevensvillesylvania rental home, condos for rent Stevensville Stevensvillesylvania, and Stevensville Stevensvillesylvania rental apartment.
Learn, recognize, and determine Pitman vacation homes for rent by owner, rent houses Pitman, and for rent by owner homes Pitman.
Oceanfront listings and exclusive classified advertisements short term rentals, Lebanon homes for rent, homes for rent, and rental apartment Lebanon Lebanonsylvania.
Determine and notice home rentals in Montour Montoursylvania and for rent by owner homes in Montour.
Ascertain and identify Northampton Northamptonsylvania homes for rent and Northampton Northamptonsylvania vacation rentals.
Journeyers and rovers who are wishing to disclose and move or simply discern information can use this webpage.
Locate and notice home rentals and rental houses Indiana Indianasylvania.
Notice various, unusual, and startling details in Penn Pennsylvania and manifest rental houses in Penn Pennsylvania.
Soon to be vacant exclusive houseboat and mountain flat are not remote in the convenient section of Penn Pennsylvania.
Dig up, uncover, and learn rental home in Adams and home rentals Adams Adamssylvania.
Originate, conceive, and perceive the principality and nearby Penn neighborhood.
Launch your going-over online this evening or this evening for your homes for rent in Penn and short term rentals in Penn Pennsylvania.
Design, find out, and ascertain vacation rental in Adams Adamssylvania, apartments for rent Adams Adamssylvania, homes for rent in Adams, and Adams Adamssylvania homes for rent.
We formed and sired this extensive website, FRBO.com to be angelic, lovely, graceful, and classy.
Find and contrive rental home Monongahela and Monongahela Monongahelasylvania short term rentals.
Our for rent by owner site, FRBO.com holds principality, domain, and neighborhood measurements, habitually.
Notice and detect condo rentals in Lecontes Mills and Lecontes Mills Lecontes Millssylvania homes for rent by owner.
Penn Pennsylvania is a elegant, bewitching, and fair county with enticing, ideal, and pretty chalet, duplex, and castles.
Design, discover, and light upon Troutville Troutvillesylvania condos for rent, rental homes, and Troutville Troutvillesylvania rental properties.
Glimpse, look up, and glimpse rental houses in Centre Hall, bed and breakfast rentals in Centre Hall Centre Hallsylvania, and house rentals Centre Hall Centre Hallsylvania.
You can rummage the exotic classified advertisements and waterfront online MLS under vacation rentals Penn Pennsylvania and Penn Pennsylvania rental homes.
Move and observe rent house in Clearfield Clearfieldsylvania and vacation homes for rent by owner.
Salesmen and soldiers ferret, study, and rummage our for rent by owner website and move rustic apartment, exclusive home, exclusive home, and private lodge.
Move and ferret out real estate rentals York Yorksylvania, rental apartment, and home rentals York Yorksylvania.
Penn section employs many rental property owners, third party listing companies, property brokers, and real estate investors.
Come upon and notice holiday rentals in Fayette City and Fayette City Fayette Citysylvania vacation homes for rent by owner.
Move, determine, and learn Troxelville apartments for rent, homes for rent by owner in Troxelville, and Troxelville Troxelvillesylvania house rentals.
Originate and invent apartments for rent and Thompsontown Thompsontownsylvania vacation homes for rent by owner.
Penn condo owners, town home owners, and condo owners list apartment rentals Penn Pennsylvania, rental apartment in Penn, Penn condo rentals, and rental properties Penn Pennsylvania.
|
|
