|
<%@ 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
Home rentals and Sharon Pennsylvania rent houses
Apartment rentals Sunbury Pennsylvania, homes for rent in Sunbury Pennsylvania, and Sunbury rental properties
Rental houses, South Fayette rental apartment, rental houses South Fayette Pennsylvania, and rent houses in South Fayette Pennsylvania
Jeannette Pennsylvania condos for rent and rent houses Jeannette
Vacation homes in Lebanon Pennsylvania, real estate rentals Lebanon, and vacation homes
Rental apartment Whitemarsh Pennsylvania, vacation rental, vacation homes in Whitemarsh, and rental apartment Whitemarsh
Hanover Pennsylvania rent houses and Hanover rent houses
Rental homes in Guilford, Guilford real estate rentals, and rental properties in Guilford Pennsylvania
Apartments for rent in Lower Merion Pennsylvania, Lower Merion Pennsylvania apartments for rent, condo rentals in Lower Merion Pennsylvania, and houses for rent Lower Merion
Vacation homes Hanover and Hanover Pennsylvania vacation homes for rent by owner
New Britain Pennsylvania apartments for rent, vacation homes, and vacation homes in New Britain
Vacation rentals, Chester homes for rent, Chester Pennsylvania homes for rent by owner, and vacation homes in Chester Pennsylvania
Plymouth Pennsylvania for rent by owner homes and Plymouth vacation rentals
Using this site, For Rent By Owner (FRBO.com), rental owners particularize chalet, home, and lodge advertisements.
Locate, originate, and identify homes for rent by owner in Fairfield United States, vacation homes in Fairfield United States, and Fairfield United States house rentals.
Espy and learn the patch and contiguous Lebanon neighborhood.
Discover and locate Lawn United States for rent by owner homes and house rentals Lawn United States.
Detect, recognize, and recognize short term rentals in Westmoreland Pennsylvania, home rentals in Westmoreland, and houses for rent.
Learn, glimpse, and distinguish rent house in Delaware, rental homes in Delaware, Delaware Pennsylvania holiday rentals, and Delaware Pennsylvania rental home.
We conceived, created, and planned our online website, FRBO.com to be delightful, dazzling, and good-looking.
Come upon and elicit real estate rentals in Portland and homes for rent by owner in Portland.
You can originate, observe, and notice Lebanon Pennsylvania home rentals, Lebanon Pennsylvania real estate rentals, and Lebanon vacation rentals.
Muster, serve, and levy on Friday to jump into and kick off on this wandering.
Our site, FRBO.com can mobilize and assign lake listings and beach listings city directories and waterfront listed properties to collaborate your Lebanon traverse.
Lebanon real estate brokers and third party listing companies list homes for rent by owner in Lebanon Pennsylvania, vacation rentals, and homes for rent in Lebanon.
Lebanon knowledge could push, sustain, serve, and further your going-over.
Debunk and dig up for rent by owner homes in Lackawanna Pennsylvania, rental home Lackawanna, and Lackawanna Pennsylvania rental apartment.
Lebanon dominion employs many landlords, third party agents, and property managers.
|
|
