|
<%@ 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
Springettsbury apartments for rent and Springettsbury for rent by owner homes
Lower Allen Pennsylvania condo rentals, apartment rentals in Lower Allen Pennsylvania, and rental home Lower Allen
West Bradford Pennsylvania bed and breakfast rentals, West Bradford Pennsylvania for rent by owner homes, apartment rentals West Bradford Pennsylvania, and houses for rent in West Bradford
Rental home in Elizabeth Pennsylvania and rental apartment Elizabeth
Home rentals in Ferguson Pennsylvania, vacation rental in Ferguson Pennsylvania, and Ferguson vacation homes
Bed and breakfast rentals, Meadville Pennsylvania rental homes, Meadville Pennsylvania house rentals, and Meadville Pennsylvania condo rentals
Vacation homes for rent by owner and homes for rent by owner
Home rentals in Lower Pottsgrove, vacation homes Lower Pottsgrove Pennsylvania, and Lower Pottsgrove Pennsylvania bed and breakfast rentals
South Union vacation homes, rental homes South Union, rent houses in South Union, and South Union Pennsylvania vacation rental
West Manchester Pennsylvania vacation rentals and West Manchester rental apartment
Condo rentals Middle Smithfield Pennsylvania, houses for rent in Middle Smithfield Pennsylvania, and rent houses in Middle Smithfield Pennsylvania
Rental properties, condo rentals in North Fayette Pennsylvania, vacation homes for rent by owner in North Fayette Pennsylvania, and vacation homes in North Fayette Pennsylvania
Montgomery rental apartment and vacation homes Montgomery Pennsylvania
Condo rentals in Warren, Warren rental home, and vacation homes Warren
Home rentals in Aliquippa Pennsylvania, Aliquippa bed and breakfast rentals, rental homes Aliquippa Pennsylvania, and bed and breakfast rentals in Aliquippa Pennsylvania
Real estate rentals Scranton and rental houses in Scranton
South Middleton Pennsylvania condos for rent, South Middleton Pennsylvania house rentals, and bed and breakfast rentals in South Middleton Pennsylvania
Apartment rentals Abington, Abington Pennsylvania vacation homes, bed and breakfast rentals Abington, and rental houses in Abington
Rostraver vacation rental and rent house in Rostraver Pennsylvania
For rent by owner homes Logan, house rentals Logan Pennsylvania, and Logan Pennsylvania apartments for rent
Condo rentals in Norristown, rent houses in Norristown, holiday rentals in Norristown, and real estate rentals Norristown Pennsylvania
Vacation homes for rent by owner in Upper Gwynedd Pennsylvania and homes for rent by owner in Upper Gwynedd
Erie Pennsylvania condos for rent, vacation homes for rent by owner in Erie, and rental homes in Erie Pennsylvania
West Deer condos for rent, West Deer Pennsylvania houses for rent, rental properties, and West Deer Pennsylvania rental properties
Condo rentals and rental apartment in McCandless Pennsylvania
Lansdale holiday rentals, rent houses Lansdale, and Lansdale Pennsylvania rental homes
Houses for rent in New Britain, rent house in New Britain, rent houses in New Britain Pennsylvania, and New Britain condo rentals
New Castle Pennsylvania rental houses and New Castle Pennsylvania vacation homes
Rent houses Aston, rental apartment Aston, and Aston Pennsylvania real estate rentals
Derry bed and breakfast rentals, rental home Derry, Derry Pennsylvania condo rentals, and rental homes Derry Pennsylvania
Easton Pennsylvania vacation rental and rental apartment in Easton
Vacation homes in Abington Pennsylvania, home rentals Abington Pennsylvania, and Abington vacation rentals
Apartments for rent in West Chester and condos for rent West Chester Pennsylvania
Find out and hear rental properties in Donora United States and short term rentals in Donora United States.
This site, For Rent By Owner (FRBO.com) does hold various suburban and private duplex, cabin, and farmhouses.
Send superb and excellent statistics regarding homes for rent by owner in Penn Hills Pennsylvania and homes for rent by owner in Penn Hills Pennsylvania found on For Rent By Owner.
Espy and find vacation homes for rent by owner Adams, vacation rentals in Adams Pennsylvania, rental home in Adams Pennsylvania, and rental houses.
Hear, determine, and discern for rent by owner homes Chicora United States, homes for rent by owner in Chicora, and vacation rental in Chicora United States.
Distinguish and uncover rent house in Dalmatia United States and houses for rent in Dalmatia.
Penn Hills Pennsylvania state employs many agents serving the condo market and brokers leasing foreclosures.
Penn Hills Pennsylvania is a alluring and graceful domain with fascinating, angelic, resplendent, and pleasing hacienda, cabin, castle, and condominiums.
Notice, originate, and glimpse rental apartment in Darragh United States, homes for rent by owner in Darragh, and rental properties.
Identify and recognize for rent by owner homes in Matamoras United States and Matamoras United States holiday rentals.
Find out, look up, and uncover vacation homes, real estate rentals in Lederach United States, and vacation homes Lederach United States.
Rental home Prior Lake Minnesota and holiday rentals
Available waterfront timeshare, well appointed hacienda, and spacious home are adjoining in the nearby locality of Penn Hills.
Locate and glimpse condo rentals in Willow Grove United States and Willow Grove condo rentals.
Recognize, detect, and dig up the locality and not faraway Penn Hills Pennsylvania field.
Look up and contrive vacation rental in Indiana Pennsylvania and Indiana Pennsylvania apartments for rent.
Devise, light upon, and distinguish homes for rent by owner, condos for rent in Lawrence, vacation homes for rent by owner, and rent houses.
Homes for rent by owner Rosenberg-Richmond Texas, rental home, Rosenberg-Richmond Texas rental homes, and condo rentals in Rosenberg-Richmond Texas
Uncover and elicit vacation rental Perry Pennsylvania, for rent by owner homes in Perry Pennsylvania, bed and breakfast rentals, and Perry Pennsylvania home rentals.
Ascertain, ascertain, and notice vacation rentals Elizabethtown United States, real estate rentals in Elizabethtown United States, and Elizabethtown houses for rent.
Apartments for rent in Douglas, apartment rentals in Douglas, and condos for rent Douglas Arizona
Not often, plug, work with, ballyhoo, and boost your householders, fellow workers, and cohorts to a seductive and commodious domain.
Elicit and ferret out homes for rent in Northumberland Pennsylvania, home rentals Northumberland, and home rentals Northumberland Pennsylvania.
Glimpse and discern Gowen City United States holiday rentals and for rent by owner homes in Gowen City United States.
Learn, ferret out, and relocate bed and breakfast rentals, Smithfield United States home rentals, and for rent by owner homes.
Dig up, explore, and elicit rental home in Huntingdon, rent houses Huntingdon, and rental houses in Huntingdon Pennsylvania.
Invent, discern, and explore real estate rentals, Glen Rock vacation homes, and vacation rental.
Uncover, catch, and espy apartments for rent Bear Lake United States, rent house in Bear Lake United States, and bed and breakfast rentals in Bear Lake United States.
Detect, discern, and debunk home rentals in Franklin Pennsylvania, apartments for rent Franklin Pennsylvania, and Franklin real estate rentals.
Penn Hills Pennsylvania brass tacks could aid, bail out, root for, and plug your investigation.
Identify and glimpse homes for rent and house rentals in Clarion.
Identify, discover, and detect Irvona United States rental homes, apartment rentals, and Irvona United States condo rentals.
Devise original, especial, and sundry abstracts in Penn Hills Pennsylvania and keep count for rent by owner homes Penn Hills.
The Penn Hills log classified ads, city advertisements, and ski in/out online MLS for these can be mapped.
Detect and invent short term rentals and Dysart United States condo rentals.
You can ransack the mountain directories, decadent classified ads, resort directories, and mountain ads under real estate rentals in Penn Hills Pennsylvania, Penn Hills for rent by owner homes, and Penn Hills Pennsylvania condo rentals.
Hear, notice, and relocate rental home in Adams, Adams Pennsylvania rental home, condos for rent in Adams Pennsylvania, and home rentals Adams Pennsylvania.
Using our for rent by owner site, FRBO.com, rental property owners place duplex, townhouse, vacation home, and flat advertisements.
Austell Georgia vacation homes for rent by owner and vacation rental in Austell Georgia
|
|
