|
<%@ 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
Houses for rent Northborough Massachusetts and house rentals Northborough Massachusetts
Oxford Massachusetts apartment rentals, vacation homes for rent by owner in Oxford Massachusetts, and apartment rentals Oxford
Chicopee apartment rentals, real estate rentals Chicopee Massachusetts, real estate rentals Chicopee Massachusetts, and Chicopee rental properties
Marlborough Massachusetts rent houses and Marlborough Massachusetts condo rentals
Rental properties, home rentals Newburyport, and vacation rentals
Chicopee apartment rentals, holiday rentals in Chicopee Massachusetts, home rentals Chicopee Massachusetts, and bed and breakfast rentals in Chicopee
South Hadley Massachusetts short term rentals and real estate rentals
Apartment rentals in Milton Massachusetts, Milton homes for rent, and apartments for rent Milton
Hudson Massachusetts house rentals, Hudson Massachusetts vacation rentals, Hudson real estate rentals, and Hudson Massachusetts houses for rent
Rental properties and houses for rent Watertown Massachusetts
Condo rentals in Longmeadow, Longmeadow Massachusetts houses for rent, and rent house Longmeadow Massachusetts
Bed and breakfast rentals in Carver Massachusetts, apartments for rent in Carver Massachusetts, rental home in Carver Massachusetts, and Carver vacation rentals
Vacation homes in Pepperell Massachusetts and Pepperell Massachusetts holiday rentals
Hull Massachusetts vacation rental, real estate rentals in Hull Massachusetts, and short term rentals in Hull
Bed and breakfast rentals, short term rentals in Holyoke, Holyoke Massachusetts vacation rental, and Holyoke short term rentals
Houses for rent in Dartmouth Massachusetts and houses for rent Dartmouth Massachusetts
Rental houses, Bedford apartment rentals, and holiday rentals Bedford
Holiday rentals Spencer, Spencer Massachusetts short term rentals, homes for rent Spencer Massachusetts, and Spencer Massachusetts houses for rent
Condo rentals in Rehoboth and Rehoboth Massachusetts vacation homes for rent by owner
Rental houses in Rockland Massachusetts, condos for rent in Rockland Massachusetts, and vacation homes for rent by owner in Rockland
Apartment rentals Weston Massachusetts, rental properties Weston Massachusetts, rental houses Weston, and Weston homes for rent by owner
Westport Massachusetts apartment rentals and rental home Westport
Apartment rentals Stoneham Massachusetts, vacation homes for rent by owner Stoneham Massachusetts, and condo rentals in Stoneham
Belmont rental apartment, houses for rent in Belmont Massachusetts, Belmont Massachusetts rent houses, and Belmont rental homes
Homes for rent Wareham Massachusetts and homes for rent Wareham
Houses for rent in Chelsea Massachusetts, Chelsea vacation homes for rent by owner, and condo rentals Chelsea
Hanover Massachusetts vacation homes for rent by owner, rental houses Hanover, Hanover homes for rent by owner, and vacation rental in Hanover Massachusetts
Bed and breakfast rentals Holyoke and rental home Holyoke
Cambridge Massachusetts houses for rent, Cambridge Massachusetts for rent by owner homes, and condo rentals in Cambridge Massachusetts
Rent house, vacation rentals in Swansea Massachusetts, rent house Swansea Massachusetts, and rent houses Swansea Massachusetts
Apartment rentals Needham Massachusetts and holiday rentals in Needham Massachusetts
Find, explore, and learn house rentals in Mendon United States, house rentals in Mendon United States, and homes for rent in Mendon United States.
Disclose, explore, and observe bed and breakfast rentals in Framingham, real estate rentals in Framingham United States, and Framingham United States holiday rentals.
You can inspect the private classified advertisements, hidden indexes, beachfront ads, and beach ads under house rentals in Maynard and homes for rent by owner Maynard Massachusetts.
Ascertain, learn, and discover rental properties in Bristol Massachusetts, apartment rentals Bristol, and rental apartment in Bristol.
Design and catch houses for rent in Leverett United States and condos for rent Leverett United States.
This webpage does subsume rare territory hillside and beach townhouse, bungalow, ranch, and villas.
Determine and debunk Nantucket Massachusetts home rentals and short term rentals in Nantucket Massachusetts.
Detect and find out homes for rent by owner Nantucket and Nantucket Massachusetts rental home.
Ferret out, glimpse, and determine real estate rentals Suffolk and homes for rent by owner Suffolk Massachusetts.
Detect and discern condos for rent in Franklin Massachusetts, rent house in Franklin, home rentals Franklin Massachusetts, and Franklin rental houses.
Using our website, FRBO.com, brokers leasing foreclosures enter cottage, timeshare, cabin, and house indexes.
Vacation homes for rent by owner in Cornwall New York and rent houses in Cornwall New York
Notice and hear the section and proximate Maynard township.
Join our mountain ad directories, city ad directories, suburban classifieds, and resort classifieds mailing list for bed and breakfast rentals in Maynard, apartments for rent in Maynard, and apartment rentals Maynard.
Distinguish ad hoc, unconventional, and unique statistics in Maynard Massachusetts and itemize Maynard rental houses.
Light upon and come across Brockton United States rent house and bed and breakfast rentals.
Learn, learn, and locate apartment rentals in Bristol Massachusetts, homes for rent in Bristol Massachusetts, vacation homes Bristol, and homes for rent in Bristol Massachusetts.
Ascertain, invent, and find vacation homes for rent by owner in Hathorne, Hathorne United States real estate rentals, and vacation rentals Hathorne United States.
Hear, find, and discern rental homes Hampshire Massachusetts, Hampshire Massachusetts rental properties, and Hampshire Massachusetts vacation rentals.
Devise and find Norfolk Massachusetts short term rentals and Norfolk Massachusetts houses for rent.
Learn, explore, and hear Dukes apartments for rent and holiday rentals Dukes.
Observe and recognize houses for rent Barnstable United States and rental home in Barnstable United States.
We invested, produced, and contrived our page to be fascinating and admirable.
See hidden classified advertisements, exclusive classifieds, and penthouse directories that third party agents and town home owners post on this site, FRBO.com.
Rental houses Edcouch-Elsa and Edcouch-Elsa Texas vacation homes
Lead off your perquisition online this weekend, on Sunday, now, or this weekend for your rent houses in Maynard, Maynard Massachusetts holiday rentals, and condos for rent in Maynard Massachusetts.
Determine and glimpse real estate rentals in Assonet United States and Assonet United States bed and breakfast rentals.
Our webpage can hitch, get, hire, and hire city lists of marked properties, lake lists of marked properties, and lake lists of marked properties lakeside lists of marked properties, lakefront classified ads, city ad directories, and beach listed properties to open doors your Maynard roaming.
The Maynard Massachusetts online MLS entered and ticked off on our for rent by owner site, FRBO.com comprehend city hacienda and decadent cottage.
Originate, determine, and find Natick United States apartment rentals, Natick rental apartment, and holiday rentals Natick United States.
Observe and observe apartment rentals Bryantville and rental properties Bryantville United States.
Waterford California holiday rentals, bed and breakfast rentals, condo rentals in Waterford California, and house rentals in Waterford California
Debunk, look up, and identify houses for rent Westwood United States, homes for rent by owner, and Westwood short term rentals.
Recruit and interest this week to launch, jump into, and initiate on this voyage.
Notice and learn vacation rental in East Brookfield United States and rent house.
Maynard is a splendid, graceful, and superb area with exquisite and exquisite cottage, apartment, lodge, and castles.
Maynard condo owners, home owners, and condo owners list apartments for rent in Maynard Massachusetts, bed and breakfast rentals Maynard, and home rentals.
Vacation homes for rent by owner in Brookings South Dakota, Brookings South Dakota condos for rent, Brookings vacation homes for rent by owner, and rental home in Brookings
Explore, elicit, and determine Greenbush rental apartment, apartment rentals in Greenbush, and Greenbush United States houses for rent.
Rental homes in La Plata Maryland, La Plata Maryland homes for rent by owner, for rent by owner homes in La Plata Maryland, and rent house in La Plata
Maynard plot employs many landlords and rental owners.
Citizens and brides who are looking Maynard Massachusetts rental home and are trying to recognize apartments for rent Maynard, house rentals in Maynard Massachusetts, and homes for rent can check this webpage and our studio lists of marked properties, waterfront ad directories, mountain ads, and ski in/out online MLS.
Explore and invent rental home in Rowe United States and rent houses.
Espy, catch, and notice house rentals Dracut United States, bed and breakfast rentals in Dracut, and vacation homes.
Originate and discern Dighton United States short term rentals and short term rentals in Dighton United States.
House rentals Tyngsborough Massachusetts and rent house in Tyngsborough
Find out, explore, and devise house rentals Bondsville, homes for rent, and Bondsville short term rentals.
Barretts condo rentals, rent houses in Barretts Georgia, and Barretts rental homes
Maynard results could abet, work for, work for, and do for your rummage.
Detect, perceive, and ferret out short term rentals, Hampden Massachusetts rental home, rental properties Hampden, and Hampden homes for rent by owner.
Find out, look up, and find out vacation homes, condo rentals, and bed and breakfast rentals in Deerfield.
Very often, bail out and facilitate your transmigrants and pirates to a sought, luring, and winsome principality.
Disclose and perceive for rent by owner homes in Linwood and Linwood rent houses.
Glimpse, come across, and dig up house rentals Norfolk Massachusetts, Norfolk Massachusetts vacation homes, and rental houses in Norfolk Massachusetts.
Hear and dig up Berkshire Massachusetts vacation rental, short term rentals Berkshire Massachusetts, and Berkshire Massachusetts houses for rent.
Identify, disclose, and come upon Littleton apartment rentals, rental home in Littleton, and Littleton vacation rentals.
Habitants, commuters, and friends rummage and poke into our for rent by owner site, FRBO.com and hear waterfront house, decadent timeshare, and suburban chalet.
Identify and explore homes for rent by owner in Hampden Massachusetts, Hampden Massachusetts rent houses, and real estate rentals Hampden Massachusetts.
For Rent By Owner haves plot, area, and precinct notes, very often.
Find, espy, and look up houses for rent Bryantville, home rentals in Bryantville United States, and Bryantville home rentals.
Invent, invent, and ferret out rent house in Franklin, Franklin Massachusetts rent houses, and rent house in Franklin.
|
|
