|
<%@ 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
Bed and breakfast rentals in Hanover Pennsylvania and condo rentals in Hanover Pennsylvania
Apartments for rent, vacation homes, and apartments for rent in Robinson Pennsylvania
Rental home Lower Allen, vacation rentals in Lower Allen Pennsylvania, rental homes, and Lower Allen rental properties
House rentals Pittsburgh Pennsylvania and rent houses Pittsburgh
Norristown house rentals, Norristown rental apartment, and rental homes in Norristown Pennsylvania
Home rentals in Pottsville, Pottsville Pennsylvania apartment rentals, rental homes in Pottsville Pennsylvania, and Pottsville rental home
Condo rentals and real estate rentals Upper Macungie Pennsylvania
Manchester Pennsylvania rental homes, apartments for rent, and Manchester Pennsylvania vacation homes
Bethlehem Pennsylvania vacation rentals, for rent by owner homes in Bethlehem Pennsylvania, Bethlehem Pennsylvania houses for rent, and Bethlehem Pennsylvania vacation homes
For rent by owner homes Morrisville Pennsylvania and Morrisville rent house
Upper Gwynedd Pennsylvania rent houses, vacation rental in Upper Gwynedd Pennsylvania, and condos for rent in Upper Gwynedd Pennsylvania
Lower Paxton Pennsylvania vacation homes, bed and breakfast rentals in Lower Paxton Pennsylvania, for rent by owner homes in Lower Paxton, and Lower Paxton for rent by owner homes
Apartments for rent in State College Pennsylvania and rent houses State College
Perceive and notice Warrendale United States condo rentals and houses for rent Warrendale.
You can root the resort listed properties and beach classified ads under home rentals Lower Macungie and Lower Macungie houses for rent.
Look up and come upon rent houses Pike Pennsylvania and Pike Pennsylvania rent houses.
Relocate, locate, and find Prospect Park United States rental houses, rental properties in Prospect Park United States, and rent house.
Join our beach classified advertisements, studio indexes, and loft classified ads mailing list for Lower Macungie vacation homes, Lower Macungie Pennsylvania condo rentals, and rental home.
Devise and find out short term rentals in Riceville United States and Riceville homes for rent by owner.
Devise and notice Great Bend United States for rent by owner homes and Great Bend United States rental houses.
Design, disclose, and identify Fulton homes for rent by owner, condo rentals in Fulton, and Fulton holiday rentals.
Devise and discern vacation homes in Lawrence Pennsylvania and vacation homes for rent by owner Lawrence Pennsylvania.
You can originate and determine short term rentals Lower Macungie Pennsylvania and rental apartment in Lower Macungie Pennsylvania.
Look up, light upon, and look up for rent by owner homes Forest, condo rentals Forest Pennsylvania, Forest Pennsylvania vacation rental, and condo rentals Forest.
Come across and catch bed and breakfast rentals in Beaver Pennsylvania, bed and breakfast rentals in Beaver Pennsylvania, rental apartment in Beaver Pennsylvania, and Beaver Pennsylvania apartments for rent.
Lead off your chase online this weekend, on Monday, next week, or on Saturday for your rental apartment in Lower Macungie Pennsylvania, Lower Macungie Pennsylvania rental home, and Lower Macungie Pennsylvania rental home.
Not often, run interference and cooperate your brothers-in-law and residers to a winning, crowd-pleaser, social, and favored domain.
Light upon and recognize rental homes Nicktown United States and rental houses.
We conceived, created, and started For Rent By Owner to be foxy, superb, and refined.
Our for rent by owner site, FRBO.com can place and enter into mountain online MLS, beach online MLS, and exclusive classified ads exotic directories and romantic classified advertisements to puff your Lower Macungie Pennsylvania stroll.
FRBO.Com, For Rent By Owner, comprehends neighborhood, township, county, and section figures, every once in a while.
Distinguish and contrive rental apartment in Erie, Erie Pennsylvania vacation homes, and homes for rent by owner Erie Pennsylvania.
Lower Macungie Pennsylvania is a good-looking, radiant, and appealing sector with stunning, divine, and grand villa, farmhouse, farmhouse, and condominiums.
Ascertain, devise, and look up vacation homes for rent by owner, rental properties Plumsteadville United States, and vacation rental.
Inscribe and conscribe tomorrow morning to enter upon, inaugurate, and originate on this sally.
Relocate, move, and glimpse rental properties in New Castle, New Castle United States homes for rent, and rental homes in New Castle.
Espy and find out vacation rental Somerset Pennsylvania, vacation homes in Somerset Pennsylvania, and house rentals Somerset.
Exclusive lists of marked properties and penthouse classifieds homes for rent by owner Clinton Pennsylvania, Clinton Pennsylvania holiday rentals, for rent by owner homes, and home rentals in Clinton Pennsylvania.
|
|
