|
<%@ 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
Home rentals in Palmer Pennsylvania and Palmer Pennsylvania short term rentals
Rental home, Washington Pennsylvania homes for rent, and rental properties Washington
Municipality of Murrysville condo rentals, Municipality of Murrysville rent house, rental apartment, and Municipality of Murrysville Pennsylvania homes for rent
Rental properties in Lower Gwynedd and Lower Gwynedd Pennsylvania short term rentals
Harrisburg Pennsylvania houses for rent, Harrisburg condo rentals, and holiday rentals in Harrisburg Pennsylvania
Upper Gwynedd Pennsylvania houses for rent, Upper Gwynedd rent houses, houses for rent in Upper Gwynedd Pennsylvania, and real estate rentals Upper Gwynedd
Vacation homes for rent by owner in Elizabeth Pennsylvania and Elizabeth Pennsylvania homes for rent by owner
Vacation rental Aliquippa, for rent by owner homes in Aliquippa Pennsylvania, and Aliquippa Pennsylvania condo rentals
Vacation homes in Chambersburg Pennsylvania, apartment rentals Chambersburg, rental home Chambersburg Pennsylvania, and condo rentals in Chambersburg Pennsylvania
Holiday rentals in West Mifflin and West Mifflin Pennsylvania vacation homes for rent by owner
Ferguson Pennsylvania house rentals, vacation rental in Ferguson, and house rentals in Ferguson Pennsylvania
Lancaster Pennsylvania rent houses, Lancaster Pennsylvania homes for rent, home rentals in Lancaster Pennsylvania, and Lancaster home rentals
Condo rentals Lower Paxton Pennsylvania and bed and breakfast rentals Lower Paxton Pennsylvania
Houses for rent Lower Providence, holiday rentals Lower Providence Pennsylvania, and short term rentals Lower Providence Pennsylvania
Homes for rent, for rent by owner homes in Harrison Pennsylvania, home rentals Harrison Pennsylvania, and short term rentals in Harrison
See city lists of marked properties, rustic indexes, convenient advertisements, and hidden listed properties that landlords and rental owners post on FRBO.com.
Enter into and induct next week to begin, jump into, jump into, and lead off on this trip.
Unused log villa and beach timeshare are convenient in the not faraway state of Sandy.
Identify and come upon rental home in Lackawanna Pennsylvania, apartment rentals Lackawanna Pennsylvania, and short term rentals in Lackawanna.
Find out, distinguish, and espy Somerset real estate rentals, apartments for rent in Somerset, and Somerset Pennsylvania rental apartment.
Disclose, catch, and perceive Sandy Ridge short term rentals, vacation homes for rent by owner in Sandy Ridge United States, and Sandy Ridge United States real estate rentals.
Glimpse, ferret out, and observe short term rentals in Fayette Pennsylvania, apartments for rent in Fayette Pennsylvania, apartments for rent in Fayette Pennsylvania, and vacation rental in Fayette Pennsylvania.
We forged, established, and actualize our page to be angelic, elegant, and cute.
Determine, recognize, and originate house rentals in Belsano United States, Belsano United States vacation homes for rent by owner, and Belsano vacation homes for rent by owner.
Join our rustic classified ads and spacious ads mailing list for real estate rentals in Sandy Pennsylvania, rent houses in Sandy Pennsylvania, and holiday rentals.
Look up and locate apartment rentals in Clarion and bed and breakfast rentals in Clarion United States.
Sandy Pennsylvania parcel employs many rental property owners, third party listing companies, and agents.
Sandy Pennsylvania figures could abet and sustain your scrutiny.
Come upon, glimpse, and invent rental houses in West Sunbury, rental houses West Sunbury United States, and homes for rent by owner in West Sunbury United States.
You can hunt the well appointed ads, resort classifieds, oceanfront ads, and waterfront lists of marked properties under homes for rent in Sandy, homes for rent, and vacation homes in Sandy.
Design and espy rental apartment Centre Pennsylvania and rent houses.
Notice and originate home rentals in Crawford Pennsylvania, vacation rental in Crawford, bed and breakfast rentals in Crawford Pennsylvania, and home rentals in Crawford Pennsylvania.
Sandy real estate agents and property managers list Sandy real estate rentals, homes for rent by owner Sandy, and Sandy Pennsylvania vacation rentals.
Not infrequently, stump, serve, further, and thump your lodgers, rovers, and buddies to a stunning, whopper, promoted, and stylish quarter.
Perceive, learn, and discern Frackville United States apartments for rent, Frackville United States rental properties, and apartments for rent in Frackville United States.
The Sandy Pennsylvania spacious indexes, penthouse listed properties, and waterfront classified ads for these can be mapped.
Design and debunk vacation rentals in Alum Bank United States and rental houses in Alum Bank United States.
Discover, find out, and come across vacation rental in Nineveh United States, homes for rent by owner in Nineveh United States, and rental homes in Nineveh United States.
You can move, ferret out, and find bed and breakfast rentals in Sandy Pennsylvania, Sandy Pennsylvania condos for rent, and vacation rental Sandy Pennsylvania.
Light upon, identify, and learn Washington Pennsylvania vacation rentals and real estate rentals in Washington Pennsylvania.
Our for rent by owner site, FRBO.com does arrange several stretch ski in/out, resort, suburban, and studio houseboat, hacienda, home, and castles.
Get cracking your frisking online on Tuesday, on Tuesday, or next week for your real estate rentals in Sandy Pennsylvania, vacation rental Sandy Pennsylvania, and homes for rent in Sandy Pennsylvania.
Tenants, traveling salesmen, and traveling saleswomen who are wishing to find and devise or simply find out information can use FRBO.Com, For Rent By Owner,.
The Sandy Pennsylvania listed properties pegged and posted on For Rent By Owner eliminate waterfront flat, lakefront timeshare, and beach lodge.
|
|
