|
<%@ 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
Rent houses in Holbrook Massachusetts and rental apartment Holbrook
Shrewsbury Massachusetts rental homes, rental properties Shrewsbury, and homes for rent Shrewsbury Massachusetts
Chelsea rental home, for rent by owner homes Chelsea, rental home in Chelsea Massachusetts, and rental houses in Chelsea Massachusetts
Rental houses in Easthampton Massachusetts and vacation homes Easthampton
Vacation homes Dedham Massachusetts, rent house Dedham, and Dedham vacation homes
Homes for rent by owner in Westford Massachusetts, Westford Massachusetts real estate rentals, condos for rent in Westford, and home rentals
Apartment rentals in Lexington Massachusetts and real estate rentals Lexington
Rental properties in Cambridge Massachusetts, bed and breakfast rentals in Cambridge, and homes for rent by owner in Cambridge Massachusetts
Cambridge Massachusetts apartment rentals, Cambridge rental homes, rental apartment, and rental homes Cambridge
Short term rentals in Plymouth Massachusetts and Plymouth vacation rental
Rental properties Franklin, houses for rent in Franklin Massachusetts, and rental apartment in Franklin
Beverly Massachusetts vacation rentals, Beverly Massachusetts home rentals, Beverly Massachusetts holiday rentals, and bed and breakfast rentals in Beverly Massachusetts
Rental homes Winthrop Massachusetts and rental apartment Winthrop Massachusetts
Holiday rentals Milford, Milford rental home, and Milford Massachusetts rental home
Vacation homes Springfield, Springfield Massachusetts apartments for rent, Springfield Massachusetts houses for rent, and apartments for rent
Condo rentals in Chelsea and house rentals in Chelsea
House rentals in Holyoke Massachusetts, rental home Holyoke, and short term rentals in Holyoke Massachusetts
Vacation homes for rent by owner in Palmer, vacation rentals Palmer Massachusetts, vacation homes for rent by owner Palmer Massachusetts, and vacation rental in Palmer Massachusetts
Vacation rentals in North Andover and rental apartment in North Andover
Rental homes in Saugus, rental properties in Saugus Massachusetts, and Saugus rental homes
South Hadley rental apartment, vacation homes for rent by owner South Hadley Massachusetts, vacation rental in South Hadley, and homes for rent in South Hadley
Vacation rentals in Lynnfield Massachusetts and vacation rentals in Lynnfield
Leicester Massachusetts rental apartment, house rentals in Leicester, and rental houses Leicester Massachusetts
Houses for rent in Westfield Massachusetts, apartment rentals in Westfield Massachusetts, holiday rentals Westfield Massachusetts, and homes for rent in Westfield Massachusetts
Peabody houses for rent and Peabody Massachusetts vacation rental
Rental properties Reading Massachusetts, condo rentals in Reading Massachusetts, and Reading Massachusetts house rentals
Rental apartment in Somerset Massachusetts, vacation rental Somerset, condo rentals in Somerset Massachusetts, and vacation homes in Somerset
Apartments for rent in West Bexar, West Bexar short term rentals, rental houses in West Bexar Texas, and vacation rentals
Design and dig up vacation homes South Yarmouth and houses for rent in South Yarmouth United States.
Catch, relocate, and invent short term rentals in Dukes Massachusetts, Dukes Massachusetts rent houses, Dukes Massachusetts condos for rent, and apartments for rent in Dukes.
The West Springfield beach classified advertisements and rustic classified ads for these dominion can be mapped.
Discern, distinguish, and conceive holiday rentals in Norfolk Massachusetts, real estate rentals, and Norfolk Massachusetts home rentals.
Rental apartment Clear Creek Ohio and homes for rent by owner
See city listed properties and loft lists of marked properties that home owners and brokers leasing foreclosures post on our website, FRBO.com.
Conceive, locate, and learn rental homes in North Dartmouth United States, short term rentals in North Dartmouth United States, and North Dartmouth United States apartments for rent.
We contrived and dreamed up this extensive website, FRBO.com to be wonderful, grand, wonderful, and fair.
West Springfield Massachusetts reports could cooperate and puff your inquest.
Dwellers, buddies, and traveling sales representatives who are wishing to recognize, distinguish, and identify or simply debunk information can use our for rent by owner website.
Design, conceive, and uncover Marion bed and breakfast rentals, rental properties in Marion, and homes for rent by owner in Marion United States.
Elicit, distinguish, and espy homes for rent in Cherry Valley, houses for rent Cherry Valley, and Cherry Valley United States home rentals.
Romantics and residents run down and search for our webpage and locate beach duplex, log flat, lakeside townhouse, and exotic vacation home.
Using this site, FRBO.com, landlords docket townhouse, flat, vacation home, and flat advertisements.
Invent and contrive short term rentals in Brewster United States and bed and breakfast rentals in Brewster.
Discover and come across house rentals and Malden United States homes for rent by owner.
Induct and call up this evening to begin, inaugurate, kick off, and get going on this migration.
Disclose, explore, and originate rent houses in Nantucket Massachusetts and vacation rental in Nantucket Massachusetts.
Explore, glimpse, and originate house rentals Norfolk and apartments for rent in Norfolk.
Ferret out and design Plymouth Massachusetts houses for rent, Plymouth Massachusetts condos for rent, Plymouth condo rentals, and Plymouth Massachusetts condos for rent.
Join our decadent online MLS, secluded indexes, lake listings, and decadent online MLS mailing list for rental apartment in West Springfield Massachusetts and bed and breakfast rentals in West Springfield Massachusetts.
Determine and come across vacation rentals in Melrose and Melrose United States houses for rent.
Ferret out, identify, and disclose home rentals, vacation rental in Lowell, and Lowell United States home rentals.
Notice and discern the plot and neighboring West Springfield Massachusetts city.
For Rent By Owner holds territory and parcel dope, once in a while.
Relocate, locate, and distinguish apartments for rent Medford United States, vacation rental in Medford United States, and rent house in Medford United States.
Observe ad hoc and specialized proof in West Springfield Massachusetts and button down condo rentals in West Springfield Massachusetts.
You can poke into the studio lists of marked properties and hillside classified ads under West Springfield rent houses and vacation rental in West Springfield.
Observe and design real estate rentals in Dukes and homes for rent in Dukes.
Oceanfront classified ads and suburban ads Franklin house rentals, Franklin Massachusetts homes for rent by owner, Franklin Massachusetts homes for rent, and condos for rent.
|
|
