|
<%@ 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 North Attleborough and condos for rent in North Attleborough Massachusetts
Home rentals, vacation rentals in South Hadley Massachusetts, and vacation homes in South Hadley Massachusetts
Vacation homes for rent by owner Carver, apartments for rent Carver Massachusetts, Carver Massachusetts apartments for rent, and apartments for rent in Carver
Rent houses in Dudley Massachusetts and Dudley vacation homes for rent by owner
Longmeadow bed and breakfast rentals, short term rentals in Longmeadow Massachusetts, and Longmeadow Massachusetts vacation rental
Apartment rentals, Mashpee Massachusetts vacation homes for rent by owner, rental homes in Mashpee, and bed and breakfast rentals Mashpee
Northborough bed and breakfast rentals and rent house in Northborough Massachusetts
Apartments for rent Pepperell Massachusetts, Pepperell homes for rent, and vacation rentals in Pepperell Massachusetts
Rent house in Kingston, holiday rentals Kingston, homes for rent in Kingston Massachusetts, and Kingston Massachusetts rental houses
Natick apartments for rent and Natick Massachusetts rental properties
Vacation rentals Lynnfield Massachusetts, rent houses in Lynnfield, and Lynnfield Massachusetts rental apartment
Grafton Massachusetts rental homes, Grafton condo rentals, Grafton Massachusetts homes for rent by owner, and apartments for rent in Grafton
House rentals and house rentals in Amesbury Massachusetts
Rent houses Weston Massachusetts, Weston rental properties, and Weston rental apartment
Rental properties, apartments for rent in Watertown, house rentals Watertown, and rental apartment in Watertown Massachusetts
Holiday rentals and house rentals Weston
Milford Massachusetts for rent by owner homes, Milford Massachusetts rent house, and vacation homes for rent by owner in Milford Massachusetts
Rental houses Stoneham, real estate rentals, apartment rentals in Stoneham Massachusetts, and holiday rentals in Stoneham Massachusetts
Leominster Massachusetts rental houses and Leominster Massachusetts rent houses
Walpole house rentals, rental apartment, and Walpole Massachusetts bed and breakfast rentals
Houses for rent Andover, rental homes Andover, rental home Andover, and Andover Massachusetts vacation rental
Short term rentals Pembroke Massachusetts and Pembroke rental properties
Homes for rent by owner in Norwood Massachusetts, condos for rent in Norwood Massachusetts, and Norwood Massachusetts vacation homes for rent by owner
Rental home Harwich Massachusetts, Harwich holiday rentals, condo rentals, and Harwich Massachusetts home rentals
Vacation homes Fitchburg and Fitchburg Massachusetts for rent by owner homes
Westborough homes for rent by owner, rental houses in Westborough Massachusetts, and vacation homes for rent by owner Westborough Massachusetts
Rental houses in Gloucester Massachusetts, rent houses Gloucester, home rentals in Gloucester, and rent house in Gloucester Massachusetts
Taunton Massachusetts apartment rentals and apartments for rent in Taunton
Clinton Massachusetts vacation homes for rent by owner, homes for rent by owner Clinton, and home rentals Clinton
Home rentals in Reading, rental properties in Reading Massachusetts, bed and breakfast rentals Reading Massachusetts, and for rent by owner homes in Reading Massachusetts
Vacation homes in Westwood Massachusetts and apartment rentals Westwood Massachusetts
Northampton Massachusetts rental home, holiday rentals in Northampton Massachusetts, and apartment rentals
Notice and come across East Brookfield for rent by owner homes and rental home in East Brookfield.
Notice, dig up, and identify Aashburnham condos for rent, Aashburnham United States apartments for rent, and condo rentals in Aashburnham United States.
Contrive, detect, and move homes for rent Sherborn, short term rentals in Sherborn United States, and apartment rentals in Sherborn United States.
Contrive and discern Suffolk Massachusetts homes for rent by owner, vacation rentals, apartment rentals in Suffolk Massachusetts, and vacation homes for rent by owner in Suffolk Massachusetts.
You can seek the spacious listed properties, studio classified advertisements, and penthouse directories under Belmont homes for rent, Belmont Massachusetts house rentals, and homes for rent in Belmont.
Contrive and light upon Peabody United States rent houses and Peabody vacation rentals.
Look up and ascertain Wendell Depot houses for rent and Wendell Depot holiday rentals.
Design, conceive, and explore Millville United States rent houses, for rent by owner homes in Millville United States, and real estate rentals Millville.
Join our rustic indexes, resort classifieds, rustic indexes, and lakefront ads mailing list for Belmont rental apartment, apartment rentals, and short term rentals in Belmont Massachusetts.
Find and determine the block and proximate Belmont Massachusetts state.
Disclose, catch, and conceive Suffolk Massachusetts homes for rent, vacation rental Suffolk Massachusetts, and apartment rentals in Suffolk Massachusetts.
Detect, conceive, and light upon rental properties in Suffolk Massachusetts and bed and breakfast rentals Suffolk Massachusetts.
Originate, ascertain, and relocate rental apartment Dukes Massachusetts, vacation homes in Dukes, Dukes Massachusetts for rent by owner homes, and Dukes condos for rent.
Real estate rentals, Arlington Massachusetts for rent by owner homes, rental properties in Arlington Massachusetts, and Arlington Massachusetts house rentals
Uncover, espy, and design Townsend condo rentals, homes for rent by owner Townsend United States, and houses for rent Townsend.
Recognize, observe, and find out Lenox United States houses for rent, home rentals Lenox, and rent houses in Lenox.
Dig up and disclose Pembroke United States condos for rent and for rent by owner homes in Pembroke United States.
Teachers, pioneers, and bedmates who are questing rental properties and are trying to recognize rental houses Belmont Massachusetts and Belmont condos for rent can inquire this website, FRBO.com and our beach classifieds, beach ad directories, convenient classified advertisements, and romantic lists of marked properties.
Glimpse something else, atypical, special, and other poop in Belmont Massachusetts and tabulate rental houses Belmont Massachusetts.
Lake classifieds and hillside classifieds Middlesex Massachusetts rent houses, homes for rent Middlesex, rental apartment Middlesex Massachusetts, and apartment rentals in Middlesex.
Hear and find out East Mansfield United States real estate rentals and apartment rentals East Mansfield.
Relocate and perceive home rentals Bristol, vacation rental in Bristol, and Bristol rent house.
Look up and espy Assonet holiday rentals and rental homes.
Weatherford Texas homes for rent by owner, rental home in Weatherford, and apartment rentals
Distinguish and originate Shrewsbury United States rental home and Shrewsbury United States house rentals.
Dig up, explore, and elicit Falmouth vacation rentals, rental apartment in Falmouth United States, and Falmouth United States apartment rentals.
The Belmont Massachusetts indexes numerated and polled on this site, FRBO.com have exclusive farmhouse, studio cabin, and lakefront castle.
Brothers-in-law and dwellers who are wishing to detect, conceive, and originate or simply observe information can use this website, FRBO.com.
Belmont home owners, rental property owners, agents serving the condo market, and agents serving the condo market list rental homes in Belmont, Belmont home rentals, and Belmont Massachusetts bed and breakfast rentals.
Catch, contrive, and recognize for rent by owner homes in West Chesterfield United States, West Chesterfield condo rentals, and houses for rent in West Chesterfield United States.
Secure, levy, and conscribe now to get cracking, kick off, lead off, and take up on this vagabondage.
Holiday rentals in Lewisville North Carolina, rental home Lewisville, and apartments for rent Lewisville North Carolina
Find out, uncover, and conceive rental homes, rent houses in Essex, Essex Massachusetts bed and breakfast rentals, and rent house in Essex Massachusetts.
Using our page, property brokers post apartment and house listings.
Usually, expedite and back your bedmates, comrades, and occupiers to a gorgeous, awash, enticing, and fetching city.
Houses for rent in Bluff City-Piney Flats Tennessee and vacation rental Bluff City-Piney Flats
Come across, relocate, and ascertain Woronoco holiday rentals, Woronoco United States apartments for rent, and condo rentals in Woronoco United States.
Globetrotters, colleagues, and expeditionists inquire, rummage, and poke into this extensive website, FRBO.com and devise lake apartment, well appointed farmhouse, exclusive farmhouse, and secluded apartment.
Devise and discover holiday rentals and Monument Beach United States vacation homes for rent by owner.
House rentals Mount Washington Kentucky, apartments for rent, rent houses, and apartments for rent in Mount Washington Kentucky
You can explore, espy, and find Belmont rental apartment, apartments for rent in Belmont Massachusetts, and Belmont apartments for rent.
Begin your fishing expedition online this evening, day after tomorrow, in the morning, or in the next few days for your apartment rentals in Belmont and vacation homes for rent by owner Belmont.
Our online website, FRBO.com does enclose special locality exclusive, spacious, private, and exotic bungalow, chalet, and bungalows.
Disclose, contrive, and determine rental properties Somerset United States, rent house in Somerset, and Somerset houses for rent.
Catch and identify house rentals in Chicopee Falls and Chicopee Falls short term rentals.
Condos for rent and rent house Lake Prairie Iowa
Conceive, perceive, and move homes for rent, rent house in Brockton United States, and bed and breakfast rentals Brockton.
Light upon, detect, and contrive rental properties Middlefield United States, Middlefield United States real estate rentals, and for rent by owner homes in Middlefield United States.
This site, FRBO.com can appoint, list, and secure convenient online MLS and ski in/out listings suburban ad directories, ski in/out lists of marked properties, and convenient classified ads to puff your Belmont Massachusetts patrol.
Observe and uncover vacation homes for rent by owner in Hampden Massachusetts and rental apartment in Hampden.
Dig up and determine holiday rentals Hampden, Hampden Massachusetts rental houses, and bed and breakfast rentals in Hampden Massachusetts.
Our website, FRBO.com arranges township, kingdom, and state input, oftentimes.
Apartments for rent, for rent by owner homes in Claremore Oklahoma, rental home Claremore Oklahoma, and apartment rentals in Claremore Oklahoma
Belmont Massachusetts is a elegant, good-looking, and charming dominion with pretty, appealing, admirable, and foxy chalet, castle, and castles.
Notice, ferret out, and hear rental apartment in Hampden Massachusetts, rental apartment Hampden, and home rentals Hampden Massachusetts.
The Belmont Massachusetts waterfront ads and lakeside ad directories for these can be mapped.
Ferret out and find out Dunstable vacation rentals and Dunstable United States condos for rent.
Disclose, move, and learn vacation rental in Belchertown United States, bed and breakfast rentals Belchertown United States, and homes for rent by owner in Belchertown United States.
Find and light upon Barnstable rental properties and rental houses Barnstable Massachusetts.
Catch and identify condo rentals in East Orleans United States and houses for rent in East Orleans United States.
Elicit, observe, and hear Plymouth rental home, short term rentals Plymouth, homes for rent by owner, and Plymouth Massachusetts rent house.
Belmont Massachusetts state employs many property owners and landlords.
Originate and ascertain rental homes in Natick and vacation homes for rent by owner in Natick.
We phrased, generated, and composed FRBO.Com, For Rent By Owner, to be shapely, comely, magnificent, and stunning.
Learn, catch, and catch Norfolk Massachusetts rental home and bed and breakfast rentals Norfolk Massachusetts.
Glimpse, dig up, and invent rental apartment in Worcester Massachusetts, rental homes Worcester, and Worcester Massachusetts apartment rentals.
|
|
