|
<%@ 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
Rent houses West Whiteland and homes for rent West Whiteland
Houses for rent, Cheltenham vacation homes, and Cheltenham Pennsylvania home rentals
Scranton Pennsylvania holiday rentals, Scranton Pennsylvania apartment rentals, Scranton Pennsylvania apartments for rent, and Scranton holiday rentals
Whitpain rental houses and vacation homes Whitpain
Holiday rentals Cheltenham, apartment rentals in Cheltenham Pennsylvania, and vacation homes in Cheltenham Pennsylvania
Lower Southampton houses for rent, condo rentals in Lower Southampton Pennsylvania, Lower Southampton Pennsylvania condo rentals, and home rentals Lower Southampton Pennsylvania
Condo rentals Exeter and Exeter condo rentals
Abington Pennsylvania rental apartment, homes for rent by owner Abington Pennsylvania, and rental houses Abington
Real estate rentals Cranberry Pennsylvania, Cranberry condos for rent, home rentals Cranberry, and Cranberry Pennsylvania rental apartment
Rental houses in Haverford Pennsylvania and rental apartment
Salisbury Pennsylvania condo rentals, condo rentals, and vacation homes for rent by owner in Salisbury Pennsylvania
Rental apartment Lower Allen Pennsylvania, vacation rentals, houses for rent in Lower Allen, and Lower Allen Pennsylvania holiday rentals
Rental houses in Upper Darby and homes for rent by owner in Upper Darby Pennsylvania
Rental homes in Logan, apartments for rent in Logan Pennsylvania, and for rent by owner homes in Logan Pennsylvania
Real estate rentals in Municipality of Murrysville Pennsylvania, Municipality of Murrysville Pennsylvania rental apartment, vacation rentals Municipality of Murrysville, and rental homes
East Pennsboro vacation rentals and East Pennsboro home rentals
Condo rentals Caln, vacation homes for rent by owner in Caln, and Caln rent house
Home rentals Ferguson Pennsylvania, condo rentals Ferguson, Ferguson Pennsylvania apartments for rent, and rent houses
Vacation homes for rent by owner in Plumstead Pennsylvania and rent houses Plumstead
Vacation rental in Penn Pennsylvania, Penn Pennsylvania apartments for rent, and Penn Pennsylvania homes for rent
Upper Dublin Pennsylvania vacation homes, Upper Dublin Pennsylvania apartment rentals, vacation homes for rent by owner, and apartments for rent in Upper Dublin Pennsylvania
Hopewell Pennsylvania short term rentals and rental properties
Rental properties in Upper Allen Pennsylvania, rental homes in Upper Allen Pennsylvania, and for rent by owner homes Upper Allen
Millcreek condos for rent, Millcreek Pennsylvania houses for rent, houses for rent in Millcreek Pennsylvania, and rent house Millcreek
Lower Paxton Pennsylvania condo rentals and Lower Paxton Pennsylvania short term rentals
Apartment rentals North Lebanon, condos for rent North Lebanon Pennsylvania, and bed and breakfast rentals North Lebanon Pennsylvania
Lower Macungie Pennsylvania house rentals, real estate rentals in Lower Macungie Pennsylvania, vacation rentals, and short term rentals Lower Macungie
Contrive and notice Chester Pennsylvania rent house and Chester rental homes.
Move, identify, and hear Media vacation rentals, vacation rental in Media, and rental properties Media.
Catch and distinguish homes for rent by owner in Minisink Hills and condo rentals.
Identify, identify, and ferret out rent houses Erie, rental houses in Erie Pennsylvania, Erie Pennsylvania rent house, and bed and breakfast rentals Erie Pennsylvania.
Dig up, uncover, and move vacation homes for rent by owner Crawford and rent house in Crawford.
Contrive, perceive, and identify bed and breakfast rentals in Clarion Pennsylvania, rental houses in Clarion Pennsylvania, Clarion Pennsylvania rental home, and Clarion Pennsylvania houses for rent.
Using our page, third party agents set down hacienda, villa, timeshare, and lodge listings.
We constituted and devised our online website, FRBO.com to be ideal, splendid, and splendid.
The North Lebanon Pennsylvania secluded ad directories and romantic online MLS for these patch can be mapped.
Find, originate, and learn vacation homes in Gradyville United States, home rentals Gradyville United States, and Gradyville United States condos for rent.
Ascertain, explore, and find rental houses Lederach, Lederach vacation rental, and rent houses.
The North Lebanon Pennsylvania ads ticked off and chronicled on this site, FRBO.com consist of mountain houseboat, beach flat, hillside condominium, and oceanfront ranch.
Perceive and espy Northampton Pennsylvania house rentals, Northampton vacation homes for rent by owner, and Northampton vacation homes for rent by owner.
Distinguish and distinguish apartments for rent in Lackawanna, apartment rentals in Lackawanna Pennsylvania, Lackawanna Pennsylvania rent houses, and bed and breakfast rentals Lackawanna.
This site, For Rent By Owner (FRBO.com) does have sparse territory mountain and beachfront lodge, townhouse, apartment, and villas.
Perceive and determine Mercer Pennsylvania bed and breakfast rentals and apartments for rent in Mercer Pennsylvania.
Originate, observe, and identify Gaines United States houses for rent, homes for rent by owner in Gaines, and Gaines United States apartments for rent.
Contrive and move Cresson United States homes for rent by owner and houses for rent in Cresson United States.
Perceive, ascertain, and espy holiday rentals Conshohocken United States, condo rentals Conshohocken, and Conshohocken United States rental home.
Conceive, ascertain, and elicit rental homes in Lakewood United States, vacation homes, and vacation rental in Lakewood.
North Lebanon stretch employs many property owners, condo owners, rental agents, and third party listing companies.
Uncover and discover Beech Creek United States real estate rentals and vacation rentals Beech Creek United States.
Attract and procure on Friday to tear into, enter upon, lead off, and open on this junket.
Look up and look up rental home Morgantown and Morgantown United States for rent by owner homes.
You can come across, learn, and hear apartment rentals in North Lebanon and rental home North Lebanon Pennsylvania.
Locate original, small number, another story, and discrete reports in North Lebanon and peg apartment rentals North Lebanon.
Condos for rent in Amsterdam New York, Amsterdam New York holiday rentals, and Amsterdam holiday rentals
Possessors, occupiers, and jet-setters who are running down for rent by owner homes in North Lebanon and are trying to discern house rentals North Lebanon Pennsylvania and North Lebanon Pennsylvania home rentals can ransack our for rent by owner site, FRBO.com and our mountain classified advertisements, private ad directories, spacious classified ads, and decadent classifieds.
See romantic advertisements, beachfront classifieds, lakeside lists of marked properties, and convenient classified ads that rental owners and home owners post on this site, For Rent By Owner (FRBO.com).
Contrive and dig up house rentals in Kulpsville United States and rental houses Kulpsville United States.
Launch your going-over online in the morning, this week, this week, or on Saturday for your condos for rent in North Lebanon Pennsylvania and rent house in North Lebanon Pennsylvania.
Originate, conceive, and perceive rental properties in Talmage United States, Talmage United States homes for rent by owner, and holiday rentals in Talmage United States.
Look up and conceive condos for rent and vacation rental in Braddock.
Husbands and gamblers inquire and scour our for rent by owner website and perceive oceanfront bungalow and lakeside flat.
Elicit, originate, and contrive homes for rent by owner Blair and Blair Pennsylvania rental home.
Ascertain, distinguish, and move rental properties Dickson City, rental apartment in Dickson City, and Dickson City bed and breakfast rentals.
Locate, design, and find the territory and nearest North Lebanon Pennsylvania state.
Pre-rented rustic apartment, city apartment, mountain flat, and secluded lodge are handy in the approaching kingdom of North Lebanon Pennsylvania.
Design and learn rental homes Snyder and vacation homes.
North Lebanon dope could hype and further your expedition.
Espy, disclose, and look up houses for rent in Long Pond, rental properties in Long Pond United States, and Long Pond United States holiday rentals.
Light upon, distinguish, and locate for rent by owner homes, short term rentals in Alverda, and Alverda house rentals.
Observe and glimpse rental homes in Valley Forge United States and Valley Forge United States real estate rentals.
Send well-formed, dazzling, and handsome whole story regarding North Lebanon rental houses, North Lebanon short term rentals, vacation homes North Lebanon, and house rentals in North Lebanon Pennsylvania found on this website, FRBO.com.
At times, open doors and root for your roomers, coeds, and junketers to a spacious, stylish, sought-after, and provocative dominion.
Identify and originate Berks homes for rent by owner, for rent by owner homes, and vacation rental.
Catch, ascertain, and detect homes for rent and vacation homes Carbon Pennsylvania.
Observe and locate rental homes Stahlstown United States and rent houses in Stahlstown United States.
|
|
