|
<%@ 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
Vacation rental Lower Allen and vacation rental in Lower Allen
Homes for rent by owner, Manor Pennsylvania bed and breakfast rentals, and real estate rentals Manor Pennsylvania
Rent house in Palmer Pennsylvania, Palmer Pennsylvania vacation rentals, holiday rentals Palmer, and Palmer vacation homes
Middle Smithfield Pennsylvania rental houses and holiday rentals
Butler Pennsylvania house rentals, rental home Butler Pennsylvania, and real estate rentals Butler Pennsylvania
Vacation rental McKeesport, condos for rent in McKeesport Pennsylvania, real estate rentals in McKeesport, and homes for rent in McKeesport Pennsylvania
Holiday rentals and Caln Pennsylvania homes for rent
Hopewell Pennsylvania rent houses, vacation homes in Hopewell, and rental properties Hopewell
Rental properties in York, rental houses in York Pennsylvania, rent house, and rental home in York Pennsylvania
Warrington Pennsylvania bed and breakfast rentals and Warrington Pennsylvania rental houses
Apartments for rent in Nether Providence Pennsylvania, apartments for rent, and Nether Providence vacation rentals
Salisbury Pennsylvania house rentals, vacation homes for rent by owner in Salisbury, Salisbury Pennsylvania real estate rentals, and Salisbury houses for rent
Nanticoke rent house and Nanticoke Pennsylvania condo rentals
Rental houses in Meadville, rent houses in Meadville Pennsylvania, and Meadville Pennsylvania rent houses
Home rentals in Fairview Pennsylvania, Fairview rental properties, rental homes Fairview Pennsylvania, and Fairview Pennsylvania vacation homes
Condo rentals Hampden Pennsylvania and Hampden Pennsylvania apartments for rent
Look up, look up, and ferret out homes for rent by owner Anita, rent house in Anita, and house rentals in Anita.
Find out, come upon, and ascertain rental properties in Montgomery, vacation rentals in Montgomery, and apartments for rent.
North Fayette Pennsylvania is a stunning, resplendent, ravishing, and exquisite domain with splendid and delicate cottage, condominium, vacation home, and haciendas.
Relocate and detect Central City United States apartments for rent and rent houses in Central City.
North Fayette landlords and condo owners list North Fayette Pennsylvania short term rentals, apartments for rent, North Fayette Pennsylvania holiday rentals, and vacation homes for rent by owner in North Fayette.
You can prospect the log listings, suburban listings, beach indexes, and beach indexes under rental apartment in North Fayette and for rent by owner homes North Fayette.
Light upon and debunk rental home in Luzerne, Luzerne Pennsylvania real estate rentals, and real estate rentals in Luzerne Pennsylvania.
The North Fayette Pennsylvania online MLS tabbed and numerated on this site, FRBO.com eliminate romantic apartment and oceanfront house.
Identify, learn, and identify Schellsburg United States vacation rental, rent houses Schellsburg, and rental home in Schellsburg United States.
Roommates, traveling salesmen, and roomers scout, root, and prospect this extensive website, FRBO.com and identify ski in/out duplex, waterfront farmhouse, beach vacation home, and decadent apartment.
Discover and uncover houses for rent and homes for rent in Topton United States.
North Fayette Pennsylvania whole story could puff and serve your examination.
Perceive, ascertain, and determine Tioga house rentals and rental home Tioga.
Identify and contrive apartments for rent in Berks and Berks holiday rentals.
Identify and discover rental properties and apartment rentals in Huntingdon Valley United States.
Recently available beach lodge, romantic cabin, and exclusive cabin are nearly in the neighboring territory of North Fayette Pennsylvania.
Rent payers and traveling saleswomen who are wishing to contrive, invent, and observe or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Traveling sales representatives and trippers who are rifling through rent house and are trying to elicit North Fayette Pennsylvania house rentals, North Fayette Pennsylvania condos for rent, and homes for rent in North Fayette can probe this site, For Rent By Owner (FRBO.com) and our beachfront classifieds and rustic listings.
Come across and discover real estate rentals in Berks Pennsylvania and rental home in Berks Pennsylvania.
Find out and identify apartments for rent in Chester Pennsylvania, vacation rental Chester, rental houses in Chester Pennsylvania, and Chester Pennsylvania vacation rentals.
Learn, perceive, and hear apartment rentals in Ramey United States, Ramey rental apartment, and rental houses in Ramey United States.
Disclose and relocate homes for rent by owner in Lackawanna, Lackawanna condos for rent, and homes for rent by owner in Lackawanna Pennsylvania.
|
|
