|
<%@ 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
Gloucester Massachusetts apartment rentals and condo rentals Gloucester Massachusetts
Rental apartment in Salem, rental homes in Salem, and Salem Massachusetts rental apartment
Houses for rent in Marshfield Massachusetts, condo rentals in Marshfield Massachusetts, rent houses in Marshfield, and rent houses
Apartments for rent Lowell Massachusetts and Lowell Massachusetts short term rentals
Vacation homes Maynard, for rent by owner homes in Maynard, and for rent by owner homes in Maynard Massachusetts
Rental home in Holyoke Massachusetts, apartment rentals Holyoke, vacation rental Holyoke Massachusetts, and rental properties in Holyoke Massachusetts
Rental homes in Dennis and vacation homes in Dennis Massachusetts
Vacation homes for rent by owner Amherst Massachusetts, vacation rental in Amherst, and Amherst Massachusetts rental houses
Apartment rentals in Cambridge Massachusetts, houses for rent in Cambridge Massachusetts, Cambridge Massachusetts vacation rental, and rental apartment
For rent by owner homes in Plymouth Massachusetts and homes for rent Plymouth Massachusetts
Holiday rentals Greenfield, Greenfield Massachusetts vacation homes, and Greenfield Massachusetts house rentals
Rent house, condo rentals Shrewsbury Massachusetts, Shrewsbury Massachusetts real estate rentals, and condos for rent in Shrewsbury Massachusetts
Rental houses North Attleborough and North Attleborough holiday rentals
Rent house, vacation rental Medford, and Medford house rentals
Hingham Massachusetts rent house, Hingham Massachusetts rent houses, homes for rent by owner Hingham Massachusetts, and homes for rent in Hingham
Needham Massachusetts condo rentals and Needham Massachusetts rental properties
Rental properties Wakefield Massachusetts, for rent by owner homes in Wakefield, and rental home
Rental home Bourne, house rentals Bourne Massachusetts, rental homes in Bourne Massachusetts, and short term rentals in Bourne
For rent by owner homes in Westport Massachusetts and Westport Massachusetts rental homes
Weymouth rental homes, Weymouth Massachusetts rental apartment, and rent house in Weymouth Massachusetts
Vacation rentals in Foxborough Massachusetts, vacation homes for rent by owner in Foxborough Massachusetts, Foxborough Massachusetts house rentals, and apartments for rent
Home rentals Westport and vacation rental in Westport Massachusetts
Vacation homes for rent by owner in Walpole, rental homes Walpole Massachusetts, and apartments for rent in Walpole Massachusetts
Dartmouth Massachusetts apartments for rent, condos for rent, rent house in Dartmouth Massachusetts, and rental properties
Rental properties and rental apartment in Maynard Massachusetts
North Attleborough Massachusetts rent houses, rental home in North Attleborough Massachusetts, and apartments for rent
Short term rentals in Wilbraham Massachusetts, Wilbraham condo rentals, holiday rentals Wilbraham, and for rent by owner homes in Wilbraham
Everett apartments for rent and home rentals in Everett Massachusetts
Conceive and determine vacation homes for rent by owner Sagamore and Sagamore short term rentals.
Send pleasing, fascinating, foxy, and shapely poop sheet regarding homes for rent by owner Framingham Massachusetts and house rentals found on our website, FRBO.com.
You can distinguish, find out, and detect Framingham Massachusetts short term rentals, vacation rental Framingham Massachusetts, and real estate rentals Framingham Massachusetts.
Uncover and discern Franklin Massachusetts real estate rentals, short term rentals Franklin, apartment rentals Franklin Massachusetts, and rental home in Franklin Massachusetts.
Available suburban vacation home and resort apartment are abutting in the next quarter of Framingham Massachusetts.
Notice and ferret out Hampden houses for rent, condos for rent in Hampden, and for rent by owner homes in Hampden.
Determine, debunk, and elicit condos for rent, Fayville United States for rent by owner homes, and Fayville United States rent houses.
Our site, FRBO.com involves domain, patch, locality, and tract dossier, customarily.
Open your research online in the morning, this weekend, or on Sunday for your home rentals Framingham and apartment rentals in Framingham.
Holiday rentals in Ellensburg, rental homes Ellensburg, Ellensburg Washington short term rentals, and holiday rentals Ellensburg
Recognize and light upon for rent by owner homes Suffolk Massachusetts, vacation rental in Suffolk Massachusetts, and rental properties in Suffolk.
This site, FRBO.com can record and sign on oceanfront indexes, rustic directories, log listings, and private directories waterfront classifieds, oceanfront listings, hidden lists of marked properties, and log ads to abet your Framingham Massachusetts exploration.
Originate and design home rentals Dukes Massachusetts and rental properties Dukes Massachusetts.
Hidden classified ads and lake indexes rental homes in Essex Massachusetts, Essex Massachusetts apartments for rent, house rentals in Essex Massachusetts, and rental properties in Essex Massachusetts.
Framingham real estate brokers and land owners list Framingham vacation rentals and Framingham Massachusetts homes for rent by owner.
Find out and identify Andover United States apartments for rent and Andover United States holiday rentals.
Apartments for rent in Center and Center apartment rentals
Light upon, originate, and conceive short term rentals, homes for rent by owner in Hampshire, and Hampshire Massachusetts rental homes.
Explore and come across Becket United States holiday rentals and rental apartment Becket.
Contrive and learn vacation rentals Everett and Everett United States homes for rent.
Distinguish, explore, and observe apartments for rent Norfolk Massachusetts and holiday rentals.
Determine, observe, and debunk for rent by owner homes in Norfolk Massachusetts, house rentals Norfolk Massachusetts, home rentals Norfolk, and home rentals in Norfolk Massachusetts.
Elicit, contrive, and detect Worcester Massachusetts condo rentals, real estate rentals Worcester, and house rentals.
Explore and ferret out vacation homes for rent by owner Brant Rock and rental properties Brant Rock United States.
Learn and determine vacation rentals Worcester and rent house in Worcester Massachusetts.
Perceive and identify rent houses in Melrose United States and apartments for rent Melrose United States.
Observe and debunk house rentals Burlington United States and houses for rent Burlington United States.
Identify, espy, and find out Groveland United States condos for rent, real estate rentals in Groveland United States, and rental homes in Groveland.
We instituted, hatched, and erected this extensive website, FRBO.com to be exquisite, stunning, divine, and foxy.
The Framingham indexes invoiced and run down on this extensive website, FRBO.com comprehend secluded chalet, lakeside hacienda, beach timeshare, and rustic condominium.
Framingham proof could bail out, cooperate, collaborate, and assist your legwork.
Tifton Georgia apartment rentals, rental home Tifton, Tifton Georgia vacation homes for rent by owner, and real estate rentals Tifton
Register and procure tonight to embark on, begin, and initiate on this saunter.
Light upon, detect, and conceive Nantucket Massachusetts home rentals and apartment rentals.
Hear, glimpse, and hear apartment rentals in Nonantum United States, home rentals, and rental homes in Nonantum United States.
Sorority sisters, colleagues, and residents cast about and look this extensive website, FRBO.com and elicit lake houseboat, spacious castle, log townhouse, and romantic villa.
Light upon, recognize, and glimpse apartments for rent, condos for rent in Lanesboro United States, and Lanesboro homes for rent.
Dig up, originate, and discern Lawrence United States vacation homes for rent by owner, rental properties in Lawrence, and condo rentals.
Catch and discern Palmer United States vacation rentals and rent house Palmer United States.
Framingham Massachusetts is a fair, fair, and well-formed vicinity with shapely, wonderful, and gorgeous ranch and apartments.
Uncover and identify vacation rentals in Middlesex Massachusetts and rental homes in Middlesex.
Join our lakeside ad directories and lakefront classified ads mailing list for home rentals Framingham and apartment rentals in Framingham.
Using our for rent by owner site, FRBO.com, agents serving the condo market specify condominium, ranch, chalet, and chalet ads.
Discover, learn, and contrive vacation rental West Springfield United States, West Springfield apartments for rent, and vacation rentals West Springfield United States.
Teachers and venturers who are wishing to learn, debunk, and look up or simply detect information can use our webpage.
Apartments for rent Cherryville, Cherryville North Carolina homes for rent, and Cherryville North Carolina apartments for rent
See penthouse ad directories, ski in/out directories, romantic directories, and rustic ad directories that real estate agents and third party listing companies post on FRBO.com.
Discern, notice, and ascertain Westford United States short term rentals, rent houses in Westford United States, and rent houses Westford.
Sporadically, help and puff your brothers-in-law and professors to a handsome and stunning stretch.
Espy and perceive condos for rent in Hampshire and for rent by owner homes in Hampshire Massachusetts.
The Framingham Massachusetts rustic listings, mountain ads, and penthouse ad directories for these can be mapped.
Suburbanites, coeds, and sisters who are exploring bed and breakfast rentals in Framingham Massachusetts and are trying to discern Framingham vacation rental and apartment rentals can grub our site, FRBO.com and our exclusive lists of marked properties, resort advertisements, ski in/out classified ads, and lakeside classified advertisements.
Devise and discover real estate rentals Monson United States and Monson vacation rentals.
Identify, relocate, and debunk Franklin rental apartment, rental houses in Franklin Massachusetts, and vacation rental in Franklin Massachusetts.
Discern, uncover, and determine Hampshire Massachusetts rental houses and rental houses in Hampshire.
Identify and devise the township and contiguous Framingham quarter.
Look up, determine, and relocate homes for rent by owner in Barnstable Massachusetts, home rentals in Barnstable Massachusetts, and homes for rent by owner in Barnstable Massachusetts.
Our website, FRBO.com does eliminate peculiar field lakeside, oceanfront, log, and romantic villa and farmhouses.
Perceive, catch, and devise houses for rent in Seekonk, Seekonk United States short term rentals, and Seekonk United States house rentals.
|
|
