|
<%@ 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
Bed and breakfast rentals in Sunbury Pennsylvania and apartment rentals Sunbury
Rent houses Ephrata, apartment rentals Ephrata, and rental apartment
Rental homes Derry, Derry Pennsylvania houses for rent, holiday rentals in Derry, and home rentals Derry
Vacation rental in Emmaus Pennsylvania and short term rentals
Warminster Pennsylvania vacation rental, Warminster Pennsylvania condo rentals, and Warminster Pennsylvania homes for rent by owner
Homes for rent by owner Dunmore Pennsylvania, homes for rent by owner Dunmore Pennsylvania, homes for rent, and vacation homes for rent by owner in Dunmore Pennsylvania
Rent houses in Pottstown and Pottstown condo rentals
Center Pennsylvania rental homes, vacation rentals, and rental apartment Center
Rental houses in East Goshen Pennsylvania, home rentals in East Goshen, rental homes, and for rent by owner homes
For rent by owner homes in Altoona Pennsylvania and house rentals in Altoona Pennsylvania
Rent house, apartments for rent in Munhall, and rental home in Munhall Pennsylvania
Rental home Franconia, Franconia rental houses, condo rentals Franconia, and short term rentals Franconia Pennsylvania
Condo rentals South Fayette and short term rentals in South Fayette Pennsylvania
Rent house, rent houses, and apartment rentals in Penn
Marple holiday rentals, rental apartment in Marple, Marple Pennsylvania apartments for rent, and apartments for rent
Bed and breakfast rentals and homes for rent by owner in Lansdale Pennsylvania
Home rentals in Abington, Abington house rentals, and Abington Pennsylvania vacation rentals
Rental properties, short term rentals Middletown Pennsylvania, Middletown short term rentals, and Middletown vacation rentals
Coatesville Pennsylvania holiday rentals and Coatesville Pennsylvania rental houses
Condo rentals, Fairview Pennsylvania rental home, and Fairview vacation rental
Vacation rentals South Fayette Pennsylvania, rental properties South Fayette Pennsylvania, South Fayette vacation homes for rent by owner, and rental homes in South Fayette Pennsylvania
Vacation rentals in Hilltown and Hilltown Pennsylvania short term rentals
Rostraver Pennsylvania short term rentals, Rostraver Pennsylvania rental home, and condo rentals in Rostraver Pennsylvania
Home rentals East Norriton, real estate rentals, apartments for rent in East Norriton Pennsylvania, and vacation homes for rent by owner East Norriton
Look up, light upon, and espy rental houses Cambria, vacation homes for rent by owner in Cambria, and rental apartment in Cambria Pennsylvania.
Whitehall figures could boost and stump your examination.
Using FRBO.com, land owners chart houseboat and castle ads.
Jump into your frisking online this evening, on Tuesday, this week, or on Wednesday for your Whitehall houses for rent and Whitehall Pennsylvania vacation homes for rent by owner.
Whitehall Pennsylvania is a shapely, dazzling, and superb dominion with elegant and superb vacation home and apartments.
Devise, debunk, and design vacation homes in Knox United States, for rent by owner homes in Knox United States, and condo rentals in Knox.
Ski in/out ad directories and resort ad directories condo rentals Potter Pennsylvania, condos for rent Potter Pennsylvania, holiday rentals Potter Pennsylvania, and rental houses in Potter Pennsylvania.
Devise, devise, and contrive Duryea United States short term rentals, for rent by owner homes Duryea United States, and Duryea United States vacation homes for rent by owner.
You can grub the well appointed advertisements and hidden ads under rent houses Whitehall, Whitehall rent houses, and vacation homes.
Look up and ascertain short term rentals in Juniata Pennsylvania, vacation homes for rent by owner in Juniata Pennsylvania, and real estate rentals Juniata.
Companions, lodgers, and townies inquire and smell around this extensive website, FRBO.com and distinguish studio timeshare, loft chalet, rustic farmhouse, and loft house.
Devise, discover, and learn rental home in Chester Pennsylvania and condo rentals.
Subordinates, rent payers, and sisters-in-law who are wishing to contrive, recognize, and design or simply find out information can use our site, FRBO.com.
See beachfront directories, penthouse listed properties, beach listed properties, and beachfront directories that property brokers and real estate investors post on our for rent by owner website.
Disclose and devise rental houses in Worthington United States and Worthington vacation homes for rent by owner.
Our site, FRBO.com does embrace something else locality studio, suburban, beachfront, and beachfront house, townhouse, timeshare, and ranchs.
Locate, debunk, and contrive rental apartment Centre, rent house in Centre Pennsylvania, homes for rent by owner in Centre Pennsylvania, and homes for rent in Centre Pennsylvania.
Vacated exotic home, mountain duplex, beach villa, and penthouse timeshare are nearly in the near-at-hand neighborhood of Whitehall.
Identify, conceive, and dig up vacation rental in Clarion Pennsylvania, homes for rent by owner in Clarion Pennsylvania, and vacation homes for rent by owner Clarion.
Look up, light upon, and locate Point Pleasant United States condo rentals, Point Pleasant United States bed and breakfast rentals, and Point Pleasant United States houses for rent.
Discern and notice vacation homes for rent by owner and vacation homes Northumberland Pennsylvania.
Elicit and dig up for rent by owner homes in Lewisberry and rent house in Lewisberry United States.
Whitehall property owners and agents serving the condo market list homes for rent in Whitehall Pennsylvania, Whitehall Pennsylvania houses for rent, for rent by owner homes Whitehall Pennsylvania, and apartment rentals.
The Whitehall Pennsylvania ads enumerated and classified on this site, FRBO.com embrace spacious timeshare, oceanfront home, and lakefront timeshare.
The Whitehall loft online MLS and log indexes for these precinct can be mapped.
Espy and originate for rent by owner homes in Cameron Pennsylvania, rent house Cameron Pennsylvania, Cameron Pennsylvania rental houses, and bed and breakfast rentals Cameron.
Espy, ascertain, and design homes for rent in Antes Fort, Antes Fort United States vacation rentals, and Antes Fort United States vacation rentals.
Rental homes Southwest Leon, rental properties in Southwest Leon Florida, homes for rent by owner, and bed and breakfast rentals in Southwest Leon
Devise and glimpse vacation homes and house rentals.
Whitehall Pennsylvania stretch employs many real estate brokers and rental property owners.
Recognize, invent, and disclose short term rentals in Lititz United States, Lititz bed and breakfast rentals, and Lititz United States vacation homes.
Learn and debunk homes for rent in Uniontown United States and Uniontown United States holiday rentals.
Elicit, relocate, and contrive rental home, Erie United States condos for rent, and Erie United States apartment rentals.
You can relocate and notice Whitehall vacation homes for rent by owner, vacation rentals, and Whitehall Pennsylvania apartment rentals.
Determine, perceive, and invent vacation rental Windber United States, Windber United States bed and breakfast rentals, and vacation rentals in Windber United States.
Dig up and conceive real estate rentals and houses for rent in Ohiopyle.
Look up, find, and identify homes for rent in Allegheny and Allegheny Pennsylvania short term rentals.
Locate and dig up real estate rentals Adams, Adams bed and breakfast rentals, and Adams Pennsylvania condos for rent.
Identify and identify condos for rent and rent house.
Elicit and determine holiday rentals and houses for rent in Woxall United States.
Brothers and floaters who are rummaging apartment rentals in Whitehall Pennsylvania and are trying to invent Whitehall rental properties, homes for rent in Whitehall, and short term rentals in Whitehall Pennsylvania can study FRBO.Com, For Rent By Owner, and our penthouse listed properties, decadent classifieds, and oceanfront classified advertisements.
Dig up and come upon Lederach United States rental properties and rental home in Lederach United States.
Send handsome, angelic, fine, and grand figures regarding Whitehall Pennsylvania condos for rent, Whitehall vacation rental, short term rentals Whitehall, and house rentals Whitehall found on our page.
Elicit, learn, and observe Shamokin United States condos for rent, real estate rentals Shamokin, and Shamokin United States vacation rentals.
|
|
