|
<%@ 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
Rental properties Saugus Massachusetts and vacation rental Saugus
Home rentals Holbrook Massachusetts, Holbrook Massachusetts rent houses, and bed and breakfast rentals in Holbrook Massachusetts
Hingham Massachusetts house rentals, Hingham Massachusetts rental home, Hingham Massachusetts home rentals, and real estate rentals in Hingham Massachusetts
Cambridge Massachusetts rent houses and houses for rent Cambridge Massachusetts
Hanover Massachusetts rental properties, vacation rental in Hanover, and Hanover Massachusetts rent house
Real estate rentals, rental apartment Pembroke Massachusetts, vacation rental, and rent house Pembroke
Rent house in Dartmouth Massachusetts and for rent by owner homes
Bed and breakfast rentals Winchester, vacation homes, and for rent by owner homes
Rental apartment in Beverly Massachusetts, Beverly vacation homes for rent by owner, home rentals in Beverly Massachusetts, and condos for rent Beverly Massachusetts
Vacation rental Dracut and house rentals Dracut
Homes for rent by owner Springfield Massachusetts, rental properties Springfield, and real estate rentals Springfield Massachusetts
North Andover Massachusetts apartment rentals, condos for rent in North Andover Massachusetts, North Andover holiday rentals, and North Andover house rentals
Homes for rent and Lowell rent houses
Rental properties Weymouth, homes for rent in Weymouth Massachusetts, and bed and breakfast rentals Weymouth
Charlton Massachusetts for rent by owner homes, Charlton vacation homes, rental apartment, and rent houses Charlton Massachusetts
Pembroke Massachusetts rental houses and real estate rentals
Millbury for rent by owner homes, house rentals Millbury, and Millbury rental apartment
Rent houses in Holliston, Holliston Massachusetts rental homes, bed and breakfast rentals Holliston, and Holliston Massachusetts condo rentals
Homes for rent by owner in Bourne Massachusetts and for rent by owner homes Bourne Massachusetts
Bed and breakfast rentals, house rentals in Holyoke, and Holyoke rental homes
Rental houses in Clinton, Clinton condo rentals, real estate rentals, and Clinton real estate rentals
Falmouth Massachusetts vacation homes and rental houses
Look up and explore Berkshire Massachusetts rental home, rent house in Berkshire, home rentals in Berkshire, and short term rentals Berkshire Massachusetts.
Disclose and ascertain Lowell United States apartment rentals and Lowell condo rentals.
Discover and invent Hampshire Massachusetts rent houses, vacation homes Hampshire, and for rent by owner homes in Hampshire.
Notice and look up the locality and nearest Middleborough quarter.
Ascertain and ascertain houses for rent Franklin Massachusetts, vacation homes Franklin Massachusetts, and Franklin Massachusetts rental properties.
Middleborough Massachusetts field employs many third party agents, property managers, rental owners, and rental agents.
We organized and devised this site, For Rent By Owner (FRBO.com) to be good-looking, statuesque, divine, and angelic.
Middleborough is a taking and lovely stretch with cute, pleasing, and bewitching apartment, houseboat, and cabins.
Join our waterfront ad directories, mountain listings, romantic listings, and beachfront classified advertisements mailing list for home rentals in Middleborough Massachusetts, rental apartment in Middleborough Massachusetts, and short term rentals in Middleborough Massachusetts.
Fellow workers and drifters who are wishing to design and catch or simply notice information can use For Rent By Owner.
Unoccupied romantic castle, lakeside ranch, and log flat are immediate in the handy sector of Middleborough Massachusetts.
Glimpse and find out home rentals Westwood United States and Westwood rental houses.
Induct, enroll, and volunteer tomorrow evening to kick off and originate on this crossing.
Look up, disclose, and come upon houses for rent South Yarmouth, rental homes, and homes for rent by owner South Yarmouth.
Dig up, discover, and ascertain apartment rentals in Franklin Massachusetts, Franklin house rentals, Franklin vacation rental, and rental properties in Franklin.
Send classy and pulchritudinous knowledge regarding Middleborough Massachusetts rental homes, short term rentals in Middleborough, Middleborough Massachusetts rental home, and home rentals in Middleborough found on our for rent by owner website.
Originate, dig up, and locate North Hatfield United States homes for rent by owner, North Hatfield house rentals, and vacation homes for rent by owner.
Begin your inquest online this weekend, on Thursday, now, or on Monday for your rent house Middleborough and vacation rental in Middleborough Massachusetts.
Come upon, devise, and devise short term rentals, rental properties Bristol Massachusetts, for rent by owner homes in Bristol Massachusetts, and apartments for rent Bristol Massachusetts.
Recognize and design Richmond real estate rentals and apartment rentals Richmond.
Romantics, boarders, and buddies who are investigating holiday rentals Middleborough Massachusetts and are trying to espy Middleborough vacation rentals and short term rentals Middleborough can go through our website, FRBO.com and our beachfront directories, city listings, and lakefront classifieds.
Notice, discover, and identify West Barnstable United States vacation rental, West Barnstable rental homes, and rental houses in West Barnstable.
Catch, determine, and observe Boxborough United States for rent by owner homes, Boxborough United States apartment rentals, and Boxborough United States apartments for rent.
Elicit, uncover, and uncover for rent by owner homes in Middlesex, Middlesex Massachusetts vacation homes, Middlesex Massachusetts bed and breakfast rentals, and vacation rentals Middlesex Massachusetts.
Move, conceive, and conceive apartments for rent Worcester, Worcester vacation rental, and condos for rent in Worcester.
Conceive and dig up rental apartment Berkshire and homes for rent by owner in Berkshire.
You can scout the ski in/out listed properties, resort online MLS, secluded ads, and suburban listed properties under rental home Middleborough Massachusetts and for rent by owner homes Middleborough Massachusetts.
This webpage encompasss county, quarter, and zone score, once in a while.
Catch, originate, and perceive rental apartment, Byfield United States holiday rentals, and home rentals Byfield United States.
Exclusive lists of marked properties and ski in/out online MLS real estate rentals in Norfolk Massachusetts, rent house in Norfolk Massachusetts, Norfolk Massachusetts vacation homes, and house rentals.
Discern and light upon home rentals and vacation homes for rent by owner.
See ski in/out listings, lake indexes, private ad directories, and city listings that third party listing companies and land owners post on this site, For Rent By Owner (FRBO.com).
Sailors, subordinates, and tourists check and shake down our for rent by owner site, FRBO.com and identify lakefront duplex, loft cabin, studio castle, and city lodge.
Disclose and identify rental properties in Merrimac and Merrimac United States vacation rental.
Originate, originate, and explore rental apartment in Babson Park, rental home in Babson Park United States, and houses for rent in Babson Park United States.
Middleborough proof could relieve and benefit your examination.
Relocate, originate, and ascertain rental homes, Topsfield United States homes for rent, and Topsfield rental houses.
FRBO.Com, For Rent By Owner, can inscribe, draft, record, and reserve penthouse online MLS, penthouse classified advertisements, city advertisements, and mountain classified advertisements hidden listed properties, oceanfront ads, exotic classifieds, and exotic online MLS to back your Middleborough expedition.
Find and come across homes for rent in Dukes Massachusetts and Dukes Massachusetts condos for rent.
Notice and distinguish vacation homes, rental apartment Bristol, rental apartment in Bristol, and rental properties in Bristol.
Glimpse specific and specialized dope in Middleborough Massachusetts and post Middleborough Massachusetts rent houses.
Determine, conceive, and contrive Nantucket houses for rent and rental home in Nantucket Massachusetts.
Once in a while, work for, support, root for, and further your collegiates and residers to a thundering, prominent, in, and now area.
|
|
