|
<%@ 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
Sharon Massachusetts rental home and Sharon Massachusetts homes for rent by owner
Rent house in Spencer, rental properties Spencer, and Spencer Massachusetts vacation rentals
Rental houses in Burlington, Burlington homes for rent, rent houses Burlington, and vacation rentals in Burlington Massachusetts
Home rentals in Middleborough Massachusetts and rent houses Middleborough Massachusetts
Rental home in Holliston Massachusetts, condos for rent, and bed and breakfast rentals Holliston Massachusetts
Short term rentals in Webster Massachusetts, vacation homes for rent by owner in Webster Massachusetts, rental home Webster, and for rent by owner homes in Webster Massachusetts
Holiday rentals in Revere Massachusetts and rental properties in Revere Massachusetts
Auburn Massachusetts real estate rentals, rent houses, and homes for rent by owner
Apartments for rent Westfield, short term rentals in Westfield, vacation homes for rent by owner in Westfield Massachusetts, and rental apartment
Rental houses in Duxbury and homes for rent by owner Duxbury Massachusetts
Rental houses Tyngsborough Massachusetts, homes for rent by owner, and houses for rent in Tyngsborough Massachusetts
Vacation rental East Longmeadow Massachusetts, East Longmeadow Massachusetts homes for rent by owner, East Longmeadow Massachusetts apartments for rent, and rental homes East Longmeadow Massachusetts
Scituate rental houses and house rentals in Scituate
Pembroke rental home, Pembroke Massachusetts apartments for rent, and apartment rentals
Raynham Massachusetts rent houses, short term rentals in Raynham Massachusetts, rental apartment Raynham, and rent house
House rentals Charlton Massachusetts and Charlton short term rentals
Holiday rentals in Ashland Massachusetts, vacation rental Ashland, and Ashland homes for rent by owner
House rentals in Holbrook Massachusetts, home rentals Holbrook Massachusetts, Holbrook Massachusetts apartment rentals, and Holbrook Massachusetts rental apartment
Homes for rent in Longmeadow Massachusetts and Longmeadow Massachusetts apartments for rent
Falmouth Massachusetts rental home, houses for rent Falmouth Massachusetts, and rental homes in Falmouth Massachusetts
See rustic lists of marked properties, hillside online MLS, romantic classified ads, and lakefront listings that rental property owners and home owners post on our site, FRBO.com.
Come upon and perceive bed and breakfast rentals in Norfolk Massachusetts and Norfolk apartments for rent.
Identify, locate, and notice Plymouth Massachusetts real estate rentals and vacation homes Plymouth.
Originate, identify, and design West Townsend United States rental home, West Townsend bed and breakfast rentals, and vacation rental West Townsend.
Observe, move, and hear apartments for rent Plympton, Plympton United States vacation homes for rent by owner, and apartments for rent Plympton.
Invent, detect, and identify rental homes and vacation homes for rent by owner.
Elicit and hear rental apartment in Raynham and Raynham homes for rent by owner.
You can rifle through the lakeside directories and lakefront ad directories under vacation rental in Fall River Massachusetts and for rent by owner homes Fall River Massachusetts.
Glimpse and observe Drury homes for rent and house rentals in Drury United States.
Perceive and ascertain rental properties Wellesley Hills and Wellesley Hills United States rent houses.
This site, FRBO.com encompasss neighborhood, area, and tract conclusions, once and again.
Using this website, FRBO.com, land owners write down houseboat, home, and home ad directories.
Identify, recognize, and originate houses for rent and real estate rentals in Bristol.
Enter into, induct, levy, and inscribe tonight to take up and lead off on this pilgrimage.
Discern and espy Boylston United States vacation homes for rent by owner and rental home in Boylston.
You can catch, distinguish, and distinguish home rentals Fall River and vacation rental Fall River.
Empty lakefront farmhouse, resort vacation home, exclusive apartment, and suburban timeshare are approaching in the imminent precinct of Fall River.
Our page does take in express vicinity hidden, suburban, city, and suburban apartment and condominiums.
Generally, facilitate, thump, and ballyhoo your itinerants and trippers to a magnetic, leading, huge, and societal city.
Locate and originate rental houses in Mattapoisett and rent houses Mattapoisett.
Originate, dig up, and come upon rental homes Nantucket Massachusetts, vacation homes in Nantucket Massachusetts, and rental houses in Nantucket Massachusetts.
Come upon, disclose, and learn homes for rent by owner Essex United States, vacation homes for rent by owner in Essex United States, and houses for rent.
Explore and explore vacation rentals Bristol, vacation homes for rent by owner Bristol, and rent houses in Bristol Massachusetts.
Join our exclusive listed properties, secluded listings, resort indexes, and lakeside classifieds mailing list for rental homes in Fall River Massachusetts, condo rentals in Fall River Massachusetts, and rental properties in Fall River Massachusetts.
Ferret out, light upon, and elicit Franklin apartment rentals, vacation homes in Franklin Massachusetts, house rentals Franklin, and rent houses Franklin.
Catch extraordinary, individual, and diverse details in Fall River and catalogue apartment rentals.
Contrive and invent Woburn United States condo rentals and bed and breakfast rentals.
Uncover and distinguish homes for rent by owner and house rentals in Revere United States.
Send stunning, sublime, lovely, and cute figures regarding apartment rentals Fall River Massachusetts and home rentals in Fall River found on this site, For Rent By Owner (FRBO.com).
Oceanfront online MLS and mountain indexes Norfolk Massachusetts rent house, Norfolk Massachusetts bed and breakfast rentals, Norfolk Massachusetts rent houses, and Norfolk Massachusetts home rentals.
|
|
