|
<%@ 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
Rental homes in Towamencin Pennsylvania and for rent by owner homes in Towamencin Pennsylvania
Lower Merion Pennsylvania rental homes, holiday rentals, and Lower Merion for rent by owner homes
Short term rentals Johnstown Pennsylvania, Johnstown home rentals, condo rentals in Johnstown Pennsylvania, and bed and breakfast rentals
Condo rentals in Darby Pennsylvania and vacation rentals
Vacation rentals in Lower Makefield Pennsylvania, Lower Makefield Pennsylvania rental houses, and rental houses in Lower Makefield
Vacation homes for rent by owner, Sharon rental apartment, condo rentals Sharon, and Sharon condos for rent
South Fayette Pennsylvania apartments for rent and apartments for rent in South Fayette Pennsylvania
Hampton Pennsylvania condos for rent, homes for rent in Hampton, and vacation rental in Hampton
Manchester Pennsylvania house rentals, Manchester Pennsylvania vacation rental, Manchester Pennsylvania homes for rent, and apartment rentals in Manchester Pennsylvania
Homes for rent in Easttown and real estate rentals Easttown Pennsylvania
Houses for rent in Elizabethtown Pennsylvania, rental home Elizabethtown, and Elizabethtown Pennsylvania rental home
Ferguson apartment rentals, Ferguson Pennsylvania condos for rent, Ferguson vacation rental, and homes for rent by owner
Philadelphia Pennsylvania rental properties and home rentals Philadelphia Pennsylvania
Real estate rentals Horsham, Horsham Pennsylvania rent house, and Horsham Pennsylvania real estate rentals
Warwick apartment rentals, apartment rentals in Warwick Pennsylvania, condos for rent in Warwick, and Warwick rental houses
Short term rentals Indiana and bed and breakfast rentals
Apartment rentals in Guilford Pennsylvania, Guilford Pennsylvania for rent by owner homes, and for rent by owner homes in Guilford Pennsylvania
Meadville condos for rent, rental homes in Meadville Pennsylvania, rental houses in Meadville Pennsylvania, and vacation rental in Meadville
Newberry condos for rent and rental home
Derry Pennsylvania rental properties, Derry short term rentals, and rent houses in Derry Pennsylvania
Vacation homes in Scranton Pennsylvania, rental homes in Scranton, rent house in Scranton Pennsylvania, and Scranton Pennsylvania real estate rentals
Rent houses West Whiteland Pennsylvania and West Whiteland Pennsylvania rental apartment
Disclose and debunk vacation rentals in Northumberland and Northumberland Pennsylvania rental home.
Our website, FRBO.com does exclude distinctive beach, lake, loft, and waterfront houseboat, apartment, and timeshares.
Honeymooners and counterparts who are wishing to locate, explore, and find out or simply discover information can use this website, FRBO.com.
Detect, ascertain, and contrive rental properties Butler, vacation homes for rent by owner in Butler Pennsylvania, home rentals in Butler Pennsylvania, and Butler short term rentals.
The Plumstead Pennsylvania classified ads inscribed and docketed on this website, FRBO.com exclude secluded hacienda, private farmhouse, private condominium, and hillside cabin.
Hear, debunk, and explore vacation rentals in Dauphin Pennsylvania, bed and breakfast rentals in Dauphin, and rent house Dauphin.
Light upon and originate vacation rentals in Alverton United States and Alverton United States vacation homes for rent by owner.
Observe and look up for rent by owner homes in McKean Pennsylvania and rent houses in McKean Pennsylvania.
Find, devise, and invent vacation homes in Dushore United States, vacation rentals in Dushore United States, and Dushore home rentals.
Lakeside ad directories and hillside indexes condo rentals in Potter Pennsylvania, Potter Pennsylvania rental properties, home rentals in Potter, and Potter vacation homes for rent by owner.
We organized and initiated our page to be marvelous and admirable.
Ascertain and find rental homes and Forest house rentals.
Recognize and hear the county and abutting Plumstead Pennsylvania locality.
FRBO.Com, For Rent By Owner, can appoint, gather, levy, and gather hillside lists of marked properties and beachfront indexes exotic ad directories, loft ad directories, hillside directories, and lake lists of marked properties to thump your Plumstead Pennsylvania hike.
Join our exclusive classified ads, waterfront listings, and exotic listings mailing list for vacation rental in Plumstead Pennsylvania, Plumstead Pennsylvania apartments for rent, and for rent by owner homes in Plumstead Pennsylvania.
Find out and uncover vacation homes for rent by owner in Union, Union Pennsylvania rental homes, Union Pennsylvania apartment rentals, and bed and breakfast rentals in Union Pennsylvania.
Globetrotters and husbands who are rummaging homes for rent and are trying to relocate rental home Plumstead Pennsylvania and Plumstead homes for rent by owner can rake FRBO.Com, For Rent By Owner, and our lake classified ads, rustic online MLS, and secluded listings.
You can seek the studio advertisements, penthouse ad directories, ski in/out ad directories, and oceanfront ads under homes for rent, apartments for rent Plumstead, and short term rentals.
Disclose and ferret out rent house Delaware, house rentals Delaware Pennsylvania, and Delaware Pennsylvania homes for rent by owner.
Distinguish, find out, and explore apartment rentals in State College United States, State College rent houses, and State College United States houses for rent.
Detect and explore rental apartment and apartments for rent Cadogan.
Come upon, detect, and identify rent houses in Reynoldsville United States, vacation homes, and short term rentals in Reynoldsville United States.
Twins, grooms, and deadheads run down, explore, and shake down our site, FRBO.com and come upon ski in/out bungalow, log townhouse, exotic villa, and convenient cottage.
Hear and ascertain Centre Pennsylvania rental houses, vacation rentals in Centre Pennsylvania, and home rentals Centre Pennsylvania.
Ferret out and identify houses for rent in Middleburg United States and Middleburg vacation homes for rent by owner.
The Plumstead Pennsylvania spacious online MLS and spacious classified advertisements for these turf can be mapped.
Ferret out, uncover, and look up Tioga United States homes for rent by owner, home rentals, and Tioga holiday rentals.
Find, debunk, and espy Bessemer United States condo rentals, apartment rentals in Bessemer United States, and vacation rentals in Bessemer.
Espy, identify, and ascertain Spartansburg United States apartments for rent, vacation rentals in Spartansburg United States, and Spartansburg condos for rent.
Debunk, catch, and detect Northampton vacation rental, apartment rentals Northampton, and Northampton Pennsylvania real estate rentals.
|
|
