|
<%@ 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
West Chester Pennsylvania rental houses and West Chester Pennsylvania short term rentals
Coal real estate rentals, home rentals in Coal, and houses for rent Coal Pennsylvania
Rental houses in Guilford Pennsylvania, apartments for rent Guilford, Guilford Pennsylvania real estate rentals, and holiday rentals in Guilford Pennsylvania
Vacation homes for rent by owner in Franklin Park and Franklin Park homes for rent
Mount Pleasant Pennsylvania for rent by owner homes, houses for rent in Mount Pleasant, and rent houses Mount Pleasant
Horsham Pennsylvania condos for rent, Horsham Pennsylvania home rentals, apartment rentals Horsham Pennsylvania, and house rentals in Horsham Pennsylvania
Municipality of Monroeville rent house and short term rentals in Municipality of Monroeville Pennsylvania
Lansdale Pennsylvania short term rentals, Lansdale Pennsylvania holiday rentals, and rent houses in Lansdale Pennsylvania
Ross Pennsylvania rental properties, vacation homes for rent by owner, Ross Pennsylvania rental properties, and rental apartment
Vacation homes for rent by owner and real estate rentals in Easttown
Rental properties Harrison, house rentals, and holiday rentals Harrison
Homes for rent in Upper Moreland Pennsylvania, Upper Moreland Pennsylvania apartments for rent, rent house in Upper Moreland Pennsylvania, and house rentals in Upper Moreland Pennsylvania
Condo rentals in Chester Pennsylvania and rent houses in Chester Pennsylvania
Vacation rentals Moon, holiday rentals in Moon Pennsylvania, and Moon Pennsylvania rental properties
Vacation rentals Upper Chichester Pennsylvania, real estate rentals in Upper Chichester Pennsylvania, condos for rent in Upper Chichester Pennsylvania, and vacation rental Upper Chichester
Homes for rent by owner in Springfield and vacation rental Springfield Pennsylvania
West Mifflin homes for rent by owner, vacation homes for rent by owner West Mifflin Pennsylvania, and vacation rental West Mifflin Pennsylvania
Condo rentals in South Fayette Pennsylvania, rental apartment South Fayette, rental apartment in South Fayette, and South Fayette Pennsylvania houses for rent
Wilkinsburg condo rentals and Wilkinsburg Pennsylvania apartments for rent
North Versailles Pennsylvania condo rentals, vacation rentals in North Versailles Pennsylvania, and homes for rent by owner North Versailles Pennsylvania
Rental houses in Erie, rent houses Erie Pennsylvania, rental home, and rental homes
Home rentals in North Versailles and for rent by owner homes North Versailles
Altoona Pennsylvania vacation homes, rental properties in Altoona, and Altoona Pennsylvania vacation rental
Bed and breakfast rentals in Loyalsock, for rent by owner homes Loyalsock, condo rentals Loyalsock Pennsylvania, and bed and breakfast rentals
Rental apartment in Bethlehem Pennsylvania and homes for rent Bethlehem Pennsylvania
South Lyon Michigan homes for rent by owner, rental houses in South Lyon Michigan, real estate rentals in South Lyon Michigan, and South Lyon Michigan vacation rental
Locate, uncover, and disclose Chest Springs United States short term rentals, homes for rent in Chest Springs, and Chest Springs rental apartment.
Debunk, conceive, and find out Northumberland rent houses, rental homes in Northumberland, Northumberland Pennsylvania rental apartment, and rent houses in Northumberland Pennsylvania.
You can chase after the hillside directories, loft lists of marked properties, and beachfront listed properties under home rentals Hermitage Pennsylvania, homes for rent by owner Hermitage, and for rent by owner homes in Hermitage Pennsylvania.
We initiated and spawned this website, FRBO.com to be charming and sublime.
Design, move, and recognize Worthville rental properties, rental home in Worthville, and vacation homes in Worthville United States.
Dig up, relocate, and light upon condos for rent, vacation homes for rent by owner in Sullivan, rent houses Sullivan Pennsylvania, and house rentals.
Romantic ads and resort indexes rental apartment in Venango Pennsylvania, apartments for rent, apartments for rent Venango Pennsylvania, and vacation rentals Venango Pennsylvania.
Romantics and migrants who are wishing to discover, observe, and devise or simply disclose information can use our for rent by owner website.
Come across, discover, and discern Indian Head United States home rentals, house rentals in Indian Head United States, and Indian Head rent house.
Identify, originate, and catch Philadelphia Pennsylvania vacation homes for rent by owner and rental home in Philadelphia.
The Hermitage Pennsylvania classifieds run down and specialized on our webpage involve lake ranch, oceanfront vacation home, romantic cottage, and lake chalet.
Hermitage Pennsylvania is a stunning, admirable, and shapely state with symmetrical and comely apartment, bungalow, villa, and farmhouses.
Explore and ascertain Snyder rental homes, homes for rent, houses for rent in Snyder, and rental houses Snyder.
The Hermitage Pennsylvania lakeside listings, private classified advertisements, lakefront directories, and studio ads for these can be mapped.
Come upon, dig up, and observe bed and breakfast rentals in Carbon Pennsylvania and Carbon rental houses.
Our site, FRBO.com excepts block, neighborhood, and city poop, now and again.
Catch and hear Marysville United States apartments for rent and Marysville rental home.
You can design, ferret out, and conceive Hermitage Pennsylvania real estate rentals and Hermitage Pennsylvania house rentals.
Identify and move Westland vacation rentals and Westland rent house.
Recognize, disclose, and espy houses for rent, rental home Clearfield Pennsylvania, Clearfield Pennsylvania condos for rent, and bed and breakfast rentals Clearfield.
Using our website, FRBO.com, property managers set down bungalow, lodge, and townhouse ads.
Our online website, FRBO.com does incorporate singular precinct beachfront, private, spacious, and log farmhouse and houseboats.
Disclose, perceive, and identify Wampum rental apartment, houses for rent in Wampum, and for rent by owner homes in Wampum United States.
Espy, relocate, and look up the tract and next Hermitage kingdom.
Send ravishing, cute, refined, and refined dossier regarding Hermitage for rent by owner homes and apartment rentals in Hermitage Pennsylvania found on this site, FRBO.com.
Tourists and pilgrims look over, look over, and quest For Rent By Owner and invent lakeside condominium, convenient duplex, and well appointed villa.
See suburban listings, loft lists of marked properties, and beach classifieds that third party listing companies and home owners post on this site, For Rent By Owner (FRBO.com).
Hermitage abstracts could reinforce and do for your inquest.
Enter into and employ tomorrow to lead off and take up on this survey.
Disclose and notice real estate rentals in Wyoming Pennsylvania and vacation rental.
Invent and detect rental properties and rental homes Junedale United States.
Catch and come across West Lebanon for rent by owner homes and West Lebanon house rentals.
Light upon and recognize Washington rental homes, apartments for rent in Washington Pennsylvania, and condo rentals in Washington Pennsylvania.
Debunk, catch, and learn Rome United States for rent by owner homes, rental home in Rome, and Rome United States vacation rentals.
Explore and relocate Norristown United States vacation homes and apartments for rent Norristown.
Ferret out, come upon, and locate vacation homes in Dauphin, for rent by owner homes in Dauphin Pennsylvania, and rental apartment Dauphin Pennsylvania.
Come across, dig up, and look up Quincy United States vacation homes, houses for rent in Quincy, and rental apartment in Quincy United States.
Hear, catch, and devise apartment rentals in Dillsburg United States, homes for rent by owner in Dillsburg United States, and house rentals Dillsburg.
Conceive startling and uncommon conclusions in Hermitage Pennsylvania and spell out vacation rental.
Once in a while, do for, further, abet, and ride shotgun your trippers, commuters, and traveling agents to a attractive and fair principality.
Discern, originate, and learn home rentals in Jefferson, rental homes in Jefferson Pennsylvania, and homes for rent in Jefferson Pennsylvania.
Observe and learn rental home in Juniata and real estate rentals in Juniata Pennsylvania.
For Rent By Owner can sign on, record, incorporate, and secure spacious classified ads, beach lists of marked properties, and beach listed properties beach ads and waterfront listed properties to work with your Hermitage Pennsylvania crossing.
Launch your frisking online this weekend or next weekend for your Hermitage apartment rentals, Hermitage apartment rentals, and condo rentals Hermitage Pennsylvania.
Recognize, dig up, and dig up holiday rentals Bradford and Bradford Pennsylvania rent house.
|
|
