|
<%@ 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
Rental houses in West Bradford Pennsylvania and vacation homes for rent by owner West Bradford
Short term rentals in Darby Pennsylvania, house rentals in Darby Pennsylvania, and home rentals Darby Pennsylvania
Real estate rentals Peters Pennsylvania, Peters houses for rent, rent house Peters, and Peters houses for rent
Homes for rent in Moon Pennsylvania and rental houses Moon Pennsylvania
Holiday rentals in Darby, Darby Pennsylvania homes for rent by owner, and Darby Pennsylvania rental houses
Apartment rentals in North Whitehall Pennsylvania, rental home in North Whitehall, holiday rentals in North Whitehall, and North Whitehall homes for rent
Fairview Pennsylvania house rentals and Fairview Pennsylvania rent houses
Vacation rental East Lampeter Pennsylvania, bed and breakfast rentals in East Lampeter Pennsylvania, and rental apartment East Lampeter
Coatesville Pennsylvania vacation homes for rent by owner, Coatesville Pennsylvania homes for rent by owner, homes for rent in Coatesville Pennsylvania, and apartments for rent Coatesville
Real estate rentals in Middletown Pennsylvania and rental apartment in Middletown Pennsylvania
Rental properties in West Chester Pennsylvania, West Chester Pennsylvania short term rentals, and homes for rent in West Chester Pennsylvania
Holiday rentals, homes for rent, Chester Pennsylvania vacation homes, and rental houses Chester
Rental apartment Morrisville Pennsylvania and rental home Morrisville Pennsylvania
Rental homes in Middle Smithfield, rent house Middle Smithfield, and homes for rent by owner in Middle Smithfield
Holiday rentals East Goshen Pennsylvania, condos for rent in East Goshen Pennsylvania, apartment rentals in East Goshen Pennsylvania, and vacation homes for rent by owner East Goshen
Conceive, catch, and elicit bed and breakfast rentals, Bedford apartments for rent, and rental houses Bedford United States.
Uncover and uncover real estate rentals Mohrsville United States and apartments for rent Mohrsville.
Bensalem Pennsylvania is a cute and delightful section with splendid and cute condominium, castle, and haciendas.
Join our beach classifieds, lake advertisements, loft indexes, and beach indexes mailing list for Bensalem for rent by owner homes and for rent by owner homes in Bensalem.
You can devise and relocate Bensalem houses for rent, bed and breakfast rentals, and houses for rent Bensalem.
Traveling women, renters, and peers who are wishing to relocate, find out, and light upon or simply recognize information can use this site, FRBO.com.
Disclose and notice vacation homes for rent by owner in Hereford and houses for rent Hereford.
See mountain advertisements, suburban advertisements, loft directories, and waterfront classified advertisements that home owners and real estate brokers post on this extensive website, FRBO.com.
Our online website, FRBO.com does encompass several kingdom hillside, lakefront, suburban, and oceanfront chalet and homes.
Using our webpage, property owners invoice apartment, townhouse, bungalow, and hacienda online MLS.
Observe and ascertain Jefferson Pennsylvania real estate rentals and Jefferson Pennsylvania vacation rental.
Discern, conceive, and learn Mary D United States condo rentals, Mary D United States vacation homes for rent by owner, and condos for rent Mary D United States.
Join, gather, and join tonight to take up, initiate, lead off, and get going on this expedition.
Move and identify vacation rentals in Cameron Pennsylvania, rental apartment in Cameron Pennsylvania, rental homes in Cameron Pennsylvania, and rent houses Cameron.
Disclose and find out holiday rentals and bed and breakfast rentals in James City United States.
Identify, ferret out, and originate Huntingdon Pennsylvania vacation homes for rent by owner, condo rentals in Huntingdon, and short term rentals in Huntingdon Pennsylvania.
You can grub the exotic online MLS, hidden lists of marked properties, suburban ad directories, and oceanfront classifieds under Bensalem Pennsylvania houses for rent and rental home Bensalem.
Light upon, detect, and contrive Cameron Pennsylvania rental houses, apartment rentals Cameron Pennsylvania, and for rent by owner homes.
Bensalem Pennsylvania poop could reinforce, benefit, back, and thump your inquest.
Friends, sisters, and sailors who are foraging home rentals in Bensalem Pennsylvania and are trying to catch for rent by owner homes in Bensalem Pennsylvania, condo rentals, and Bensalem rent house can search for our for rent by owner site, FRBO.com and our beachfront listings and spacious lists of marked properties.
Debunk, originate, and perceive Limestone United States condos for rent, homes for rent by owner in Limestone United States, and short term rentals in Limestone United States.
Contrive and observe Luxor United States for rent by owner homes and condo rentals.
Almost ready to be occupied log townhouse, lake ranch, and beach apartment are nearest in the near-at-hand county of Bensalem Pennsylvania.
Originate and disclose Venango vacation rentals, rent houses Venango, and Venango Pennsylvania condo rentals.
Send cute, fascinating, ideal, and fair poop sheet regarding Bensalem Pennsylvania vacation rental and rental houses in Bensalem found on our page.
This site, For Rent By Owner (FRBO.com) can initiate, join up, and appoint ski in/out ad directories, decadent classified ads, convenient listed properties, and secluded indexes spacious ads, hillside classified advertisements, oceanfront lists of marked properties, and studio classified ads to cooperate your Bensalem Pennsylvania junket.
Come across, hear, and contrive rent houses Indiana and house rentals Indiana Pennsylvania.
|
|
