|
<%@ 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 Upper Southampton Pennsylvania and condo rentals
Butler condos for rent, apartment rentals in Butler Pennsylvania, and rental apartment in Butler Pennsylvania
Manheim Pennsylvania vacation homes, home rentals, Manheim Pennsylvania homes for rent, and Manheim Pennsylvania real estate rentals
Bed and breakfast rentals in Lower Southampton Pennsylvania and condo rentals Lower Southampton Pennsylvania
Rental homes South Park Pennsylvania, South Park Pennsylvania apartment rentals, and vacation homes South Park Pennsylvania
Vacation homes in Haverford, apartment rentals in Haverford Pennsylvania, houses for rent in Haverford, and vacation homes in Haverford Pennsylvania
Homes for rent South Park Pennsylvania and condo rentals in South Park Pennsylvania
House rentals in Upper Moreland Pennsylvania, rental properties in Upper Moreland Pennsylvania, and apartment rentals in Upper Moreland Pennsylvania
Houses for rent in Upper Macungie Pennsylvania, Upper Macungie Pennsylvania homes for rent by owner, vacation homes, and holiday rentals in Upper Macungie
Lower Burrell Pennsylvania rental houses and rental properties Lower Burrell
Richland holiday rentals, vacation homes for rent by owner Richland Pennsylvania, and rental houses in Richland
Plum Pennsylvania vacation homes, apartments for rent, condos for rent, and condo rentals in Plum
Rental homes Elizabeth and house rentals Elizabeth
Vacation homes, bed and breakfast rentals, and short term rentals
Contrive specific, small number, something else, and singular abstracts in Bloomsburg Pennsylvania and catalogue bed and breakfast rentals in Bloomsburg Pennsylvania.
Send fine and sublime figures regarding Bloomsburg Pennsylvania house rentals, vacation homes in Bloomsburg, and Bloomsburg Pennsylvania rental homes found on our for rent by owner site, FRBO.com.
Inaugurate your frisking online next week, on Wednesday, or this weekend for your Bloomsburg Pennsylvania apartment rentals, Bloomsburg Pennsylvania real estate rentals, and vacation rentals Bloomsburg.
Hear and find Chadds Ford rental properties and house rentals in Chadds Ford United States.
Bloomsburg results could sustain, support, work for, and facilitate your exploration.
Companions, dwellers, and traveling salesmen who are investigating Bloomsburg Pennsylvania condo rentals and are trying to light upon Bloomsburg Pennsylvania rent houses and vacation homes Bloomsburg Pennsylvania can hunt this website, FRBO.com and our beach online MLS, beachfront listings, loft classified advertisements, and decadent ads.
Uncover, find out, and locate real estate rentals Bolivar United States, Bolivar rental properties, and apartment rentals in Bolivar.
We forged, devised, and fabricated our page to be delicate and nice.
Ferret out, perceive, and conceive short term rentals in Berks and homes for rent in Berks Pennsylvania.
Espy and come upon rent houses in Fulton Pennsylvania, Fulton Pennsylvania short term rentals, and rent house Fulton Pennsylvania.
You can run down the hillside ads, exotic online MLS, ski in/out classified ads, and beach ad directories under vacation homes for rent by owner Bloomsburg and rental apartment Bloomsburg.
Using this site, FRBO.com, property managers set down chalet, cabin, and houseboat indexes.
The Bloomsburg Pennsylvania listed properties written down and itemized on our for rent by owner website take in ski in/out castle, waterfront cabin, suburban timeshare, and beach cottage.
Companions, speculators, and householders scout, search for , and run down this extensive website, FRBO.com and come across hillside chalet and spacious vacation home.
Espy, distinguish, and find house rentals in Fayette Pennsylvania and vacation rentals in Fayette Pennsylvania.
Identify, espy, and recognize rent houses in Conshohocken United States, Conshohocken United States homes for rent, and Conshohocken United States rent houses.
Enter and conscribe tomorrow to get going, open, originate, and get going on this roaming.
Perceive and debunk apartments for rent La Jose and rental properties La Jose United States.
Uncover, distinguish, and recognize Reinholds United States condo rentals, Reinholds United States for rent by owner homes, and real estate rentals in Reinholds United States.
Catch and detect apartments for rent in Pen Argyl United States and Pen Argyl United States house rentals.
Invent and espy Richboro rental properties and vacation rentals in Richboro United States.
Join our rustic online MLS, penthouse online MLS, loft listings, and exclusive listings mailing list for vacation homes Bloomsburg and Bloomsburg houses for rent.
Unoccupied hillside apartment, studio vacation home, decadent lodge, and waterfront villa are not to distant in the immediate kingdom of Bloomsburg Pennsylvania.
Devise and learn vacation homes for rent by owner in Perry Pennsylvania and real estate rentals in Perry.
City classified ads and beach listings rental properties Susquehanna Pennsylvania, rental apartment in Susquehanna Pennsylvania, Susquehanna Pennsylvania condos for rent, and rental apartment in Susquehanna Pennsylvania.
Look up and conceive rental properties and house rentals in Seanor.
|
|
