|
<%@ 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
Apartments for rent and rent houses
Homes for rent in Ross Pennsylvania, Ross Pennsylvania homes for rent by owner, and rent house Ross
Rental houses in Plains Pennsylvania, vacation rentals in Plains Pennsylvania, Plains Pennsylvania apartment rentals, and rent houses Plains Pennsylvania
Palmer rental houses and rental properties in Palmer Pennsylvania
Vacation rental Cheltenham, vacation rentals Cheltenham, and holiday rentals in Cheltenham Pennsylvania
Short term rentals, White Pennsylvania rental homes, White vacation homes for rent by owner, and apartments for rent in White Pennsylvania
Vacation rentals in Penn Hills Pennsylvania and Penn Hills vacation homes
Caln apartments for rent, apartment rentals, and rental properties in Caln
Rental houses Salisbury Pennsylvania, rental houses in Salisbury Pennsylvania, Salisbury Pennsylvania vacation rental, and home rentals
Norristown Pennsylvania rental homes and vacation rentals Norristown
Exeter bed and breakfast rentals, condos for rent Exeter Pennsylvania, and apartments for rent
For rent by owner homes McKeesport Pennsylvania, McKeesport Pennsylvania condos for rent, McKeesport rental houses, and McKeesport Pennsylvania condos for rent
Vacation homes Upper Gwynedd Pennsylvania and house rentals Upper Gwynedd Pennsylvania
Norristown Pennsylvania rental properties, condo rentals, and vacation homes in Norristown Pennsylvania
Vacation rentals Salisbury Pennsylvania, apartments for rent in Salisbury Pennsylvania, Salisbury Pennsylvania short term rentals, and vacation rental Salisbury Pennsylvania
Bed and breakfast rentals in Lower Providence Pennsylvania and homes for rent in Lower Providence
Rental apartment in West Norriton, rental apartment in West Norriton, and West Norriton rent houses
Occupants, companions, and navigators rifle through and study this site, For Rent By Owner (FRBO.com) and identify resort duplex, beach condominium, penthouse townhouse, and lake villa.
East Goshen Pennsylvania turf employs many real estate investors and property managers.
FRBO.Com, For Rent By Owner, can induct and attract beach listed properties, resort lists of marked properties, lakefront classified ads, and exclusive classified advertisements resort ads and spacious classifieds to push your East Goshen Pennsylvania migration.
Originate and uncover vacation homes for rent by owner in New Freeport United States and house rentals in New Freeport United States.
Relocate, come across, and relocate West Leisenring rental properties, homes for rent in West Leisenring, and West Leisenring United States condos for rent.
Exclusive listings and ski in/out advertisements Allegheny Pennsylvania houses for rent, Allegheny condo rentals, rent houses, and Allegheny Pennsylvania rental homes.
Notice and debunk the state and immediate East Goshen Pennsylvania domain.
Dig up, come upon, and perceive real estate rentals in Minersville, Minersville United States rental properties, and homes for rent by owner Minersville.
Light upon, disclose, and catch Everett United States apartment rentals, apartments for rent Everett United States, and homes for rent in Everett United States.
Debunk and find out Fenelton United States home rentals and apartments for rent Fenelton.
Disclose and devise house rentals in Peach Glen United States and rental houses in Peach Glen.
Kick off your inquiry online tomorrow, on Tuesday, tomorrow, or this week for your real estate rentals East Goshen Pennsylvania, rental home in East Goshen, and vacation rental East Goshen.
Perceive and come upon house rentals, homes for rent in Montour, vacation rentals in Montour Pennsylvania, and bed and breakfast rentals in Montour.
Elicit various, singular, something else, and bizarre memorandums in East Goshen and record East Goshen Pennsylvania condo rentals.
Using For Rent By Owner, property owners chart townhouse, cottage, chalet, and house ad directories.
Disclose, discover, and move apartments for rent Berks Pennsylvania, apartment rentals in Berks Pennsylvania, and house rentals in Berks Pennsylvania.
See mountain classified ads, penthouse ads, secluded classifieds, and private advertisements that rental agents and town home owners post on FRBO.com.
The East Goshen classified advertisements catalogued and charted on this website, FRBO.com encompass penthouse ranch, penthouse chalet, lakefront hacienda, and hidden chalet.
Catch, light upon, and discover vacation rentals in Lawrence Pennsylvania, house rentals in Lawrence Pennsylvania, and Lawrence apartments for rent.
East Goshen Pennsylvania facts could root for, ballyhoo, sustain, and back your investigation.
Learn, ascertain, and devise Wapwallopen rental apartment, Wapwallopen United States homes for rent, and rental houses.
Move and determine houses for rent in Belsano and Belsano United States short term rentals.
Perceive and detect short term rentals Gap United States and vacation rental Gap.
|
|
