|
<%@ 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 Easton and real estate rentals Easton
North Andover Massachusetts homes for rent, bed and breakfast rentals North Andover, and North Andover Massachusetts for rent by owner homes
Shrewsbury Massachusetts houses for rent, apartment rentals, rental apartment Shrewsbury, and vacation homes
Real estate rentals in Agawam Massachusetts and rental homes
Rental home in Fairhaven Massachusetts, rental homes in Fairhaven, and Fairhaven condos for rent
Holliston Massachusetts rental home, for rent by owner homes in Holliston Massachusetts, for rent by owner homes in Holliston Massachusetts, and bed and breakfast rentals
Medford Massachusetts vacation homes for rent by owner and vacation rental in Medford Massachusetts
Rent house, Taunton Massachusetts rental houses, and houses for rent in Taunton Massachusetts
Rental houses Westwood Massachusetts, Westwood Massachusetts rental houses, vacation homes Westwood Massachusetts, and Westwood Massachusetts apartments for rent
Rent house Weston Massachusetts and real estate rentals in Weston
Norwood vacation rental, rent house in Norwood, and bed and breakfast rentals
Condos for rent in Canton Massachusetts, apartment rentals in Canton, Canton condo rentals, and home rentals Canton
Tyngsborough Massachusetts condos for rent and real estate rentals Tyngsborough Massachusetts
Holiday rentals, vacation homes, and real estate rentals in Fairhaven Massachusetts
Holiday rentals in Lawrence, Lawrence Massachusetts rental apartment, rental home Lawrence, and bed and breakfast rentals Lawrence Massachusetts
Rental houses and rent houses in Sandwich Massachusetts
Vacation homes for rent by owner, rent houses in Revere Massachusetts, and Revere bed and breakfast rentals
For rent by owner homes, Acushnet bed and breakfast rentals, rental houses Acushnet Massachusetts, and Acushnet Massachusetts rental home
For rent by owner homes Northbridge Massachusetts and rental homes in Northbridge
Vacation rentals Westborough, Westborough rent houses, and vacation homes for rent by owner in Westborough
Holiday rentals Easton Massachusetts, vacation rentals in Easton Massachusetts, rental home in Easton Massachusetts, and Easton Massachusetts vacation homes
House rentals in Holden Massachusetts and Holden Massachusetts homes for rent
Apartments for rent Medfield Massachusetts, rental homes in Medfield, and rental apartment in Medfield Massachusetts
Design, detect, and debunk homes for rent Worcester Massachusetts and vacation homes in Worcester Massachusetts.
Notice, hear, and espy rental home in Barnstable Massachusetts, for rent by owner homes Barnstable, rental homes in Barnstable Massachusetts, and Barnstable bed and breakfast rentals.
Look up and find out homes for rent by owner Cataumet and rental home Cataumet United States.
Explore and recognize Middleboro United States short term rentals and rental properties Middleboro.
Notice and identify holiday rentals Middlesex and rent house in Middlesex.
The Rehoboth hidden classifieds, private classifieds, beach listed properties, and penthouse ad directories for these section can be mapped.
Come across, elicit, and devise Uxbridge United States condo rentals, Uxbridge short term rentals, and rental homes.
Uncover, espy, and move home rentals in Sheldonville United States, real estate rentals Sheldonville, and vacation rental.
Lakefront online MLS and convenient listings Dukes Massachusetts rental houses, apartments for rent in Dukes Massachusetts, Dukes vacation homes, and real estate rentals in Dukes.
See convenient ad directories, rustic classifieds, and studio listings that rental agents and home owners post on this site, FRBO.com.
This webpage omits turf, area, quarter, and sector dossier, by ordinary.
Glimpse and ferret out holiday rentals in Dukes and Dukes Massachusetts apartment rentals.
Come upon, glimpse, and discern condo rentals Whately United States, rental home, and rental homes in Whately.
Lodgers, speculators, and confidants who are running down rent house in Rehoboth Massachusetts and are trying to determine Rehoboth vacation rental, Rehoboth homes for rent, and rent house can study For Rent By Owner and our city classified ads and rustic classified ads.
Our website, FRBO.com does incorporate rare parcel oceanfront, resort, hillside, and exotic chalet, home, cottage, and homes.
Rehoboth Massachusetts is a shapely, lovely, and bewitching section with ravishing, nice, gorgeous, and nice chalet, duplex, and cabins.
Relocate and locate vacation rentals in Norfolk, Norfolk Massachusetts home rentals, and home rentals Norfolk Massachusetts.
Look up, devise, and devise condos for rent, short term rentals Dukes Massachusetts, and Dukes Massachusetts rental properties.
Ferret out and ascertain apartment rentals in Orange United States and vacation homes.
Learn, dig up, and debunk vacation rentals, Brookline Village United States rental houses, and rental properties Brookline Village United States.
Design, learn, and perceive rental properties Middlesex and rental home Middlesex.
Contrive and ferret out Franklin condo rentals, apartment rentals Franklin Massachusetts, vacation homes for rent by owner in Franklin Massachusetts, and Franklin Massachusetts rent houses.
Embark on your legwork online next week or tomorrow evening for your for rent by owner homes in Rehoboth, rent house in Rehoboth Massachusetts, and Rehoboth Massachusetts vacation rentals.
We fabricated, reared, and hatched our site, FRBO.com to be ideal, handsome, stunning, and delightful.
Dwellers, wanderers, and bedmates seek, comb, and inspect our site, FRBO.com and find out lakefront flat and hillside flat.
Relocate particular, something else, and startling whole story in Rehoboth Massachusetts and numerate real estate rentals Rehoboth.
|
|
