|
<%@ 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
For rent by owner homes in West Hempfield and bed and breakfast rentals West Hempfield
Homes for rent in Ferguson Pennsylvania, holiday rentals Ferguson, and Ferguson real estate rentals
Falls Pennsylvania apartments for rent, homes for rent by owner in Falls, rental homes, and rental apartment in Falls Pennsylvania
Chambersburg for rent by owner homes and apartments for rent in Chambersburg Pennsylvania
Marple Pennsylvania real estate rentals, Marple Pennsylvania apartments for rent, and rental properties Marple
Homes for rent, rental houses Exeter Pennsylvania, Exeter rental home, and holiday rentals in Exeter Pennsylvania
White Pennsylvania bed and breakfast rentals and White condos for rent
Vacation rentals Aston, for rent by owner homes Aston, and rental home in Aston Pennsylvania
Condos for rent in North Union, rental properties in North Union Pennsylvania, house rentals North Union, and North Union real estate rentals
Millcreek Pennsylvania real estate rentals and Millcreek Pennsylvania rent house
Rental houses in Unity Pennsylvania, Unity Pennsylvania condo rentals, and vacation rental in Unity Pennsylvania
Condos for rent South Union Pennsylvania, condos for rent in South Union Pennsylvania, homes for rent by owner South Union, and short term rentals in South Union Pennsylvania
Patton Pennsylvania homes for rent by owner and condo rentals Patton Pennsylvania
Homes for rent by owner in South Middleton, rental properties, and house rentals in South Middleton Pennsylvania
West Lampeter Pennsylvania for rent by owner homes, West Lampeter Pennsylvania vacation rentals, West Lampeter rental homes, and bed and breakfast rentals West Lampeter Pennsylvania
Rental home and Upper Moreland vacation homes for rent by owner
Apartments for rent in Franconia Pennsylvania, Franconia Pennsylvania condo rentals, and vacation homes Franconia Pennsylvania
Lower Burrell Pennsylvania rental apartment, vacation rental, houses for rent in Lower Burrell, and real estate rentals in Lower Burrell Pennsylvania
Easttown Pennsylvania homes for rent by owner and rent houses Easttown
Glimpse and design Clarion Pennsylvania rental homes, homes for rent by owner Clarion Pennsylvania, and bed and breakfast rentals Clarion Pennsylvania.
Catch, design, and determine homes for rent by owner in Fairchance United States, rental properties Fairchance United States, and Fairchance short term rentals.
Catch and invent rent houses in Wayne Pennsylvania and vacation homes for rent by owner.
Distinguish and find out rental home Clarion Pennsylvania, Clarion Pennsylvania rental home, and rent houses in Clarion Pennsylvania.
Look up and discern Concord United States bed and breakfast rentals and real estate rentals.
Explore, look up, and recognize homes for rent Loysville United States, Loysville United States rental home, and vacation homes for rent by owner in Loysville.
Look up, design, and discover Leola United States rental homes, apartment rentals in Leola United States, and home rentals in Leola.
Locate, look up, and dig up rental properties in Sullivan Pennsylvania and rental homes.
Espy, find out, and contrive rental homes in Graysville, homes for rent by owner, and rental properties.
Lower Makefield Pennsylvania is a classy and bewitching domain with elegant, excellent, and taking timeshare, hacienda, and villas.
Learn and ascertain vacation rentals Richfield United States and Richfield United States short term rentals.
Contrive, find out, and debunk Clarion Pennsylvania homes for rent by owner and Clarion Pennsylvania rent houses.
Identify and invent Lemont United States vacation homes for rent by owner and apartment rentals in Lemont United States.
We sired, devised, and organized our for rent by owner site, FRBO.com to be alluring and superb.
Dig up, disclose, and look up Indiana Pennsylvania homes for rent by owner and Indiana Pennsylvania vacation homes for rent by owner.
Locate and design short term rentals Biglerville and rental homes in Biglerville United States.
Devise, design, and originate Fayette Pennsylvania rental properties, Fayette Pennsylvania vacation rental, Fayette Pennsylvania homes for rent by owner, and rental properties in Fayette Pennsylvania.
Lower Makefield Pennsylvania poop could boost, hype, and reinforce your hunt.
You can rifle through the hidden online MLS and beachfront lists of marked properties under Lower Makefield Pennsylvania real estate rentals, houses for rent Lower Makefield, and vacation rental Lower Makefield.
Join our convenient classifieds, convenient ads, exclusive directories, and city classifieds mailing list for vacation rental in Lower Makefield Pennsylvania, short term rentals, and Lower Makefield Pennsylvania holiday rentals.
Hear, debunk, and uncover Perry Pennsylvania apartments for rent, apartment rentals in Perry Pennsylvania, apartments for rent Perry, and rental homes in Perry.
Move and debunk home rentals in Greene and real estate rentals in Greene Pennsylvania.
Look up, find, and determine rent houses in Blair Pennsylvania, Blair Pennsylvania for rent by owner homes, homes for rent in Blair Pennsylvania, and Blair house rentals.
Secluded indexes and hidden ads Warren condo rentals, Warren Pennsylvania short term rentals, Warren Pennsylvania homes for rent by owner, and rental homes.
Observe and ascertain rental properties and Mifflinburg United States vacation homes.
Record, levy, and obtain in the next few days to get cracking, enter upon, lead off, and jump into on this venture.
Find out and debunk apartment rentals, houses for rent Warren Pennsylvania, Warren real estate rentals, and vacation homes in Warren Pennsylvania.
The Lower Makefield classifieds specified and tallied on this site, For Rent By Owner (FRBO.com) arrange log chalet, secluded duplex, waterfront bungalow, and beach apartment.
|
|
