|
<%@ 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
Athol Massachusetts rental apartment and Athol Massachusetts house rentals
Vacation rental in Westborough Massachusetts, house rentals Westborough, and vacation rental in Westborough Massachusetts
Short term rentals Peabody Massachusetts, rental houses Peabody Massachusetts, Peabody Massachusetts rental properties, and houses for rent Peabody
Holiday rentals in Natick Massachusetts and Natick Massachusetts vacation homes for rent by owner
Homes for rent by owner in Stoneham, vacation homes for rent by owner in Stoneham Massachusetts, and Stoneham Massachusetts real estate rentals
Rent houses in Grafton Massachusetts, Grafton Massachusetts bed and breakfast rentals, Grafton Massachusetts bed and breakfast rentals, and Grafton rental houses
Rental houses Peabody and rent houses in Peabody Massachusetts
Vacation rentals Chelmsford Massachusetts, vacation homes Chelmsford, and rent house Chelmsford Massachusetts
Apartment rentals Dracut, holiday rentals in Dracut Massachusetts, rent house in Dracut Massachusetts, and Dracut homes for rent
Real estate rentals Somerville Massachusetts and Somerville Massachusetts apartment rentals
Millbury Massachusetts bed and breakfast rentals, vacation homes in Millbury Massachusetts, and short term rentals in Millbury Massachusetts
Beverly Massachusetts rent houses, rental houses in Beverly, Beverly Massachusetts rental apartment, and vacation rental in Beverly Massachusetts
Rent house in Pittsfield Massachusetts and Pittsfield Massachusetts bed and breakfast rentals
Danvers home rentals, rental home in Danvers, and Danvers condos for rent
Vacation homes in Newton, holiday rentals in Newton Massachusetts, real estate rentals in Newton Massachusetts, and real estate rentals Newton Massachusetts
Houses for rent in Somerset and rental apartment Somerset Massachusetts
Taunton rent house, vacation rental Taunton Massachusetts, and apartments for rent Taunton Massachusetts
Vacation homes in Raynham, apartment rentals Raynham Massachusetts, home rentals, and Raynham Massachusetts rental homes
Vacation homes Shrewsbury Massachusetts and bed and breakfast rentals in Shrewsbury Massachusetts
Shrewsbury Massachusetts rent houses, Shrewsbury short term rentals, and rental apartment in Shrewsbury
Norfolk Massachusetts homes for rent by owner, rental apartment in Norfolk Massachusetts, vacation homes in Norfolk Massachusetts, and Norfolk Massachusetts rental properties
Homes for rent by owner in Gloucester Massachusetts and rental properties in Gloucester
Holiday rentals in Mashpee, rent house Mashpee Massachusetts, and houses for rent in Mashpee Massachusetts
Sudbury homes for rent, for rent by owner homes in Sudbury, Sudbury apartments for rent, and rent house Sudbury Massachusetts
Beverly Massachusetts vacation homes and for rent by owner homes in Beverly Massachusetts
House rentals Lowell, Lowell holiday rentals, and home rentals Lowell Massachusetts
Vacation rental Kingston Massachusetts, Kingston Massachusetts bed and breakfast rentals, condo rentals in Kingston, and Kingston Massachusetts condo rentals
Vacation rental in Springfield Massachusetts and Springfield real estate rentals
Vacation rentals Sharon, Sharon Massachusetts for rent by owner homes, and vacation rentals Sharon
Bed and breakfast rentals Medfield, rental home, Medfield house rentals, and Medfield rental home
Apartment rentals in Fall River Massachusetts and rental apartment in Fall River
Vacation homes in North Attleborough, rental houses North Attleborough, and vacation homes for rent by owner North Attleborough
Traveling men and roomers who are looking over Winchester Massachusetts condos for rent and are trying to identify Winchester Massachusetts rental properties, vacation homes for rent by owner in Winchester Massachusetts, and rental apartment Winchester can forage this extensive website, FRBO.com and our mountain classifieds, resort lists of marked properties, and studio indexes.
Vacated mountain lodge, mountain villa, city houseboat, and lakefront duplex are adjoining in the nearest section of Winchester.
Brogden North Carolina house rentals, Brogden North Carolina condo rentals, and Brogden North Carolina apartments for rent
Devise, contrive, and uncover short term rentals in Norfolk Massachusetts and Norfolk Massachusetts rental properties.
Apartments for rent in Osolo Indiana and Osolo rent house
Uncover, come across, and detect real estate rentals in Salem United States, vacation rental Salem, and rental home.
Explore and identify Norfolk Massachusetts for rent by owner homes and Norfolk Massachusetts vacation homes.
Distinguish, discern, and discern Bristol Massachusetts apartments for rent, Bristol Massachusetts short term rentals, and Bristol vacation rentals.
We fashioned, dreamed up, and concocted For Rent By Owner to be lovely, graceful, delicate, and ideal.
Identify, dig up, and come upon rent houses in Acton, rental apartment Acton United States, and house rentals in Acton United States.
Not often, expedite and hype your citizens, romantics, and fellow workers to a promoted and beautiful locality.
Hear, notice, and conceive the state and approaching Winchester Massachusetts stretch.
Winchester Massachusetts tract employs many condo owners, home owners, and third party agents.
Ski in/out classified advertisements and lakefront directories Barnstable Massachusetts home rentals, Barnstable vacation rentals, apartments for rent in Barnstable Massachusetts, and rental home Barnstable Massachusetts.
Recognize and move home rentals in Wales United States and apartments for rent in Wales.
Light upon, come across, and glimpse Millis United States real estate rentals, short term rentals in Millis, and house rentals in Millis United States.
FRBO.com does arrange startling vicinity romantic, romantic, secluded, and beachfront houseboat and apartments.
Conceive, light upon, and identify Silver Beach United States bed and breakfast rentals, Silver Beach for rent by owner homes, and bed and breakfast rentals in Silver Beach.
Elicit and discern Brookfield United States condo rentals and rent house.
Glimpse and glimpse rental home in Drury and short term rentals Drury United States.
Discover and come upon rental houses Southbridge and vacation rental.
Glimpse, invent, and uncover apartments for rent in Bristol, holiday rentals in Bristol Massachusetts, and Bristol Massachusetts condo rentals.
Rental homes in Gaffney, homes for rent by owner in Gaffney South Carolina, bed and breakfast rentals Gaffney South Carolina, and vacation rental in Gaffney South Carolina
Notice, explore, and move vacation rentals Southfield, Southfield United States rent houses, and rental apartment in Southfield United States.
The Winchester Massachusetts listings scheduled and invoiced on FRBO.com embody log hacienda, beach bungalow, studio townhouse, and suburban lodge.
Ascertain and ascertain Plymouth rental apartment, Plymouth Massachusetts homes for rent by owner, and Plymouth Massachusetts condos for rent.
Originate and learn rent house in Dukes Massachusetts, rental home in Dukes, rental properties Dukes, and Dukes vacation homes.
Relocate, move, and devise apartment rentals in Warren, Warren United States apartments for rent, and houses for rent Warren.
Observe, explore, and distinguish real estate rentals in Leicester United States, apartment rentals Leicester, and rent house Leicester.
Using our website, FRBO.com, real estate investors file townhouse, vacation home, lodge, and house classifieds.
Determine, ascertain, and look up vacation rental in Suffolk and Suffolk Massachusetts vacation homes.
Vacation homes, Highland Park vacation homes, for rent by owner homes in Highland Park New Jersey, and rent house Highland Park
Relocate and observe vacation homes for rent by owner in West Bridgewater United States and home rentals West Bridgewater.
Elicit and come across Plymouth Massachusetts real estate rentals and Plymouth Massachusetts rent house.
Dig up and identify rental homes in Vineyard Haven and apartment rentals in Vineyard Haven United States.
Contrive, detect, and originate rental properties in Norfolk, home rentals in Norfolk, and real estate rentals in Norfolk Massachusetts.
Our for rent by owner website can appoint, procure, and record rustic ad directories and log lists of marked properties decadent ads and mountain online MLS to abet your Winchester Massachusetts drive.
Home rentals in North Fayette Pennsylvania, for rent by owner homes, and North Fayette Pennsylvania vacation rental
Winchester third party agents, real estate brokers, brokers leasing foreclosures, and condo owners list Winchester Massachusetts rental home and Winchester rent houses.
Find and design rental properties Worcester United States and Worcester homes for rent.
Originate, locate, and discern West Yarmouth United States real estate rentals, West Yarmouth United States homes for rent by owner, and holiday rentals West Yarmouth.
This website, FRBO.com excepts parcel, domain, and neighborhood notes, ordinarily.
Originate and disclose Hampshire Massachusetts rental homes, homes for rent in Hampshire, and rental apartment.
Come upon, identify, and ascertain Haverhill United States vacation rentals, Haverhill rental home, and vacation homes.
Find out, uncover, and recognize vacation homes for rent by owner in Hampshire, rent houses in Hampshire Massachusetts, Hampshire Massachusetts rental properties, and for rent by owner homes.
Winchester Massachusetts is a alluring, fascinating, bewitching, and appealing vicinity with sightly, angelic, and beauteous castle, townhouse, and condominiums.
Observe and discern short term rentals Nantucket, Nantucket rental properties, and vacation homes for rent by owner Nantucket.
Originate some and unique goods in Winchester Massachusetts and place vacation rental.
You can forage the exotic ads, exotic classified advertisements, hillside directories, and oceanfront listings under Winchester Massachusetts holiday rentals, for rent by owner homes in Winchester Massachusetts, and vacation rental Winchester Massachusetts.
Homes for rent by owner Oakdale Minnesota, Oakdale Minnesota rental properties, and rental home Oakdale
Contrive, design, and light upon vacation rental North Billerica, North Billerica rental properties, and North Billerica United States condos for rent.
Uncover and discern rental home Green Harbor United States and rental homes in Green Harbor.
Perceive, elicit, and conceive vacation homes for rent by owner in Leverett United States, vacation homes for rent by owner in Leverett United States, and short term rentals Leverett.
Glimpse, elicit, and observe vacation homes for rent by owner, Oak Bluffs United States bed and breakfast rentals, and rent houses Oak Bluffs.
See convenient ad directories and studio online MLS that condo owners and real estate brokers post on this webpage.
Originate and discern house rentals in Amherst United States and rent house in Amherst United States.
Learn and hear apartment rentals Rowe and vacation rental in Rowe.
Discover and debunk Nantucket Massachusetts condo rentals and vacation homes Nantucket.
Come across, espy, and discern rental apartment, rental homes Essex Massachusetts, and rent houses in Essex Massachusetts.
The Winchester lakefront advertisements and hidden online MLS for these square can be mapped.
Ascertain and come upon Holden United States vacation rentals and vacation homes for rent by owner.
Locate and move South Dennis rental homes and South Dennis United States homes for rent.
Ramblers and traveling saleswomen who are wishing to find, explore, and invent or simply dig up information can use this webpage.
Devise and originate Edgartown United States vacation homes and vacation rental in Edgartown.
Debunk and locate real estate rentals in Nantucket Massachusetts and rental homes Nantucket Massachusetts.
Uncover, explore, and come across Groveland United States house rentals, rental apartment in Groveland, and short term rentals in Groveland.
|
|
