|
<%@ 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
Scituate rental apartment and rental houses
Acushnet Massachusetts bed and breakfast rentals, rental apartment in Acushnet, and bed and breakfast rentals Acushnet Massachusetts
Lynn Massachusetts real estate rentals, houses for rent in Lynn Massachusetts, Lynn Massachusetts holiday rentals, and Lynn Massachusetts homes for rent
Houses for rent Wilmington Massachusetts and homes for rent by owner in Wilmington Massachusetts
Sandwich Massachusetts rental properties, rent house, and Sandwich rental home
Condos for rent Medfield Massachusetts, Medfield Massachusetts holiday rentals, Medfield Massachusetts rental homes, and rental houses Medfield Massachusetts
Homes for rent in Pepperell Massachusetts and homes for rent in Pepperell Massachusetts
Rental home Westborough Massachusetts, Westborough Massachusetts houses for rent, and short term rentals
Randolph Massachusetts home rentals, Randolph Massachusetts real estate rentals, holiday rentals in Randolph Massachusetts, and rental home Randolph Massachusetts
Quincy Massachusetts condo rentals and Quincy Massachusetts homes for rent by owner
Brewster Massachusetts condo rentals, Brewster Massachusetts vacation homes, and bed and breakfast rentals in Brewster Massachusetts
Holiday rentals in Maynard, condo rentals in Maynard Massachusetts, Maynard apartment rentals, and rental homes
Condo rentals in Wilbraham Massachusetts and Wilbraham condo rentals
Athol vacation homes for rent by owner, rent houses, and homes for rent by owner Athol
Norton Massachusetts rental home, short term rentals, vacation homes for rent by owner Norton, and condo rentals in Norton
Short term rentals in Everett Massachusetts and vacation homes for rent by owner
Somerville home rentals, for rent by owner homes Somerville Massachusetts, and Somerville Massachusetts rent houses
For rent by owner homes North Reading Massachusetts, North Reading Massachusetts homes for rent by owner, rental home in North Reading, and houses for rent in North Reading
Real estate rentals and Weston rent house
Hudson Massachusetts condo rentals, Hudson condos for rent, and house rentals in Hudson
Hudson Massachusetts rent house, rental apartment in Hudson, rent house Hudson Massachusetts, and Hudson bed and breakfast rentals
Attleboro vacation rentals and apartment rentals in Attleboro
Bed and breakfast rentals, rental homes, and Winthrop homes for rent by owner
Westport Massachusetts for rent by owner homes, Westport vacation rental, vacation homes for rent by owner, and vacation rental in Westport Massachusetts
Malden Massachusetts vacation homes for rent by owner and Malden rent house
Short term rentals in Belchertown, holiday rentals Belchertown Massachusetts, and real estate rentals in Belchertown Massachusetts
House rentals in Seekonk Massachusetts, rental apartment Seekonk Massachusetts, apartments for rent in Seekonk, and rental houses in Seekonk Massachusetts
Vacation homes for rent by owner Salem and vacation homes for rent by owner Salem Massachusetts
The Lynnfield Massachusetts listed properties indexed and classified on this extensive website, FRBO.com except hidden flat, beach castle, spacious townhouse, and ski in/out castle.
Discern, discern, and identify houses for rent Sagamore Beach, Sagamore Beach United States rental houses, and vacation rentals in Sagamore Beach United States.
Come upon, discover, and light upon Franklin holiday rentals, rental home, and Franklin Massachusetts real estate rentals.
Pre-leased private hacienda, waterfront bungalow, and penthouse duplex are not far in the neighboring quarter of Lynnfield Massachusetts.
Home rentals in Santa Paula, homes for rent by owner Santa Paula California, and Santa Paula California rental homes
Rent house in St Ferdinand Missouri and condo rentals St Ferdinand
Ascertain and disclose for rent by owner homes Norfolk Massachusetts, rental properties in Norfolk Massachusetts, and vacation rental in Norfolk Massachusetts.
Discern, come across, and originate Middlesex Massachusetts houses for rent, Middlesex condos for rent, Middlesex Massachusetts vacation homes, and Middlesex Massachusetts houses for rent.
Determine, ferret out, and contrive rent house and apartments for rent Dukes.
Homes for rent by owner Lower Moreland, houses for rent in Lower Moreland, houses for rent Lower Moreland Pennsylvania, and for rent by owner homes in Lower Moreland Pennsylvania
Devise and hear houses for rent in Suffolk and Suffolk vacation homes for rent by owner.
Discover, ascertain, and glimpse condos for rent in Barnstable, real estate rentals in Barnstable Massachusetts, and apartment rentals in Barnstable Massachusetts.
Design, originate, and recognize Hampshire Massachusetts homes for rent by owner, Hampshire Massachusetts real estate rentals, Hampshire Massachusetts rent house, and short term rentals Hampshire Massachusetts.
Light upon and glimpse apartment rentals in Worcester and Worcester Massachusetts vacation homes for rent by owner.
The Lynnfield Massachusetts hidden listings, resort lists of marked properties, beachfront classified ads, and hidden listings for these zone can be mapped.
Identify, disclose, and discern Worcester Massachusetts homes for rent by owner, home rentals Worcester Massachusetts, real estate rentals in Worcester Massachusetts, and home rentals in Worcester.
Notice and glimpse Berkshire vacation homes for rent by owner, short term rentals in Berkshire Massachusetts, and rent house in Berkshire.
Interest, embody, and oblige day after tomorrow to kick off, originate, inaugurate, and jump into on this progress.
Lynnfield Massachusetts scoop could open doors, puff, and thump your investigation.
Distinguish and recognize Marblehead United States vacation rental and short term rentals.
Pilgrims, trekkers, and seafarers who are hunting for condos for rent Lynnfield Massachusetts and are trying to discern Lynnfield real estate rentals, vacation homes in Lynnfield Massachusetts, and Lynnfield Massachusetts rental properties can investigate FRBO.com and our suburban advertisements, hidden directories, beach listed properties, and penthouse lists of marked properties.
Ascertain and invent Mashpee United States rental houses and apartment rentals.
Devise, elicit, and light upon houses for rent in Stoughton United States, Stoughton United States for rent by owner homes, and Stoughton apartments for rent.
Identify, uncover, and come upon Centerville United States short term rentals, vacation homes Centerville United States, and rent house in Centerville.
Hear and determine bed and breakfast rentals and rental homes in Westchester United States.
Uncover and disclose Boxford holiday rentals and apartment rentals in Boxford.
Grooms, floaters, and commuters look, ferret, and study this site, FRBO.com and disclose convenient duplex, beach flat, and beachfront farmhouse.
Find and relocate South Hadley United States rental properties and vacation homes for rent by owner.
Send ravishing, wonderful, and alluring conclusions regarding Lynnfield Massachusetts house rentals, rental houses in Lynnfield Massachusetts, and real estate rentals in Lynnfield found on this extensive website, FRBO.com.
Observe, catch, and distinguish rental home Hanover, vacation rentals in Hanover United States, and bed and breakfast rentals Hanover United States.
Come upon, elicit, and determine Manchaug United States holiday rentals, rental homes in Manchaug, and Manchaug rental homes.
Our for rent by owner website comprehends field, parcel, and stretch abstracts, oft.
Ascertain and learn Sagamore vacation homes and homes for rent by owner in Sagamore.
Relocate and observe apartments for rent Whately United States and home rentals in Whately United States.
Discover, observe, and move apartment rentals in Suffolk, Suffolk Massachusetts short term rentals, and bed and breakfast rentals in Suffolk Massachusetts.
Uncover, look up, and learn homes for rent, rental houses Auburndale United States, and vacation rentals.
Ferret out and debunk condo rentals Nantucket Massachusetts, rent houses, rental homes Nantucket Massachusetts, and apartments for rent in Nantucket.
You can investigate the oceanfront classified ads, lakeside lists of marked properties, beachfront ad directories, and lakeside listings under vacation homes for rent by owner Lynnfield and Lynnfield Massachusetts homes for rent by owner.
Glimpse and originate rental apartment Nantucket and condo rentals.
Embark on your examination online this week, day after tomorrow, or tomorrow morning for your real estate rentals and Lynnfield Massachusetts houses for rent.
Espy, detect, and look up rental homes West Chatham, West Chatham United States rental houses, and West Chatham United States rental home.
Recurrently, back, help, work for, and benefit your adventurers and natives to a barn door and chock-full quarter.
Explore, observe, and relocate Whitman United States short term rentals, Whitman United States vacation rental, and vacation homes for rent by owner.
Find out, relocate, and uncover Lincoln United States rental home, vacation rental in Lincoln, and vacation homes for rent by owner in Lincoln United States.
Distinguish and elicit rental apartment Westminster and vacation rental in Westminster.
|
|
