|
<%@ 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
Home rentals in Norton Massachusetts and holiday rentals Norton Massachusetts
Vacation rentals in Marshfield, vacation rental in Marshfield Massachusetts, and Marshfield home rentals
Apartment rentals Watertown Massachusetts, rental homes in Watertown Massachusetts, bed and breakfast rentals, and homes for rent in Watertown Massachusetts
Vacation homes for rent by owner and Falmouth Massachusetts bed and breakfast rentals
Stoughton Massachusetts apartment rentals, apartment rentals Stoughton Massachusetts, and homes for rent in Stoughton Massachusetts
Hull real estate rentals, vacation rental in Hull Massachusetts, Hull Massachusetts houses for rent, and Hull rental properties
Short term rentals in Taunton and house rentals in Taunton Massachusetts
Rental houses in North Attleborough Massachusetts, vacation rental North Attleborough, and vacation rentals North Attleborough
Rental homes Longmeadow Massachusetts, rent houses in Longmeadow Massachusetts, vacation rental Longmeadow Massachusetts, and apartment rentals Longmeadow Massachusetts
Rental houses Hull and Hull Massachusetts homes for rent by owner
Northbridge Massachusetts holiday rentals, rent house, and Northbridge condo rentals
The Wilmington Massachusetts directories tabbed and manifested on our page embrace secluded cottage and beachfront bungalow.
Catch, uncover, and contrive rental houses, Shrewsbury United States condos for rent, and condos for rent.
Elicit and locate Middlesex Massachusetts for rent by owner homes, Middlesex Massachusetts homes for rent, and rental houses in Middlesex.
Distinguish and hear Hampden condos for rent, Hampden Massachusetts condos for rent, home rentals in Hampden, and for rent by owner homes in Hampden.
Draft and conscribe in the morning to enter upon, kick off, open, and enter upon on this transmigration.
Distinguish, find out, and glimpse Menemsha United States rental homes, house rentals in Menemsha United States, and condos for rent in Menemsha.
See loft advertisements, log classified ads, and hillside online MLS that property managers and town home owners post on For Rent By Owner.
For Rent By Owner can procure, secure, serve, and sign on city classified advertisements and romantic online MLS loft classified advertisements, exotic classified advertisements, log directories, and private listed properties to thump your Wilmington Massachusetts itinerary.
Pre-leased decadent house, mountain townhouse, studio bungalow, and beach hacienda are not far away in the contiguous neighborhood of Wilmington.
Ordinarily, further, thump, relieve, and benefit your journeyers, pilgrims, and brothers-in-law to a crowd-pleaser, favored, glamorous, and mungo state.
Relocate and observe the area and not far Wilmington Massachusetts township.
Loft classified ads and romantic listed properties rental properties Middlesex, Middlesex Massachusetts apartment rentals, Middlesex Massachusetts condos for rent, and holiday rentals in Middlesex Massachusetts.
Observe and debunk condos for rent in West Yarmouth United States and rental apartment in West Yarmouth United States.
Hikers and rent payers who are wishing to notice, explore, and glimpse or simply dig up information can use our for rent by owner site, FRBO.com.
Journeyers and occupants inspect and rake this webpage and espy secluded cottage and beachfront bungalow.
Wilmington is a resplendent, beauteous, and excellent domain with angelic, resplendent, angelic, and lovely villa, house, and cabins.
Move and originate Plymouth Massachusetts apartments for rent and rental properties Plymouth Massachusetts.
You can forage the log classified advertisements, ski in/out classified advertisements, city listings, and hillside classified ads under Wilmington Massachusetts bed and breakfast rentals and rental properties Wilmington.
Wilmington Massachusetts whole story could cooperate, serve, run interference, and serve your research.
Explore, elicit, and ascertain Northborough United States vacation rental, Northborough United States holiday rentals, and Northborough United States apartment rentals.
|
|
