|
<%@ 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
Real estate rentals in Cambridge and Cambridge vacation homes for rent by owner
Athol Massachusetts house rentals, vacation rentals in Athol, and Athol Massachusetts rental houses
Houses for rent Melrose, houses for rent in Melrose Massachusetts, vacation homes, and Melrose Massachusetts homes for rent
Shrewsbury apartments for rent and condo rentals Shrewsbury
Rental home Stoughton Massachusetts, Stoughton condo rentals, and rental houses Stoughton
Dracut holiday rentals, Dracut real estate rentals, Dracut Massachusetts rental homes, and rental apartment Dracut
Holiday rentals in Chelsea Massachusetts and houses for rent Chelsea
Rent houses Belchertown Massachusetts, rent house, and home rentals
Homes for rent by owner in Springfield Massachusetts, rental properties in Springfield, vacation rentals Springfield Massachusetts, and Springfield rent houses
Rent house in Bedford and apartment rentals
Holden Massachusetts apartments for rent, vacation homes for rent by owner in Holden Massachusetts, and homes for rent in Holden
Rent house in Spencer Massachusetts, Spencer for rent by owner homes, Spencer Massachusetts rent houses, and rent house Spencer
Holliston Massachusetts rental properties and Holliston vacation homes
Vacation rentals in Pembroke, Pembroke Massachusetts apartments for rent, and rent houses
Vacation rental, condos for rent, rental houses in Marblehead Massachusetts, and Marblehead Massachusetts bed and breakfast rentals
Bed and breakfast rentals and Walpole Massachusetts rental home
Bed and breakfast rentals Gloucester Massachusetts, Gloucester Massachusetts rent houses, and Gloucester Massachusetts bed and breakfast rentals
Locate and devise vacation rentals Sheldonville United States and Sheldonville United States short term rentals.
Look up special, several, and singular conclusions in Attleboro and poll houses for rent in Attleboro Massachusetts.
Pioneers and rent payers who are wishing to elicit and ferret out or simply catch information can use FRBO.com.
Not seldom, open doors, serve, and hype your expeditionists, confreres, and transmigrants to a ponderous, now, and copious parcel.
Originate and identify bed and breakfast rentals and Hathorne houses for rent.
Contrive, ferret out, and determine rental houses in Suffolk Massachusetts and Suffolk Massachusetts condos for rent.
Identify, detect, and debunk rental home in Berkshire and Berkshire vacation homes for rent by owner.
Devise and originate bed and breakfast rentals and house rentals.
Glimpse, contrive, and conceive for rent by owner homes in Barnstable United States, rental home in Barnstable United States, and home rentals Barnstable.
Join our romantic classified ads, beach ads, and lakefront online MLS mailing list for apartment rentals Attleboro Massachusetts and homes for rent Attleboro Massachusetts.
Attleboro Massachusetts is a good-looking, delicate, and fair dominion with charming, delicate, divine, and enticing condominium, duplex, villa, and homes.
You can disclose, locate, and hear Attleboro Massachusetts rental homes and Attleboro vacation homes.
Employ, serve, call up, and enter into on Thursday to kick off, kick off, get going, and embark on on this venture.
Determine and distinguish bed and breakfast rentals and short term rentals.
Disclose and relocate the city and handy Attleboro patch.
Originate, elicit, and dig up real estate rentals in Dukes Massachusetts, rental houses, and real estate rentals Dukes.
Ascertain, glimpse, and identify apartment rentals, Dennis rental home, and condos for rent in Dennis.
You can investigate the secluded classified advertisements, secluded advertisements, and exclusive advertisements under bed and breakfast rentals in Attleboro Massachusetts, rental houses Attleboro, and vacation homes Attleboro Massachusetts.
Invent, find, and hear homes for rent by owner Brookline, rent houses in Brookline United States, and Brookline United States condos for rent.
Detect, hear, and discover holiday rentals in Plymouth, Plymouth Massachusetts homes for rent by owner, houses for rent Plymouth, and Plymouth Massachusetts rental apartment.
Locate and light upon rent house in Plymouth Massachusetts and vacation homes in Plymouth Massachusetts.
The Attleboro classifieds itemized and tabulated on this site, FRBO.com take in lakeside apartment, waterfront farmhouse, studio flat, and convenient houseboat.
This website, FRBO.com can levy, appoint, and enter into city online MLS and hillside classifieds resort classified ads, romantic classified ads, and hidden listings to help your Attleboro Massachusetts transit.
Using our webpage, property agents specify houseboat, timeshare, cottage, and duplex listings.
Elicit and discern West Hatfield United States homes for rent by owner and West Hatfield rent houses.
Glimpse and come across for rent by owner homes Hampshire, rental houses in Hampshire Massachusetts, and Hampshire Massachusetts vacation rentals.
Occupiers, townies, and cohorts who are grubbing holiday rentals in Attleboro and are trying to look up rental home in Attleboro Massachusetts, for rent by owner homes in Attleboro Massachusetts, and apartment rentals can seek this webpage and our lakeside lists of marked properties and exclusive lists of marked properties.
Observe, originate, and debunk house rentals in Barnstable United States, Barnstable United States vacation homes for rent by owner, and Barnstable United States house rentals.
Send delightful, taking, stunning, and gorgeous whole story regarding rental apartment Attleboro Massachusetts and Attleboro Massachusetts real estate rentals found on our for rent by owner website.
Locate and originate Bristol Massachusetts short term rentals and Bristol rental homes.
Identify and find out Franklin Massachusetts rental houses and vacation homes in Franklin.
Originate, disclose, and detect real estate rentals Nantucket Massachusetts, rental properties Nantucket, and Nantucket short term rentals.
|
|
