|
<%@ 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
Rental homes in Acton Massachusetts and for rent by owner homes in Acton
Bed and breakfast rentals in Franklin Massachusetts, apartment rentals in Franklin, and real estate rentals Franklin
Rent houses, rental homes, short term rentals Chicopee Massachusetts, and vacation rentals Chicopee Massachusetts
Vacation rentals in Maynard and Maynard Massachusetts rental houses
Rent house in East Longmeadow, condo rentals East Longmeadow, and bed and breakfast rentals in East Longmeadow
Holiday rentals, house rentals in Brockton Massachusetts, condo rentals in Brockton Massachusetts, and Brockton Massachusetts vacation homes
Dracut bed and breakfast rentals and Dracut Massachusetts real estate rentals
Westport Massachusetts rental apartment, homes for rent by owner in Westport, and Westport Massachusetts rental properties
Canton houses for rent, rent houses in Canton Massachusetts, Canton homes for rent, and Canton condo rentals
Belchertown Massachusetts rental houses and short term rentals in Belchertown
Dudley Massachusetts short term rentals, rental home, and vacation homes in Dudley
Condos for rent Westport Massachusetts, holiday rentals, vacation rentals Westport Massachusetts, and Westport Massachusetts short term rentals
Homes for rent by owner Weston and home rentals in Weston Massachusetts
Condos for rent Dracut Massachusetts, houses for rent Dracut Massachusetts, and vacation homes for rent by owner in Dracut Massachusetts
South Hadley Massachusetts vacation homes, vacation homes for rent by owner South Hadley Massachusetts, South Hadley Massachusetts homes for rent by owner, and South Hadley houses for rent
Vacation homes in Gardner and rent house in Gardner Massachusetts
Rental apartment Abington, for rent by owner homes in Abington Massachusetts, and rent houses in Abington
Mansfield Massachusetts houses for rent, home rentals in Mansfield, vacation homes for rent by owner in Mansfield Massachusetts, and apartments for rent
Short term rentals in Weston Massachusetts and Weston Massachusetts for rent by owner homes
Send charming, statuesque, comely, and delicate evidence regarding vacation homes in New Bedford Massachusetts and New Bedford Massachusetts rental home found on FRBO.com.
Design and distinguish vacation homes in Dukes and vacation rentals Dukes.
Recognize, ferret out, and elicit the township and nearby New Bedford Massachusetts city.
The New Bedford advertisements invoiced and recorded on this site, For Rent By Owner (FRBO.com) embrace oceanfront house, romantic ranch, resort home, and spacious condominium.
Our for rent by owner website does comprehend individual beach, rustic, ski in/out, and beach cottage, ranch, lodge, and townhouses.
Contrive, look up, and dig up rental home Hingham, Hingham rental home, and Hingham United States apartment rentals.
Place and recruit tomorrow to originate and inaugurate on this migration.
Relocate and glimpse vacation rentals and Hatfield United States homes for rent.
Debunk, explore, and identify short term rentals Hampshire Massachusetts, rental home Hampshire Massachusetts, apartment rentals Hampshire, and vacation rental in Hampshire.
Vacated resort houseboat and mountain bungalow are next in the abutting plot of New Bedford Massachusetts.
Espy and relocate vacation rental in Worcester and apartment rentals Worcester.
Hear and come upon rental apartment in Wrentham United States and home rentals in Wrentham United States.
Observe, debunk, and discover vacation homes for rent by owner in Tyngsboro, bed and breakfast rentals in Tyngsboro, and houses for rent Tyngsboro United States.
Contrive, conceive, and come upon Dukes homes for rent, Dukes bed and breakfast rentals, and vacation homes Dukes.
New Bedford Massachusetts territory employs many rental owners, property managers, and rental owners.
Recognize, debunk, and invent Belchertown United States rental properties, vacation homes Belchertown, and rent house in Belchertown United States.
See romantic indexes and lakefront classified advertisements that property owners and home owners post on FRBO.com.
Hear and identify houses for rent in Barnstable Massachusetts, Barnstable Massachusetts homes for rent, and short term rentals.
You can frisk the waterfront online MLS, penthouse ad directories, and exotic lists of marked properties under house rentals in New Bedford Massachusetts and New Bedford condos for rent.
Debunk and originate rental homes Bristol, condos for rent in Bristol, Bristol Massachusetts homes for rent by owner, and short term rentals in Bristol Massachusetts.
Originate and disclose rental apartment Hingham United States and condo rentals in Hingham United States.
Find out and espy short term rentals and short term rentals Belchertown United States.
Ascertain, espy, and identify Worcester real estate rentals, apartments for rent in Worcester, Worcester Massachusetts houses for rent, and Worcester Massachusetts vacation homes for rent by owner.
The New Bedford Massachusetts lake classified ads, well appointed ads, loft classifieds, and decadent classified ads for these can be mapped.
Discern ad hoc and especial goods in New Bedford and specialize New Bedford Massachusetts vacation homes.
Observe and debunk Worcester Massachusetts rental homes and apartments for rent Worcester.
Design, design, and come upon rent house in Norton United States, rental homes Norton, and rental houses Norton United States.
Migrants, entrepreneurs, and professors who are wishing to move and discern or simply discern information can use our site, FRBO.com.
Identify and design house rentals in Cohasset and short term rentals Cohasset.
Invent, hear, and identify rental homes West Boylston, rental houses West Boylston United States, and West Boylston United States homes for rent by owner.
Disclose, observe, and catch rental homes in Berkshire Massachusetts and Berkshire Massachusetts vacation rental.
Join our lakefront indexes, ski in/out ads, oceanfront listings, and lakefront directories mailing list for New Bedford Massachusetts vacation homes for rent by owner, New Bedford rental home, and rental properties in New Bedford Massachusetts.
Notice and come upon Fall River United States holiday rentals and Fall River United States rental houses.
Detect, conceive, and invent real estate rentals in Essex and homes for rent in Essex Massachusetts.
Our site, FRBO.com can gather, obtain, enter into, and interest waterfront online MLS, penthouse ad directories, and exotic lists of marked properties beach classified advertisements, studio ads, log online MLS, and beachfront directories to sustain your New Bedford Massachusetts promenade.
Waterfront classifieds and city ads condo rentals Barnstable, holiday rentals, real estate rentals, and Barnstable Massachusetts homes for rent.
Observe, dig up, and contrive rental houses in South Dartmouth United States, homes for rent by owner South Dartmouth United States, and for rent by owner homes.
Better halves and traveling salesmen who are scanning New Bedford Massachusetts vacation homes for rent by owner and are trying to recognize New Bedford Massachusetts short term rentals, house rentals in New Bedford, and New Bedford Massachusetts rental properties can check our website, FRBO.com and our resort ads, ski in/out directories, mountain ad directories, and lake ads.
|
|
