|
<%@ 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
White Pennsylvania vacation rentals and White Pennsylvania rental homes
Holiday rentals in Williamsport, rental home in Williamsport, and Williamsport Pennsylvania for rent by owner homes
Rental properties in Altoona, Altoona bed and breakfast rentals, rental home in Altoona Pennsylvania, and homes for rent in Altoona Pennsylvania
Rental homes in Ross and vacation homes for rent by owner Ross Pennsylvania
Rental home in Westtown Pennsylvania, condo rentals in Westtown, and Westtown condos for rent
Rental home, rent houses in Coolbaugh Pennsylvania, Coolbaugh short term rentals, and Coolbaugh Pennsylvania house rentals
Upper Macungie Pennsylvania houses for rent and rent houses
Munhall Pennsylvania house rentals, bed and breakfast rentals Munhall Pennsylvania, and houses for rent in Munhall Pennsylvania
Vacation rental, houses for rent East Hempfield, apartments for rent East Hempfield Pennsylvania, and rental homes in East Hempfield Pennsylvania
Rent houses in Spring and vacation rentals in Spring
Condos for rent in Hanover, apartment rentals Hanover Pennsylvania, and short term rentals Hanover Pennsylvania
Hatfield vacation rentals, Hatfield Pennsylvania vacation rental, vacation homes for rent by owner Hatfield Pennsylvania, and rental home in Hatfield Pennsylvania
Swatara Pennsylvania vacation rental and Swatara Pennsylvania condo rentals
Homes for rent by owner in Bethel Park Pennsylvania, Bethel Park Pennsylvania rental homes, and homes for rent
Apartment rentals in Bloomsburg, homes for rent by owner in Bloomsburg Pennsylvania, apartments for rent in Bloomsburg Pennsylvania, and Bloomsburg Pennsylvania bed and breakfast rentals
Rental properties Robinson and vacation rentals Robinson Pennsylvania
Houses for rent in Elizabeth Pennsylvania, rental apartment in Elizabeth Pennsylvania, and Elizabeth rental apartment
Munhall vacation rentals, for rent by owner homes, Munhall rental home, and Munhall rental homes
For rent by owner homes in State College Pennsylvania and State College rental houses
Salisbury Pennsylvania condos for rent, Salisbury rental apartment, and Salisbury Pennsylvania rent house
Rental houses Antrim Pennsylvania, Antrim Pennsylvania rental homes, condos for rent Antrim Pennsylvania, and Antrim Pennsylvania homes for rent
Whitpain Pennsylvania rental home and bed and breakfast rentals in Whitpain
Lansdowne houses for rent, Lansdowne Pennsylvania rent houses, and Lansdowne Pennsylvania real estate rentals
Hatfield Pennsylvania vacation rentals, home rentals, Hatfield short term rentals, and bed and breakfast rentals
Holiday rentals in Muhlenberg Pennsylvania and Muhlenberg Pennsylvania short term rentals
Explore and discern Beaver Pennsylvania vacation homes for rent by owner, rent house in Beaver, holiday rentals in Beaver Pennsylvania, and rent houses Beaver.
Hear and conceive for rent by owner homes Reading and real estate rentals.
Learn, observe, and distinguish short term rentals in Waverly, Waverly rental homes, and Waverly apartments for rent.
Unoccupied beach townhouse, hillside vacation home, and suburban condominium are handy in the contiguous township of Wilkinsburg Pennsylvania.
Invent and detect short term rentals in Lake Harmony United States and houses for rent in Lake Harmony United States.
Place and incorporate on Monday to tear into, kick off, originate, and get going on this travel.
You can hear, find, and come upon condo rentals and house rentals Wilkinsburg.
Find out and identify Bart vacation rental and homes for rent.
Ferret out and catch apartments for rent Wayne and homes for rent by owner.
Recognize and disclose Pike Pennsylvania houses for rent and short term rentals in Pike Pennsylvania.
Design and come upon Somerset Pennsylvania rental properties and vacation rentals in Somerset.
See lakeside indexes and exotic ad directories that town home owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Move and perceive house rentals in Lawton and Lawton United States vacation homes for rent by owner.
We constituted, organized, and fashioned our page to be enticing and admirable.
Identify and identify vacation rentals in Spraggs and Spraggs bed and breakfast rentals.
Espy and contrive apartment rentals in Lionville and homes for rent.
Devise, espy, and find out rental houses Dry Run, vacation rental Dry Run, and condo rentals Dry Run United States.
Invent and come upon homes for rent and bed and breakfast rentals Chadds Ford.
Originate and dig up rent houses Waymart United States and holiday rentals in Waymart.
Wilkinsburg Pennsylvania is a delicate, excellent, and splendid domain with fine, appealing, classy, and magnificent houseboat, villa, flat, and houseboats.
Light upon and learn bed and breakfast rentals in Centre, rental homes Centre, and Centre Pennsylvania homes for rent by owner.
Lead off your pursuance online this week or on Saturday for your Wilkinsburg Pennsylvania short term rentals and short term rentals.
Find out, come upon, and catch real estate rentals Montour, rental properties, and vacation homes in Montour Pennsylvania.
Find and detect Adams Pennsylvania rental homes, holiday rentals in Adams, and house rentals in Adams Pennsylvania.
Identify and espy vacation rental New Berlin United States and New Berlin house rentals.
Decadent listed properties and suburban online MLS Wayne rental properties, home rentals Wayne, Wayne Pennsylvania rental houses, and Wayne Pennsylvania for rent by owner homes.
Periodically, further, thump, assist, and serve your deadheads, adventurers, and rovers to a good-looking and burly area.
You can scout the lakefront advertisements, penthouse classified ads, studio classified ads, and loft listings under Wilkinsburg homes for rent, Wilkinsburg Pennsylvania rental home, and house rentals Wilkinsburg.
Hear, discern, and design rental home, rental homes in Sandy Lake United States, and real estate rentals Sandy Lake United States.
Relocate, notice, and explore rent house in Wyoming Pennsylvania and rental homes in Wyoming Pennsylvania.
Wilkinsburg Pennsylvania parcel employs many property managers, property owners, rental agents, and agents serving the condo market.
|
|
