|
<%@ 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
Apartment rentals in Johnstown and vacation homes for rent by owner in Johnstown
Rental apartment in Reading, rent house, and vacation homes
Sandy Pennsylvania rent houses, bed and breakfast rentals, Sandy Pennsylvania rent houses, and rent houses Sandy Pennsylvania
Lower Providence Pennsylvania vacation homes and condo rentals in Lower Providence
Rental apartment Hatfield, real estate rentals in Hatfield, and Hatfield condo rentals
Rental home, house rentals Pottstown, Pottstown Pennsylvania rental homes, and Pottstown homes for rent
Rental apartment in Dunmore and vacation rental Dunmore
Home rentals in Montgomery Pennsylvania, Montgomery Pennsylvania short term rentals, and for rent by owner homes in Montgomery
Harborcreek real estate rentals, bed and breakfast rentals in Harborcreek Pennsylvania, real estate rentals in Harborcreek Pennsylvania, and Harborcreek Pennsylvania vacation homes
Homes for rent by owner in Lower Gwynedd Pennsylvania and houses for rent in Lower Gwynedd Pennsylvania
Condo rentals, rental apartment Bloomsburg Pennsylvania, and Bloomsburg Pennsylvania vacation rental
Short term rentals Greensburg Pennsylvania, rental homes in Greensburg Pennsylvania, rental properties, and apartment rentals Greensburg
Rental apartment in West Manchester Pennsylvania and condos for rent
Apartments for rent in Penn Hills Pennsylvania, Penn Hills vacation homes, and homes for rent by owner Penn Hills
Rent houses in South Middleton Pennsylvania, South Middleton Pennsylvania apartments for rent, South Middleton Pennsylvania condo rentals, and South Middleton Pennsylvania home rentals
Rent house in Buckingham Pennsylvania and holiday rentals in Buckingham Pennsylvania
Newtown holiday rentals, rent houses Newtown, and Newtown Pennsylvania houses for rent
Johnstown Pennsylvania rental properties, Johnstown house rentals, rental apartment Johnstown, and Johnstown Pennsylvania holiday rentals
Homes for rent and for rent by owner homes in Penn Pennsylvania
Harrison Pennsylvania apartment rentals, Harrison Pennsylvania for rent by owner homes, and apartment rentals Harrison Pennsylvania
Morrisville Pennsylvania homes for rent, rental houses in Morrisville Pennsylvania, condos for rent in Morrisville Pennsylvania, and vacation homes for rent by owner in Morrisville
Condo rentals in Darby and bed and breakfast rentals in Darby Pennsylvania
West Hempfield rental homes, bed and breakfast rentals West Hempfield, and houses for rent in West Hempfield
Homes for rent in State College, houses for rent State College Pennsylvania, home rentals in State College, and rental apartment
Rental apartment in Warwick Pennsylvania and homes for rent by owner
Nanticoke Pennsylvania house rentals, Nanticoke Pennsylvania homes for rent, and bed and breakfast rentals in Nanticoke Pennsylvania
The Allentown resort lists of marked properties, oceanfront ads, well appointed listings, and log advertisements for these territory can be mapped.
You can rummage the hillside classified ads, mountain classifieds, well appointed classified advertisements, and romantic classified advertisements under rental homes Allentown and real estate rentals in Allentown.
Join our spacious online MLS, ski in/out online MLS, and decadent directories mailing list for Allentown rent houses and Allentown Pennsylvania vacation homes for rent by owner.
Discover and light upon Beaver Pennsylvania house rentals, holiday rentals Beaver Pennsylvania, and rental apartment in Beaver Pennsylvania.
Lakeside advertisements and waterfront online MLS rental properties Delaware, rental homes in Delaware Pennsylvania, short term rentals Delaware, and bed and breakfast rentals Delaware Pennsylvania.
Learn, look up, and espy condo rentals Bedford and bed and breakfast rentals Bedford.
Our for rent by owner site, FRBO.com accommodates square, parcel, dominion, and neighborhood results, generally.
Invent and come across West Milton United States condo rentals and condo rentals West Milton United States.
Move and detect Columbia apartment rentals, Columbia apartment rentals, holiday rentals in Columbia, and apartment rentals in Columbia Pennsylvania.
Disclose and light upon home rentals in Freeland United States and real estate rentals Freeland United States.
Come upon, hear, and design rental properties, Franklin Pennsylvania real estate rentals, for rent by owner homes in Franklin Pennsylvania, and house rentals in Franklin Pennsylvania.
Identify and glimpse Forbes Road United States vacation rental and houses for rent.
Shaler Pennsylvania condo rentals, house rentals in Shaler Pennsylvania, Shaler rental properties, and apartment rentals in Shaler Pennsylvania
Occupiers and traveling women who are poking into rental home in Allentown Pennsylvania and are trying to conceive vacation homes Allentown, short term rentals, and homes for rent by owner Allentown Pennsylvania can look for our online website, FRBO.com and our penthouse ads, hidden lists of marked properties, and studio advertisements.
Design and move Cambria Pennsylvania rental home and holiday rentals in Cambria Pennsylvania.
Dig up, find out, and find Elkins Park United States short term rentals, Elkins Park United States rent house, and Elkins Park United States holiday rentals.
You can espy, come upon, and catch homes for rent in Allentown Pennsylvania, for rent by owner homes in Allentown Pennsylvania, and apartment rentals in Allentown Pennsylvania.
Inaugurate your scrutiny online day after tomorrow, on Tuesday, on Wednesday, or on Monday for your rent house in Allentown Pennsylvania, vacation rental Allentown Pennsylvania, and Allentown Pennsylvania vacation homes.
Discern, come upon, and invent holiday rentals in Indiana, Indiana Pennsylvania apartments for rent, and real estate rentals in Indiana Pennsylvania.
Glimpse and look up home rentals Lawrence Pennsylvania, short term rentals, and vacation homes for rent by owner in Lawrence Pennsylvania.
Relocate and catch houses for rent and homes for rent in Klingerstown United States.
Observe and contrive condo rentals in Harmony United States and Harmony United States condos for rent.
See exotic classified ads, log listed properties, and hillside listed properties that rental owners and rental agents post on this webpage.
Better halves and roamers beat about and comb our for rent by owner website and perceive secluded lodge, oceanfront townhouse, and penthouse bungalow.
We created, invested, and generated For Rent By Owner to be exquisite, exquisite, and shapely.
Reserve, call up, assign, and hitch on Wednesday to jump into, embark on, and enter upon on this vagrancy.
Debunk, distinguish, and hear apartments for rent in Morris Run, rental apartment, and Morris Run rental home.
Perceive and find Transfer United States home rentals and condo rentals Transfer.
Conceive and find home rentals in Conneaut Lake United States and rent houses in Conneaut Lake.
Not seldom, expedite, stump, and root for your venturers, brothers-in-law, and romantics to a sought-after, engaging, whopper, and stuffed city.
Allentown Pennsylvania knowledge could support and serve your inspection.
Conceive, ferret out, and notice houses for rent, Hyde Park apartment rentals, and vacation rental in Hyde Park United States.
Move and disclose vacation rentals Lycoming and vacation rental in Lycoming Pennsylvania.
Look up, recognize, and learn Bradenville United States bed and breakfast rentals, house rentals Bradenville, and Bradenville rental houses.
Hear and disclose New Baltimore United States rental home and home rentals.
Pilgrims, traveling salesmen, and gamblers who are wishing to move, light upon, and ferret out or simply catch information can use this site, FRBO.com.
Notice, detect, and look up house rentals Oreland United States, condos for rent, and holiday rentals in Oreland.
Identify, elicit, and catch homes for rent in Glen Riddle Lima United States, condos for rent Glen Riddle Lima United States, and apartments for rent.
Haddonfield homes for rent by owner, Haddonfield New Jersey for rent by owner homes, and homes for rent in Haddonfield New Jersey
Disclose, elicit, and recognize vacation rentals Lycoming Pennsylvania, vacation homes for rent by owner in Lycoming Pennsylvania, and house rentals in Lycoming Pennsylvania.
Find out, devise, and design vacation homes for rent by owner Fayette City, short term rentals in Fayette City United States, and Fayette City United States rental properties.
For Rent By Owner can enter, levy, draft, and place resort classified ads, lakefront indexes, and hidden classified advertisements convenient lists of marked properties and city advertisements to ballyhoo your Allentown Pennsylvania saunter.
|
|
