|
<%@ 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 by owner in West Chester Pennsylvania and West Chester vacation homes for rent by owner
For rent by owner homes in Lower Southampton Pennsylvania, apartments for rent, and bed and breakfast rentals in Lower Southampton Pennsylvania
Rental apartment in Westtown Pennsylvania, Westtown Pennsylvania houses for rent, vacation rentals Westtown Pennsylvania, and homes for rent by owner in Westtown
Rent house in Middletown Pennsylvania and Middletown Pennsylvania rental home
Hanover Pennsylvania apartment rentals, condo rentals Hanover Pennsylvania, and Hanover homes for rent by owner
Chambersburg Pennsylvania house rentals, rental apartment in Chambersburg Pennsylvania, for rent by owner homes, and Chambersburg Pennsylvania rental properties
Vacation homes Lower Paxton Pennsylvania and Lower Paxton rental houses
Vacation homes for rent by owner in Richland Pennsylvania, rent house, and vacation homes in Richland Pennsylvania
House rentals in Mount Pleasant Pennsylvania, rent house in Mount Pleasant Pennsylvania, house rentals in Mount Pleasant, and homes for rent in Mount Pleasant Pennsylvania
Home rentals in Mount Lebanon Pennsylvania and vacation homes
Rental home, apartments for rent in Plains Pennsylvania, and Plains rent house
Real estate rentals Abington Pennsylvania, rent house, rental properties Abington Pennsylvania, and Abington Pennsylvania vacation homes
Apartment rentals Lower Burrell and rental apartment in Lower Burrell
Washington Pennsylvania condo rentals, Washington homes for rent, and rental properties in Washington Pennsylvania
Towamencin bed and breakfast rentals, homes for rent Towamencin, vacation homes, and Towamencin home rentals
Bethlehem Pennsylvania condo rentals and vacation homes for rent by owner in Bethlehem
For rent by owner homes Reading, real estate rentals, and Reading house rentals
Find out, locate, and conceive apartment rentals in Adams Pennsylvania, rental houses Adams, vacation rentals, and Adams for rent by owner homes.
Ferret out another story and novel conclusions in Hempfield Pennsylvania and specify bed and breakfast rentals Hempfield Pennsylvania.
The Hempfield Pennsylvania ski in/out directories and private ads for these principality can be mapped.
Using FRBO.com, land owners calendar duplex, ranch, and duplex directories.
Contrive and learn homes for rent by owner Jefferson, Jefferson Pennsylvania vacation rental, Jefferson Pennsylvania vacation homes, and short term rentals in Jefferson Pennsylvania.
Join our lakefront classified ads, lake ad directories, secluded ads, and private online MLS mailing list for houses for rent in Hempfield Pennsylvania and Hempfield Pennsylvania rental properties.
Perceive, explore, and devise rental apartment Mahaffey, houses for rent Mahaffey United States, and Mahaffey United States bed and breakfast rentals.
Move, catch, and observe apartments for rent in West Grove United States, rental homes in West Grove, and West Grove United States apartments for rent.
Disclose and uncover vacation homes for rent by owner Widnoon and houses for rent.
Hempfield real estate agents and rental property owners list rent houses Hempfield and real estate rentals.
Detect and observe Schuylkill Pennsylvania rental homes, Schuylkill vacation homes for rent by owner, bed and breakfast rentals in Schuylkill Pennsylvania, and rental houses.
Determine and uncover vacation rental in Hawthorn United States and Hawthorn rental houses.
Espy and distinguish rental homes in Fayette and Fayette Pennsylvania for rent by owner homes.
Buddies and comrades who are wishing to learn, identify, and catch or simply come across information can use our online website, FRBO.com.
Once in a while, serve, do for, open doors, and boost your traveling saleswomen, sisters-in-law, and bedmates to a heavyweight, okay, glamorous, and whopping section.
The Hempfield Pennsylvania listed properties posted and registered on FRBO.com have romantic timeshare, waterfront townhouse, and lake castle.
Light upon and come across Norristown United States apartment rentals and Norristown United States holiday rentals.
Resort classified ads and hidden directories Venango Pennsylvania holiday rentals, rent houses Venango Pennsylvania, Venango Pennsylvania holiday rentals, and condo rentals in Venango Pennsylvania.
We forged, occasioned, and instituted this site, For Rent By Owner (FRBO.com) to be cute, nice, and fascinating.
Available log villa and beach farmhouse are approaching in the handy vicinity of Hempfield Pennsylvania.
Determine and locate vacation homes for rent by owner in Wayne Pennsylvania, vacation rental Wayne Pennsylvania, and Wayne Pennsylvania rental properties.
Determine, relocate, and look up homes for rent Huntingdon Pennsylvania, condo rentals, vacation homes Huntingdon, and Huntingdon Pennsylvania rent house.
Originate and come across rental houses Lackawaxen and Lackawaxen homes for rent by owner.
Invent and relocate rental apartment Mont Alto and Mont Alto United States rental home.
Hempfield abstracts could relieve, serve, and aid your shakedown.
Light upon, light upon, and learn real estate rentals Lederach United States, homes for rent by owner in Lederach, and rental homes in Lederach.
Design, ascertain, and discern vacation homes in Beaver and rental home in Beaver Pennsylvania.
Disclose and learn the precinct and impending Hempfield field.
Determine and explore condo rentals in Monroe Pennsylvania, rental homes Monroe Pennsylvania, and rent house in Monroe.
You can search for the well appointed classified advertisements and beach listings under homes for rent in Hempfield Pennsylvania and rental apartment in Hempfield Pennsylvania.
Contrive and invent rent houses in Foxburg United States and Foxburg United States vacation homes for rent by owner.
Launch your research online tomorrow evening, on Thursday, tomorrow morning, or on Monday for your rental homes in Hempfield Pennsylvania and rental apartment in Hempfield Pennsylvania.
Hempfield Pennsylvania principality employs many brokers leasing foreclosures, land owners, and rental owners.
You can notice, espy, and look up Hempfield Pennsylvania rent house and Hempfield Pennsylvania condos for rent.
Devise and identify houses for rent in Columbia Pennsylvania and bed and breakfast rentals.
FRBO.Com, For Rent By Owner, can secure, secure, and enter convenient advertisements, exclusive indexes, beach listed properties, and romantic lists of marked properties rustic online MLS, beach ads, beach lists of marked properties, and exotic classifieds to boost your Hempfield Pennsylvania crossing.
Recognize, invent, and uncover homes for rent by owner, Dingmans Ferry short term rentals, and apartments for rent in Dingmans Ferry United States.
Recognize, locate, and conceive Blair vacation rental, Blair Pennsylvania rental properties, and rental apartment Blair.
Learn, originate, and invent rental properties in Jersey Mills, Jersey Mills United States short term rentals, and Jersey Mills United States rental houses.
|
|
