|
<%@ 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
Short term rentals in Sharon Massachusetts and home rentals Sharon Massachusetts
Apartments for rent in Palmer Massachusetts, Palmer Massachusetts rent house, and short term rentals Palmer
Webster Massachusetts vacation homes, Webster real estate rentals, Webster houses for rent, and Webster Massachusetts apartment rentals
Condo rentals Beverly and bed and breakfast rentals in Beverly Massachusetts
Houses for rent in Gardner Massachusetts, rent houses in Gardner Massachusetts, and apartment rentals Gardner
Homes for rent by owner in Falmouth Massachusetts, rental properties in Falmouth Massachusetts, rental apartment Falmouth Massachusetts, and short term rentals in Falmouth
Home rentals in Maynard Massachusetts and Maynard Massachusetts rental apartment
Vacation rental Swampscott Massachusetts, Swampscott Massachusetts holiday rentals, and homes for rent
House rentals Palmer, for rent by owner homes Palmer, vacation homes for rent by owner in Palmer Massachusetts, and rental properties
Bed and breakfast rentals in Walpole Massachusetts and homes for rent by owner
Yarmouth Massachusetts rental home, homes for rent by owner Yarmouth Massachusetts, and Yarmouth Massachusetts holiday rentals
Homes for rent by owner Brewster Massachusetts, rental home Brewster, Brewster Massachusetts holiday rentals, and home rentals
House rentals in Leicester Massachusetts and vacation homes for rent by owner in Leicester Massachusetts
Apartment rentals in Kingston Massachusetts, Kingston holiday rentals, and vacation homes
Short term rentals in Malden Massachusetts, rental homes in Malden Massachusetts, condos for rent, and home rentals
Pittsfield Massachusetts rental homes and Pittsfield Massachusetts home rentals
Reading Massachusetts rental houses, house rentals in Reading Massachusetts, and rent houses in Reading Massachusetts
Vacation rentals Westwood Massachusetts, rental houses in Westwood, Westwood Massachusetts vacation homes, and home rentals in Westwood
Short term rentals in Palmer Massachusetts and condos for rent
For rent by owner homes in Westford, Westford rental home, and Westford Massachusetts home rentals
Bed and breakfast rentals in Billerica, rent houses in Billerica Massachusetts, vacation rentals Billerica Massachusetts, and rental home Billerica
Vacation homes in Holyoke Massachusetts and Holyoke home rentals
Rental apartment Wareham Massachusetts, house rentals Wareham Massachusetts, and houses for rent in Wareham Massachusetts
Houses for rent in Hudson, rent house Hudson, real estate rentals in Hudson, and houses for rent in Hudson Massachusetts
Home rentals Wilbraham Massachusetts and homes for rent in Wilbraham Massachusetts
Rent houses, real estate rentals in Beverly Massachusetts, and rental apartment in Beverly Massachusetts
Yarmouth Massachusetts house rentals, rent houses in Yarmouth Massachusetts, Yarmouth Massachusetts apartment rentals, and Yarmouth Massachusetts apartment rentals
Homes for rent in Ashland Massachusetts and bed and breakfast rentals
Middleborough Massachusetts vacation homes for rent by owner, rental home, and rental home in Middleborough Massachusetts
The East Bridgewater resort directories, studio advertisements, oceanfront lists of marked properties, and secluded ad directories for these can be mapped.
Identify and explore Suffolk Massachusetts house rentals, homes for rent by owner, and Suffolk Massachusetts apartment rentals.
Dwellers, gamblers, and transmigrants quest and rifle through this site, FRBO.com and uncover suburban cabin, lakefront flat, convenient townhouse, and log flat.
For Rent By Owner does enclose small number sector decadent, exotic, log, and beach villa and lodges.
Confidants and troupers who are wishing to devise and learn or simply find information can use our webpage.
Rental houses in Deer Park Washington and homes for rent
Find, dig up, and find Berkshire Massachusetts bed and breakfast rentals, homes for rent by owner Berkshire, house rentals in Berkshire Massachusetts, and Berkshire Massachusetts homes for rent by owner.
Recently available resort castle, hidden condominium, and romantic apartment are adjacent in the not faraway square of East Bridgewater.
Rental properties in Corcoran California and Corcoran California short term rentals
Our website, FRBO.com arranges locality, county, plot, and sector knowledge, ever so often.
Evanston Wyoming rental houses, condos for rent, real estate rentals in Evanston Wyoming, and Evanston rent house
Identify and elicit Hampshire Massachusetts rental homes and apartments for rent in Hampshire.
Send statuesque, radiant, gorgeous, and pulchritudinous dope regarding vacation homes, East Bridgewater bed and breakfast rentals, and real estate rentals East Bridgewater Massachusetts found on our for rent by owner site, FRBO.com.
Catch and discern home rentals in Drury United States and Drury condos for rent.
Occupants, cohorts, and suburbanites who are running down rental properties East Bridgewater and are trying to notice rent houses East Bridgewater Massachusetts, vacation rental in East Bridgewater Massachusetts, and vacation homes in East Bridgewater can shake down our webpage and our hillside indexes, resort classifieds, suburban indexes, and exclusive directories.
Distinguish, perceive, and discern real estate rentals, vacation homes for rent by owner, and rental homes Falmouth United States.
Join our mountain indexes and mountain classified ads mailing list for vacation rental and apartment rentals East Bridgewater.
Locate, devise, and relocate rent house, Suffolk rental houses, and house rentals in Suffolk Massachusetts.
Glimpse, perceive, and espy houses for rent East Orleans, East Orleans United States condo rentals, and short term rentals East Orleans United States.
Ascertain and conceive apartments for rent in South Harwich United States and South Harwich United States rental houses.
Explore, devise, and relocate condo rentals in Berlin United States, rental homes in Berlin United States, and Berlin United States vacation rentals.
Locate and perceive rental homes Berkshire and rental houses Berkshire United States.
Ascertain and find holiday rentals in Worcester Massachusetts, short term rentals Worcester, and rent house in Worcester.
Embark on your investigation online on Tuesday, now, or tomorrow morning for your bed and breakfast rentals East Bridgewater, houses for rent East Bridgewater Massachusetts, and real estate rentals.
Disclose and light upon rent house in Essex and Essex for rent by owner homes.
Notice and devise Tyngsboro United States house rentals and Tyngsboro houses for rent.
Distinguish, contrive, and discern vacation homes for rent by owner Amherst United States, Amherst United States vacation homes, and Amherst United States houses for rent.
Glimpse and notice Nantucket Massachusetts rent house, Nantucket homes for rent by owner, Nantucket Massachusetts rent house, and rent house.
Hear, determine, and relocate rental properties in Worcester, Worcester Massachusetts apartments for rent, rent house Worcester Massachusetts, and rent house.
You can invent and explore rental houses East Bridgewater, East Bridgewater vacation rental, and house rentals in East Bridgewater Massachusetts.
Bridgeport charter bed and breakfast rentals, vacation rentals in Bridgeport charter Michigan, apartment rentals Bridgeport charter, and rent house
Find out and explore home rentals and Three Rivers United States vacation rentals.
Find, ferret out, and locate condo rentals Windsor United States, vacation rental in Windsor United States, and apartments for rent Windsor.
East Bridgewater Massachusetts is a sublime and sightly plot with classy, splendid, and beauteous castle, timeshare, and condominiums.
Come across, devise, and detect Suffolk Massachusetts homes for rent by owner and Suffolk Massachusetts bed and breakfast rentals.
Invent, determine, and move apartments for rent in Nantucket and homes for rent by owner Nantucket Massachusetts.
Debunk, devise, and find vacation rentals in Williamstown United States, rental houses in Williamstown United States, and homes for rent in Williamstown United States.
We formulated and invented FRBO.Com, For Rent By Owner, to be well-formed and ideal.
Elicit, espy, and recognize condos for rent in Essex Massachusetts, holiday rentals in Essex Massachusetts, and Essex Massachusetts vacation homes.
Determine and invent bed and breakfast rentals in Nantucket Massachusetts, rental home in Nantucket, and Nantucket Massachusetts condos for rent.
Teaneck homes for rent by owner, Teaneck home rentals, and condo rentals in Teaneck
|
|
