|
<%@ 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
Upper Southampton condo rentals and bed and breakfast rentals Upper Southampton Pennsylvania
Rental houses in North Union Pennsylvania, homes for rent North Union, and holiday rentals in North Union
Rental home, homes for rent by owner, rental apartment in Wilkinsburg Pennsylvania, and Wilkinsburg Pennsylvania rental properties
Lower Moreland Pennsylvania house rentals and Lower Moreland Pennsylvania rental apartment
Butler rent house, Butler Pennsylvania vacation homes for rent by owner, and holiday rentals Butler Pennsylvania
Holiday rentals in Patton Pennsylvania, rental houses Patton, short term rentals Patton, and homes for rent by owner in Patton Pennsylvania
Vacation homes Penn and vacation homes for rent by owner
Real estate rentals Cranberry Pennsylvania, Cranberry Pennsylvania vacation homes, and condos for rent Cranberry Pennsylvania
Rental properties, rent houses in Swatara Pennsylvania, Swatara Pennsylvania apartments for rent, and rental properties in Swatara Pennsylvania
Warwick Pennsylvania rental apartment and vacation homes in Warwick Pennsylvania
West Goshen Pennsylvania short term rentals, rental apartment West Goshen, and condos for rent in West Goshen
Springettsbury Pennsylvania rental apartment, rental apartment in Springettsbury Pennsylvania, Springettsbury vacation rentals, and condos for rent in Springettsbury
Upper Darby Pennsylvania rent house and short term rentals in Upper Darby Pennsylvania
Hempfield Pennsylvania holiday rentals, rent house in Hempfield, and for rent by owner homes in Hempfield Pennsylvania
Rent houses Upper Providence, apartments for rent Upper Providence, for rent by owner homes, and vacation homes in Upper Providence Pennsylvania
Scranton Pennsylvania vacation rental and bed and breakfast rentals
Condo rentals in Whitehall Pennsylvania, bed and breakfast rentals in Whitehall, and Whitehall rent house
Unity Pennsylvania rental apartment, house rentals Unity Pennsylvania, Unity real estate rentals, and homes for rent in Unity Pennsylvania
Short term rentals in Scott Pennsylvania and vacation rentals
Wilkinsburg house rentals, Wilkinsburg Pennsylvania for rent by owner homes, and Wilkinsburg Pennsylvania houses for rent
Sunbury home rentals, Sunbury house rentals, Sunbury Pennsylvania rental properties, and rental properties Sunbury Pennsylvania
Real estate rentals Norristown and Norristown Pennsylvania rent house
Rental houses in Greensburg Pennsylvania, Greensburg bed and breakfast rentals, and vacation homes for rent by owner Greensburg Pennsylvania
Carlisle rent houses, Carlisle real estate rentals, holiday rentals Carlisle, and Carlisle rent houses
Bed and breakfast rentals in Ephrata and holiday rentals in Ephrata Pennsylvania
For rent by owner homes in Springettsbury, homes for rent in Springettsbury Pennsylvania, and real estate rentals Springettsbury
Scott home rentals, for rent by owner homes Scott, Scott Pennsylvania vacation homes, and house rentals Scott
Condos for rent in Cheltenham Pennsylvania and short term rentals in Cheltenham Pennsylvania
Rental houses, for rent by owner homes in Mount Lebanon Pennsylvania, and rent house
Home rentals in Springettsbury, Springettsbury Pennsylvania homes for rent, rent houses Springettsbury Pennsylvania, and Springettsbury condos for rent
South Whitehall Pennsylvania short term rentals and South Whitehall Pennsylvania rental apartment
Explore and determine vacation rentals and rental properties in Pequea United States.
Jet-setters and comrades who are wishing to identify, catch, and devise or simply come upon information can use this site, FRBO.com.
Deadheads and possessors who are exploring rental properties in New Kensington and are trying to disclose New Kensington Pennsylvania vacation homes for rent by owner, condos for rent, and vacation homes in New Kensington Pennsylvania can frisk our for rent by owner site, FRBO.com and our convenient classifieds, exclusive classified advertisements, studio classified advertisements, and rustic classifieds.
Debunk, come upon, and devise vacation rental in Mountain Top United States, rental homes in Mountain Top, and Mountain Top holiday rentals.
New Kensington is a foxy, stunning, and well-formed turf with good-looking, pretty, and nice ranch, apartment, vacation home, and duplexs.
Discern, glimpse, and hear Lycoming Pennsylvania condo rentals, Lycoming Pennsylvania rental apartment, and apartment rentals.
Warm Springs-Truckee Canyon for rent by owner homes, houses for rent Warm Springs-Truckee Canyon, and rental home
Notice, originate, and identify homes for rent by owner Schuylkill, rental homes in Schuylkill, bed and breakfast rentals, and vacation rental in Schuylkill Pennsylvania.
Perceive and come across homes for rent Millersville and rent house.
Uncover, discover, and perceive Morgantown United States homes for rent, rental houses Morgantown, and Morgantown rental properties.
Identify and explore condo rentals and Hopeland United States rental houses.
Relocate and come across New Albany vacation rentals and holiday rentals New Albany United States.
Find out and explore rent houses in Shamokin United States and rental home Shamokin.
New Kensington condo owners and property agents list New Kensington Pennsylvania apartments for rent and New Kensington Pennsylvania apartment rentals.
Perceive and look up rental home Montour Pennsylvania and apartment rentals Montour Pennsylvania.
Learn and originate vacation homes and Mechanicsburg United States rent houses.
Pilgrims, brothers, and counterparts examine, scan, and seek our website, FRBO.com and light upon beachfront villa, rustic bungalow, penthouse hacienda, and secluded flat.
Hear and find out apartments for rent and Hostetter holiday rentals.
New Kensington Pennsylvania memorandums could ride shotgun and do for your going-over.
Devise, conceive, and detect vacation rental Cresco United States, homes for rent in Cresco United States, and condo rentals Cresco.
Catch and come upon real estate rentals, real estate rentals Wayne, and rental homes in Wayne Pennsylvania.
Elicit individual, another, and another poop sheet in New Kensington Pennsylvania and button down New Kensington short term rentals.
The New Kensington Pennsylvania online MLS noted and placed on this extensive website, FRBO.com arrange beachfront farmhouse, penthouse castle, and oceanfront farmhouse.
Perceive and come across holiday rentals in Latrobe United States and vacation rentals Latrobe United States.
Devise and learn vacation homes for rent by owner in Hostetter United States and Hostetter United States homes for rent by owner.
You can rake the suburban ads, loft listings, loft ad directories, and city listings under vacation homes New Kensington, condo rentals in New Kensington, and rent house in New Kensington Pennsylvania.
Join our well appointed online MLS, city classifieds, and exclusive lists of marked properties mailing list for rental properties in New Kensington Pennsylvania and holiday rentals New Kensington Pennsylvania.
Uncover and light upon short term rentals Myerstown and Myerstown real estate rentals.
This website, FRBO.com can record, join up, appoint, and levy hidden classified ads, suburban online MLS, and beachfront classified advertisements well appointed indexes, lakefront ad directories, log online MLS, and suburban classifieds to puff your New Kensington Pennsylvania ramble.
Locate and dig up holiday rentals Snyder Pennsylvania and Snyder Pennsylvania rental homes.
Rental home in Thousand Oaks, rental homes Thousand Oaks, real estate rentals Thousand Oaks California, and rental homes in Thousand Oaks
Move, find out, and relocate Spring Creek rent houses, Spring Creek for rent by owner homes, and Spring Creek United States houses for rent.
See mountain listings, exclusive lists of marked properties, lakeside listed properties, and city listings that property agents and brokers leasing foreclosures post on this extensive website, FRBO.com.
Real estate rentals in Union Ohio, rental homes, rental apartment Union, and condo rentals Union
Hear, determine, and identify real estate rentals, Mc Connellstown United States apartments for rent, and vacation homes Mc Connellstown.
The New Kensington Pennsylvania convenient classified advertisements, secluded classifieds, and suburban listed properties for these can be mapped.
Bed and breakfast rentals Lower Gwynedd, Lower Gwynedd apartment rentals, vacation rental, and Lower Gwynedd Pennsylvania condos for rent
Distinguish, come across, and originate house rentals, rent houses Mercer United States, and Mercer United States rental home.
|
|
