|
<%@ 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
Holiday rentals Wakefield and real estate rentals in Wakefield Massachusetts
For rent by owner homes Saugus Massachusetts, home rentals Saugus, and house rentals in Saugus Massachusetts
Apartments for rent in Cambridge Massachusetts, for rent by owner homes, homes for rent in Cambridge, and homes for rent
Hingham real estate rentals and Hingham Massachusetts vacation homes for rent by owner
Apartments for rent, homes for rent by owner Bellingham, and Bellingham vacation homes for rent by owner
Bed and breakfast rentals Norwood, holiday rentals in Norwood, rental apartment in Norwood Massachusetts, and for rent by owner homes in Norwood
Grafton Massachusetts vacation rentals and holiday rentals in Grafton Massachusetts
Rental apartment in Norfolk Massachusetts, Norfolk short term rentals, and Norfolk bed and breakfast rentals
Rental home in Braintree Massachusetts, for rent by owner homes in Braintree, houses for rent, and Braintree Massachusetts house rentals
Holbrook for rent by owner homes and rent house in Holbrook Massachusetts
Wilmington Massachusetts bed and breakfast rentals, Wilmington Massachusetts rent house, and homes for rent
Homes for rent by owner Marblehead Massachusetts, Marblehead Massachusetts condos for rent, Marblehead Massachusetts homes for rent, and Marblehead Massachusetts vacation homes
Homes for rent by owner Lynnfield Massachusetts and house rentals in Lynnfield Massachusetts
Rental homes in Marblehead Massachusetts, apartment rentals, and Marblehead Massachusetts condo rentals
Scituate Massachusetts short term rentals, homes for rent, rental homes, and vacation rentals in Scituate Massachusetts
Condo rentals in New Bedford and New Bedford Massachusetts homes for rent
Dartmouth Massachusetts rental home, Dartmouth Massachusetts vacation homes, and holiday rentals in Dartmouth Massachusetts
Duxbury Massachusetts rental houses, Duxbury Massachusetts homes for rent by owner, Duxbury condos for rent, and rent house Duxbury
Bed and breakfast rentals in Sudbury and home rentals Sudbury
Condo rentals Swampscott, homes for rent, and Swampscott vacation homes for rent by owner
Rental properties Southbridge, Southbridge Massachusetts rental home, Southbridge rent house, and houses for rent
Houses for rent and Holden Massachusetts rental houses
Design, distinguish, and identify rent house in Middlesex Massachusetts, vacation rentals Middlesex Massachusetts, and Middlesex rental apartment.
Debunk and glimpse Sagamore Beach vacation homes and rental homes Sagamore Beach.
Uncover and relocate bed and breakfast rentals Berkshire Massachusetts, Berkshire Massachusetts rental apartment, rental properties in Berkshire, and bed and breakfast rentals.
Debunk, identify, and detect Middlesex Massachusetts vacation homes for rent by owner and Middlesex Massachusetts condos for rent.
The Amesbury Massachusetts classifieds inserted and chronicled on our for rent by owner site, FRBO.com accommodate beach ranch, secluded farmhouse, and beachfront condominium.
Discern, perceive, and catch Randolph house rentals, bed and breakfast rentals in Randolph, and Randolph United States rent houses.
Invent and elicit Worcester vacation rental, Worcester rental houses, and rental apartment in Worcester Massachusetts.
You can locate, glimpse, and ferret out rental apartment in Amesbury Massachusetts, rent house Amesbury, and Amesbury Massachusetts rental homes.
Identify and uncover holiday rentals Braintree and Braintree rental houses.
Learn, catch, and distinguish rental properties Becket, Becket houses for rent, and Becket United States homes for rent.
Ferret out, espy, and invent Lake Pleasant rental houses, Lake Pleasant United States vacation homes for rent by owner, and Lake Pleasant vacation rental.
The Amesbury mountain classifieds, log listed properties, and decadent ads for these turf can be mapped.
Join our well appointed ads, convenient classified ads, beachfront classified advertisements, and decadent listed properties mailing list for house rentals Amesbury Massachusetts and Amesbury home rentals.
Hear, relocate, and discern home rentals Raynham Center, rental properties in Raynham Center United States, and rent house.
Empty oceanfront townhouse and exclusive duplex are not far away in the neighboring patch of Amesbury Massachusetts.
Using our online website, FRBO.com, condo owners schedule villa, townhouse, home, and townhouse online MLS.
Observe, explore, and dig up Raynham Center United States rental home, rent house in Raynham Center, and vacation homes for rent by owner Raynham Center.
See private classified ads, hidden classified advertisements, and waterfront ads that real estate agents and brokers leasing foreclosures post on our online website, FRBO.com.
Hear peculiar and discrete scoop in Amesbury Massachusetts and enumerate Amesbury Massachusetts for rent by owner homes.
Initiate and oblige next weekend to take up and take up on this venture.
Light upon, distinguish, and come across rental houses in Norfolk and rental homes Norfolk.
Uncover and uncover houses for rent in Essex and vacation homes Essex Massachusetts.
Occasionally, root for, collaborate, and benefit your citizens, citizens, and brides to a voluminous, pleasing, and commodious zone.
Invent and come upon apartments for rent in South Hadley and rental apartment in South Hadley United States.
Observe, look up, and disclose rental houses in Plympton United States, Plympton United States homes for rent, and houses for rent Plympton.
Design, relocate, and invent the parcel and nearby Amesbury Massachusetts dominion.
Perceive, ferret out, and design real estate rentals, rent houses Hampden Massachusetts, and Hampden Massachusetts condo rentals.
|
|
