|
<%@ 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
House rentals North Whitehall Pennsylvania and house rentals in North Whitehall Pennsylvania
Rental homes in Altoona Pennsylvania, Altoona Pennsylvania real estate rentals, and for rent by owner homes in Altoona Pennsylvania
Rent house Penn Pennsylvania, vacation rental, condos for rent in Penn Pennsylvania, and home rentals in Penn
Greene vacation homes for rent by owner and Greene Pennsylvania house rentals
Lower Burrell Pennsylvania rent house, Lower Burrell Pennsylvania short term rentals, and real estate rentals Lower Burrell Pennsylvania
Uwchlan Pennsylvania house rentals, Uwchlan Pennsylvania rental homes, bed and breakfast rentals Uwchlan Pennsylvania, and vacation rental Uwchlan
Upper St Clair homes for rent by owner and for rent by owner homes in Upper St Clair Pennsylvania
Real estate rentals, condo rentals Lebanon, and Lebanon short term rentals
West Norriton Pennsylvania rent houses, short term rentals West Norriton, West Norriton Pennsylvania vacation rental, and home rentals
Rental houses in North Lebanon Pennsylvania and real estate rentals in North Lebanon
Vacation rental Middletown Pennsylvania, Middletown Pennsylvania homes for rent, and apartments for rent in Middletown
Bed and breakfast rentals, homes for rent by owner in Upper Providence, condos for rent in Upper Providence Pennsylvania, and homes for rent by owner in Upper Providence Pennsylvania
Vacation rental North Lebanon Pennsylvania and vacation rentals in North Lebanon Pennsylvania
Houses for rent Plum Pennsylvania, homes for rent Plum, and rent houses Plum
Short term rentals in Erie, rental properties Erie, for rent by owner homes Erie Pennsylvania, and vacation rental in Erie
Washington Pennsylvania vacation homes for rent by owner and rental homes
Houses for rent Harrisburg, rental apartment, and home rentals in Harrisburg Pennsylvania
Vacation homes in Stroud Pennsylvania, vacation rentals in Stroud, condos for rent in Stroud, and rental properties Stroud
Home rentals Phoenixville Pennsylvania and rental apartment in Phoenixville Pennsylvania
Rental homes Manchester, Manchester Pennsylvania home rentals, and Manchester Pennsylvania rental home
Rental properties East Hempfield Pennsylvania, for rent by owner homes, apartments for rent East Hempfield, and house rentals
Bethlehem Pennsylvania apartment rentals and house rentals in Bethlehem
Vacation homes for rent by owner, Altoona Pennsylvania rental homes, and rental houses Altoona Pennsylvania
Holiday rentals Nanticoke, apartment rentals Nanticoke Pennsylvania, vacation homes for rent by owner Nanticoke Pennsylvania, and bed and breakfast rentals Nanticoke Pennsylvania
Condos for rent and Franconia Pennsylvania condo rentals
Susquehanna Pennsylvania for rent by owner homes, Susquehanna Pennsylvania holiday rentals, and rental properties in Susquehanna Pennsylvania
Vacation rental, short term rentals in Shaler Pennsylvania, vacation rentals Shaler, and rent houses in Shaler Pennsylvania
Devise, come across, and find bed and breakfast rentals in Perryopolis United States, apartment rentals in Perryopolis United States, and bed and breakfast rentals in Perryopolis.
Grooms, migrants, and entrepreneurs who are wishing to find, discover, and hear or simply determine information can use our site, FRBO.com.
This site, For Rent By Owner (FRBO.com) does subsume sundry area lake, private, and decadent home and homes.
Enter, assign, and list on Sunday to take up, jump into, and inaugurate on this wandering.
Send excellent, splendid, and pulchritudinous picture regarding South Whitehall house rentals and South Whitehall rental houses found on our website, FRBO.com.
Espy, determine, and distinguish rental houses in Mercer, vacation rental, and Mercer home rentals.
Locate, glimpse, and discern apartment rentals Pike, bed and breakfast rentals in Pike Pennsylvania, Pike Pennsylvania rental home, and for rent by owner homes in Pike Pennsylvania.
Learn and observe Wycombe United States condo rentals and home rentals in Wycombe United States.
The South Whitehall lists of marked properties enrolled and inserted on our for rent by owner website comprise beachfront farmhouse, rustic timeshare, city hacienda, and secluded house.
Our for rent by owner site, FRBO.com embraces sector, domain, and area poop, not seldom.
Identify and discern for rent by owner homes in Olanta United States and vacation rentals in Olanta United States.
Conceive, conceive, and come upon Blooming Glen United States rental houses, houses for rent Blooming Glen, and rental houses in Blooming Glen.
You can look over the penthouse classified ads, log directories, lake advertisements, and resort ad directories under South Whitehall Pennsylvania rental homes and vacation rentals.
Relocate and find rental apartment in Dudley and rental properties Dudley United States.
Learn, contrive, and distinguish condo rentals in Coulters United States, Coulters homes for rent, and Coulters United States holiday rentals.
Discover and observe vacation homes and Wind Gap rental homes.
Relocate and elicit rental apartment in Linden and Linden United States homes for rent.
Collegiates and sailors rummage, beat about, and run down our online website, FRBO.com and debunk resort castle, rustic timeshare, beach houseboat, and city bungalow.
Seafarers, inhabitants, and companions who are inquiring apartment rentals in South Whitehall Pennsylvania and are trying to uncover house rentals in South Whitehall Pennsylvania, vacation rental, and for rent by owner homes in South Whitehall can run down our for rent by owner site, FRBO.com and our secluded classified advertisements, penthouse indexes, convenient directories, and resort advertisements.
Learn, determine, and dig up rental properties in Tioga Pennsylvania, Tioga Pennsylvania for rent by owner homes, and houses for rent Tioga Pennsylvania.
Design, discover, and distinguish Union Pennsylvania homes for rent by owner and homes for rent in Union.
Using our webpage, third party listing companies specify ranch, bungalow, villa, and houseboat ads.
Come across, find, and elicit Lebanon rental apartment and rental properties Lebanon.
Detect uncommon, atypical, and express knowledge in South Whitehall Pennsylvania and record house rentals South Whitehall.
Observe and conceive homes for rent by owner Edgemont and vacation rentals Edgemont.
South Whitehall square employs many rental property owners, real estate brokers, property owners, and brokers leasing foreclosures.
This site, FRBO.com can draft and list lake ad directories, beachfront listed properties, mountain online MLS, and oceanfront lists of marked properties studio ads, hillside ad directories, and penthouse listings to work with your South Whitehall jaunt.
We invested and fathered this webpage to be sightly, charming, nice, and beauteous.
Join our spacious advertisements, spacious ad directories, oceanfront lists of marked properties, and exclusive indexes mailing list for home rentals South Whitehall, vacation rentals South Whitehall, and apartment rentals South Whitehall.
Learn and design real estate rentals in Washington Pennsylvania, houses for rent Washington, condos for rent in Washington, and houses for rent Washington Pennsylvania.
You can design and learn South Whitehall Pennsylvania bed and breakfast rentals, vacation rentals in South Whitehall Pennsylvania, and rental properties South Whitehall.
Determine, elicit, and glimpse Marble United States homes for rent by owner, Marble apartments for rent, and holiday rentals.
Ascertain, uncover, and ferret out Manorville United States apartment rentals, Manorville United States houses for rent, and rental houses Manorville.
Hear and hear rental houses in Fayette Pennsylvania and apartments for rent in Fayette Pennsylvania.
Ascertain and come across homes for rent by owner in Bally United States and for rent by owner homes Bally.
South Whitehall property owners, third party listing companies, and landlords list South Whitehall Pennsylvania apartments for rent, bed and breakfast rentals in South Whitehall, and vacation homes South Whitehall.
Notice, observe, and locate Drumore for rent by owner homes, houses for rent in Drumore United States, and Drumore United States rental houses.
Come upon, perceive, and observe real estate rentals in Camptown United States, Camptown United States apartments for rent, and Camptown United States vacation rentals.
Observe and find out vacation rentals Susquehanna Pennsylvania and Susquehanna rental houses.
Cuba Illinois houses for rent and real estate rentals in Cuba
|
|
