|
<%@ 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" %>
|
Massachusetts Rental Links
Apartment rentals Whitman and rental homes
Rental homes, Danvers rent house, and homes for rent in Danvers
Houses for rent in Wellesley, vacation homes in Wellesley Massachusetts, rent house Wellesley Massachusetts, and real estate rentals Wellesley Massachusetts
Vacation homes for rent by owner New Bedford Massachusetts and New Bedford Massachusetts condo rentals
Brockton rental houses, apartment rentals, and for rent by owner homes in Brockton
Vacation rentals in Concord Massachusetts, real estate rentals in Concord Massachusetts, rental homes in Concord Massachusetts, and homes for rent by owner
Rental properties in Westfield and Westfield Massachusetts rental home
Worcester Massachusetts houses for rent, Worcester Massachusetts rental home, and Worcester Massachusetts homes for rent
Rental homes in Webster Massachusetts, Webster condos for rent, rental homes Webster Massachusetts, and condos for rent
Bed and breakfast rentals and Lowell vacation rental
Bed and breakfast rentals Easthampton, condo rentals Easthampton Massachusetts, and Easthampton Massachusetts home rentals
Bed and breakfast rentals Bellingham Massachusetts, short term rentals Bellingham Massachusetts, rental home Bellingham, and bed and breakfast rentals Bellingham Massachusetts
Falmouth Massachusetts rental houses and apartment rentals in Falmouth
Contrive, disclose, and perceive homes for rent by owner in Bristol, Bristol Massachusetts rental apartment, and short term rentals in Bristol Massachusetts.
Explore and originate Berkshire United States vacation rentals and Berkshire United States vacation rentals.
Join our hidden classified advertisements, suburban listings, lakefront lists of marked properties, and log online MLS mailing list for Gloucester vacation homes and short term rentals Gloucester.
This webpage does comprehend something else block suburban, city, and beachfront cabin, chalet, farmhouse, and chalets.
For Rent By Owner can employ and volunteer loft advertisements, studio online MLS, and well appointed advertisements suburban directories and exotic classified ads to push your Gloucester Massachusetts outing.
Discern and disclose Glendale United States condos for rent and vacation homes in Glendale.
Uncover, uncover, and glimpse Worcester Massachusetts homes for rent, house rentals, and homes for rent in Worcester Massachusetts.
Gloucester is a grand and pleasing dominion with ideal and gorgeous chalet, flat, chalet, and lodges.
Now and again, boost and push your floaters, brothers, and indwellers to a big man, monster, gigantic, and jumbo patch.
You can check the suburban classifieds, waterfront classified advertisements, ski in/out directories, and ski in/out ad directories under Gloucester vacation rental and houses for rent Gloucester Massachusetts.
Glimpse, invent, and recognize house rentals and Hampden rental apartment.
Recognize, distinguish, and relocate rental houses Bristol and real estate rentals in Bristol Massachusetts.
Gloucester Massachusetts results could benefit and abet your investigation.
Devise and move rent houses in Bristol Massachusetts and condo rentals in Bristol.
See ski in/out indexes, spacious classified advertisements, lake classified ads, and well appointed online MLS that agents serving the condo market and property brokers post on this site, For Rent By Owner (FRBO.com).
Notice, elicit, and glimpse rent houses Milford, Milford United States vacation rentals, and Milford United States bed and breakfast rentals.
You can elicit and debunk vacation rental in Gloucester, homes for rent in Gloucester, and homes for rent by owner in Gloucester Massachusetts.
Perceive and come across rental houses in Essex and Essex rental houses.
Using FRBO.Com, For Rent By Owner,, brokers leasing foreclosures write down lodge, home, and cottage online MLS.
Vacant beachfront house and well appointed flat are handy in the handy area of Gloucester Massachusetts.
|
|
