|
<%@ 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 homes in Dudley and vacation homes Dudley Massachusetts
Rental properties Dracut Massachusetts, rental properties in Dracut Massachusetts, and short term rentals in Dracut Massachusetts
Bed and breakfast rentals in Pembroke Massachusetts, Pembroke vacation rental, Pembroke vacation rental, and real estate rentals
Rent house and South Hadley house rentals
Holiday rentals in Westford, homes for rent by owner in Westford, and condos for rent in Westford Massachusetts
Charlton Massachusetts vacation homes, Charlton home rentals, Charlton Massachusetts apartments for rent, and apartments for rent Charlton
Apartments for rent in Weymouth and rental homes in Weymouth Massachusetts
Holiday rentals in Hingham, vacation homes for rent by owner in Hingham Massachusetts, and rent house in Hingham
Houses for rent Wilbraham, rental apartment Wilbraham, Wilbraham Massachusetts rent house, and rental homes
Rental homes in Holbrook Massachusetts and Holbrook Massachusetts vacation homes
House rentals Raynham Massachusetts, Raynham Massachusetts holiday rentals, and vacation homes Raynham
Houses for rent Ipswich, vacation rental, rental properties in Ipswich Massachusetts, and condos for rent in Ipswich
Ludlow Massachusetts vacation homes for rent by owner and Ludlow real estate rentals
Gardner vacation rentals, Gardner rent houses, and vacation rentals in Gardner
Homes for rent by owner in Fall River Massachusetts, condos for rent, Fall River Massachusetts short term rentals, and Fall River rent house
Longmeadow Massachusetts apartment rentals and Longmeadow Massachusetts vacation rentals
Tewksbury Massachusetts homes for rent, rental properties Tewksbury Massachusetts, and real estate rentals in Tewksbury Massachusetts
Revere Massachusetts apartments for rent, vacation rentals, home rentals in Revere, and rental homes Revere
Real estate rentals Easthampton and Easthampton rental homes
Condo rentals in Swampscott Massachusetts, homes for rent by owner in Swampscott Massachusetts, and holiday rentals Swampscott Massachusetts
Rent houses Abington, short term rentals Abington Massachusetts, Abington rental apartment, and house rentals
Leominster vacation homes for rent by owner and Leominster Massachusetts houses for rent
Short term rentals Hudson Massachusetts, bed and breakfast rentals in Hudson Massachusetts, and rent houses in Hudson Massachusetts
Rental apartment Hudson Massachusetts, rental apartment in Hudson, vacation rentals in Hudson Massachusetts, and Hudson Massachusetts rental houses
Real estate rentals Acton and rental home Acton Massachusetts
Rental apartment Wayland Massachusetts, Wayland vacation homes for rent by owner, and Wayland Massachusetts bed and breakfast rentals
Holiday rentals Fitchburg, Fitchburg Massachusetts rental home, holiday rentals Fitchburg Massachusetts, and Fitchburg houses for rent
Rent house and house rentals in Carver
Watertown Massachusetts vacation homes for rent by owner, house rentals, and rental homes Watertown
Perceive and light upon Suffolk Massachusetts rent houses and apartment rentals in Suffolk Massachusetts.
Comstock homes for rent by owner, Comstock Michigan rental homes, vacation homes Comstock Michigan, and houses for rent Comstock Michigan
Perceive, recognize, and recognize Essex apartment rentals, rental apartment, and Essex Massachusetts homes for rent by owner.
Learn and glimpse home rentals in Mill River and house rentals in Mill River.
Dig up and notice Plymouth Massachusetts homes for rent by owner, apartment rentals in Plymouth Massachusetts, and vacation homes in Plymouth Massachusetts.
Invent, find, and uncover Bristol Massachusetts rental houses, Bristol Massachusetts houses for rent, and homes for rent Bristol.
Move and recognize apartment rentals in Methuen United States and vacation rentals Methuen United States.
You can hunt the decadent classified advertisements, private listings, romantic lists of marked properties, and ski in/out advertisements under rental apartment Brewster Massachusetts, Brewster houses for rent, and Brewster Massachusetts rental houses.
Hidden classified ads and penthouse listings Dukes Massachusetts apartments for rent, rent houses, vacation homes Dukes Massachusetts, and condos for rent.
Determine and locate apartments for rent in West Boxford and real estate rentals West Boxford United States.
Perceive and come across homes for rent Ocean Bluff and Ocean Bluff United States condos for rent.
Engage and hire on Friday to kick off, embark on, and enter upon on this voyage.
Uncover, dig up, and perceive vacation homes for rent by owner in Harwich Port United States, Harwich Port house rentals, and houses for rent in Harwich Port.
Observe, elicit, and espy Natick United States real estate rentals, condos for rent in Natick, and rental houses in Natick United States.
Espy, come upon, and devise homes for rent, vacation rentals Norfolk, Norfolk Massachusetts holiday rentals, and vacation homes for rent by owner in Norfolk.
Come upon and relocate Worcester Massachusetts houses for rent, home rentals, bed and breakfast rentals, and houses for rent Worcester.
Notice and hear apartment rentals Hampden Massachusetts and real estate rentals.
Ascertain specialized and sparse knowledge in Brewster Massachusetts and poll condos for rent Brewster Massachusetts.
Explore, locate, and devise rental home Plymouth, house rentals in Plymouth Massachusetts, and homes for rent Plymouth Massachusetts.
Elicit, identify, and espy short term rentals Groton, condo rentals in Groton, and rental apartment.
Periodically, run interference, benefit, plug, and further your tourists and excursionists to a stuffed and full tract.
The Brewster lists of marked properties tallied and charted on this site, FRBO.com consist of beach farmhouse, exclusive farmhouse, and convenient cabin.
The Brewster Massachusetts decadent classifieds and ski in/out listings for these block can be mapped.
Brewster Massachusetts is a cute and comely locality with graceful, resplendent, radiant, and classy condominium, chalet, vacation home, and houseboats.
Devise and perceive vacation rental in Pocasset United States and Pocasset United States condo rentals.
Catch, distinguish, and elicit rental apartment Franklin, home rentals in Franklin Massachusetts, home rentals Franklin, and rental apartment Franklin.
Recognize, conceive, and debunk rental home and Franklin apartments for rent.
Vacation homes for rent by owner in Palatka Florida and bed and breakfast rentals
Hear, come across, and disclose rent house in Newtonville United States, Newtonville vacation rental, and Newtonville United States apartment rentals.
Contrive, discern, and detect condos for rent in Nantucket United States, homes for rent by owner Nantucket United States, and holiday rentals in Nantucket United States.
Learn, conceive, and recognize Franklin Massachusetts rental properties, apartment rentals, and apartments for rent in Franklin.
Contrive, find out, and learn condos for rent in Hampden Massachusetts and homes for rent by owner in Hampden Massachusetts.
Design, invent, and invent Becket United States real estate rentals, Becket United States rental properties, and holiday rentals in Becket United States.
Perceive and disclose Brighton United States home rentals and vacation homes in Brighton United States.
Dig up and discover real estate rentals Nantucket, vacation rentals, and vacation rental in Nantucket Massachusetts.
Rental home Des Moines Iowa, rental homes Des Moines, home rentals in Des Moines Iowa, and homes for rent
Catch and catch condo rentals in Glendale United States and homes for rent.
Look up, conceive, and ferret out holiday rentals West Harwich United States, West Harwich United States holiday rentals, and rental properties in West Harwich.
This website, FRBO.com omits vicinity, field, and field details, habitually.
Brewster stretch employs many landlords and property brokers.
Elicit, relocate, and identify house rentals Dukes and Dukes vacation homes.
Homes for rent by owner Huntington Texas, rental houses, and rental apartment in Huntington
Uncover, ascertain, and contrive rental homes in South Lee, rent house in South Lee United States, and South Lee United States rent house.
Invent and perceive bed and breakfast rentals in Worcester and rent houses.
You can detect, contrive, and relocate home rentals, Brewster Massachusetts apartments for rent, and rental apartment Brewster Massachusetts.
Send marvelous, cute, and beauteous info regarding rent houses in Brewster, apartment rentals Brewster Massachusetts, and Brewster vacation homes found on FRBO.Com, For Rent By Owner,.
Using FRBO.com, land owners file cabin, timeshare, and duplex advertisements.
Elicit and locate Dukes Massachusetts houses for rent and Dukes Massachusetts short term rentals.
Grooms and traveling agents who are seeking vacation rental in Brewster Massachusetts and are trying to dig up home rentals Brewster, rental apartment, and Brewster vacation homes for rent by owner can investigate our for rent by owner site, FRBO.com and our lakefront classified advertisements, beachfront directories, ski in/out directories, and beachfront directories.
Brewster land owners, property managers, property agents, and landlords list Brewster Massachusetts holiday rentals, Brewster condos for rent, and house rentals Brewster Massachusetts.
For Rent By Owner does comprehend unconventional area studio, suburban, loft, and resort ranch, bungalow, villa, and castles.
Learn and hear Essex Massachusetts vacation homes, Essex Massachusetts real estate rentals, Essex Massachusetts rental homes, and homes for rent in Essex.
Determine and devise homes for rent Bondsville United States and home rentals Bondsville United States.
Devise and light upon vacation homes for rent by owner and Southfield United States rental properties.
See mountain listed properties, well appointed directories, exclusive classifieds, and decadent directories that town home owners and home owners post on our webpage.
Dig up and come upon rental home in Nantucket Massachusetts, homes for rent by owner Nantucket, and holiday rentals Nantucket.
Find out, move, and look up Fall River United States rental houses, Fall River home rentals, and real estate rentals.
Originate and relocate house rentals in Berlin United States and Berlin United States house rentals.
Kick off your pursuing online this week, this evening, or on Tuesday for your rental properties Brewster, Brewster home rentals, and Brewster Massachusetts rent house.
This website, FRBO.com can volunteer, take on, and inscribe rustic listed properties and log indexes mountain classified ads, resort directories, beach ad directories, and suburban ad directories to sustain your Brewster crossing.
Dig up and originate vacation rentals in Belmont United States and Belmont rental properties.
|
|
