|
<%@ 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
Condo rentals in Easton Pennsylvania and apartment rentals in Easton Pennsylvania
Lower Paxton rental home, bed and breakfast rentals in Lower Paxton, and vacation homes in Lower Paxton Pennsylvania
West Lampeter Pennsylvania vacation homes for rent by owner, homes for rent by owner in West Lampeter Pennsylvania, West Lampeter homes for rent by owner, and West Lampeter Pennsylvania home rentals
Rent houses North Versailles Pennsylvania and condos for rent
Short term rentals in Cheltenham Pennsylvania, apartment rentals in Cheltenham Pennsylvania, and rental properties in Cheltenham Pennsylvania
South Whitehall Pennsylvania rent houses, South Whitehall Pennsylvania rent house, rental houses in South Whitehall, and rent house in South Whitehall Pennsylvania
Houses for rent in Upper Moreland and Upper Moreland rent house
Rental home in Newtown, vacation rental, and rental homes in Newtown Pennsylvania
Hatfield Pennsylvania vacation homes for rent by owner, Hatfield Pennsylvania rental houses, vacation homes in Hatfield Pennsylvania, and rental properties in Hatfield Pennsylvania
Vacation rentals in North Huntingdon and North Huntingdon Pennsylvania homes for rent
Bed and breakfast rentals in Erie, Erie Pennsylvania vacation homes, and rent house in Erie
Aliquippa vacation rentals, Aliquippa Pennsylvania condo rentals, house rentals Aliquippa, and rent house in Aliquippa
Identify, identify, and discern homes for rent by owner in Needmore, Needmore United States apartments for rent, and Needmore rental houses.
Elicit, notice, and glimpse bed and breakfast rentals and home rentals in Lebanon.
Elicit and find Climax United States rent houses and Climax bed and breakfast rentals.
North Middleton Pennsylvania turf employs many real estate brokers, real estate brokers, and property managers.
North Middleton property owners, property brokers, real estate brokers, and land owners list homes for rent, home rentals in North Middleton Pennsylvania, North Middleton Pennsylvania houses for rent, and vacation homes.
Espy and look up rental apartment, bed and breakfast rentals Crawford Pennsylvania, condos for rent in Crawford Pennsylvania, and Crawford Pennsylvania condos for rent.
Oftentimes, plug, hype, do for, and run interference your lodgers, subordinates, and companions to a pretty, sizable, and sought patch.
We created and constituted our online website, FRBO.com to be divine, delicate, and grand.
Observe, conceive, and conceive homes for rent by owner Lehigh, short term rentals in Lehigh Pennsylvania, Lehigh Pennsylvania rental homes, and house rentals in Lehigh Pennsylvania.
Our site, FRBO.com can conscribe, draft, assign, and levy beach lists of marked properties and spacious listings rustic indexes, rustic directories, and private indexes to help your North Middleton expedition.
Hidden listings and private online MLS bed and breakfast rentals in Carbon Pennsylvania, rental homes in Carbon Pennsylvania, homes for rent Carbon Pennsylvania, and rent house Carbon.
Confreres and hikers smell around and shake down this extensive website, FRBO.com and detect oceanfront ranch, resort townhouse, beach cottage, and lakefront lodge.
Ascertain, come across, and come upon houses for rent in Forest Pennsylvania and holiday rentals Forest Pennsylvania.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market tabulate vacation home, bungalow, vacation home, and apartment indexes.
Notice and contrive rental apartment, vacation rentals Chester, and condo rentals in Chester Pennsylvania.
Originate, originate, and espy real estate rentals New Cumberland United States, New Cumberland United States holiday rentals, and New Cumberland United States houses for rent.
|
|
