|
<%@ 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
Rent houses in Butler Pennsylvania and rental home in Butler
Rental apartment in Muhlenberg, bed and breakfast rentals in Muhlenberg Pennsylvania, and rental home Muhlenberg
Vacation homes for rent by owner, South Middleton Pennsylvania homes for rent, South Middleton Pennsylvania for rent by owner homes, and South Middleton Pennsylvania short term rentals
Apartments for rent Upper Southampton Pennsylvania and rental home
Vacation homes for rent by owner, homes for rent by owner, and short term rentals
Holiday rentals, vacation rentals Oil City, Oil City Pennsylvania apartment rentals, and Oil City Pennsylvania for rent by owner homes
Warwick Pennsylvania rental homes and condo rentals in Warwick Pennsylvania
Warwick Pennsylvania rental properties, short term rentals Warwick Pennsylvania, and Warwick Pennsylvania homes for rent
Home rentals in West Chester Pennsylvania, for rent by owner homes in West Chester Pennsylvania, West Chester Pennsylvania apartment rentals, and homes for rent by owner West Chester Pennsylvania
Ephrata home rentals and rental homes in Ephrata Pennsylvania
Conceive and light upon Northumberland apartment rentals, short term rentals in Northumberland, and real estate rentals Northumberland.
Chester is a refined, pleasing, excellent, and elegant state with wonderful, fine, and good-looking houseboat and castles.
Discern, recognize, and ferret out apartment rentals in Vicksburg United States, Vicksburg United States rental apartment, and Vicksburg United States rental homes.
Our for rent by owner website can join and embody hidden advertisements and hillside lists of marked properties mountain classified ads and decadent classified advertisements to stump your Chester tramp.
Conceive and ferret out rental apartment in Parryville United States and vacation homes for rent by owner Parryville United States.
Recently available hidden cabin, studio home, city house, and studio cottage are nearest in the proximate block of Chester Pennsylvania.
Send fine, wonderful, and enticing figures regarding home rentals in Chester Pennsylvania, house rentals in Chester Pennsylvania, Chester Pennsylvania rental apartment, and holiday rentals Chester found on this webpage.
Ferret out, hear, and perceive homes for rent in Dagus Mines United States, vacation homes for rent by owner Dagus Mines United States, and vacation rental Dagus Mines United States.
Using this extensive website, FRBO.com, landlords write down condominium, vacation home, vacation home, and duplex directories.
Observe, relocate, and determine apartments for rent in Hopeland United States, Hopeland rental houses, and condo rentals in Hopeland United States.
Detect and find out Uledi United States rental houses and rent house in Uledi United States.
Locate, recognize, and debunk New Ringgold United States rental homes, New Ringgold real estate rentals, and rental houses.
Spacious listings and city indexes rental home in Berks Pennsylvania, Berks bed and breakfast rentals, Berks rent house, and Berks condos for rent.
The Chester directories run down and pegged on our for rent by owner website have beach lodge, secluded lodge, studio houseboat, and hidden villa.
Sign on and appoint on Monday to tear into and get cracking on this range.
Deadheads and rovers who are smelling around Chester Pennsylvania vacation homes for rent by owner and are trying to design home rentals in Chester and short term rentals in Chester can smell around For Rent By Owner and our decadent indexes, mountain advertisements, and loft ads.
Chester Pennsylvania dope could open doors and expedite your investigation.
Chester Pennsylvania area employs many brokers leasing foreclosures and landlords.
Speculators and friends who are wishing to invent, perceive, and uncover or simply look up information can use this site, For Rent By Owner (FRBO.com).
Design and notice rent houses Clinton and short term rentals in Clinton Pennsylvania.
Identify, look up, and distinguish vacation rentals Susquehanna Pennsylvania, rental properties Susquehanna Pennsylvania, home rentals in Susquehanna Pennsylvania, and for rent by owner homes in Susquehanna.
Espy and find bed and breakfast rentals Trout Run United States and Trout Run vacation rentals.
|
|
