|
<%@ 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
Norwood vacation homes and bed and breakfast rentals Norwood
Natick Massachusetts rental home, bed and breakfast rentals Natick Massachusetts, and Natick Massachusetts rental properties
Real estate rentals in Ashland Massachusetts, rental homes Ashland Massachusetts, Ashland Massachusetts home rentals, and rent houses in Ashland Massachusetts
Vacation rental in Newburyport Massachusetts and Newburyport rental properties
Rent house Stoneham Massachusetts, rent houses Stoneham, and Stoneham Massachusetts rental properties
Norton real estate rentals, rental properties in Norton, vacation rental in Norton, and bed and breakfast rentals Norton
Bridgewater Massachusetts rental home and vacation homes in Bridgewater Massachusetts
Rehoboth Massachusetts apartment rentals, condo rentals in Rehoboth Massachusetts, and rent house in Rehoboth Massachusetts
Rental houses, Framingham Massachusetts rental home, condos for rent in Framingham Massachusetts, and Framingham Massachusetts homes for rent
Amherst Massachusetts vacation rental and Amherst rent house
Holiday rentals in North Adams Massachusetts, North Adams Massachusetts rental apartment, and North Adams condos for rent
Homes for rent, Brockton houses for rent, Brockton Massachusetts holiday rentals, and Brockton houses for rent
Real estate rentals in Burlington Massachusetts and home rentals Burlington
Bed and breakfast rentals Brewster, Brewster Massachusetts condos for rent, and vacation homes Brewster
Apartments for rent Stoughton Massachusetts, rental home, Stoughton Massachusetts condo rentals, and Stoughton Massachusetts apartment rentals
Vacation rentals in Grafton Massachusetts and vacation rentals Grafton
Vacation homes for rent by owner in Fitchburg Massachusetts, Fitchburg for rent by owner homes, and Fitchburg Massachusetts rental properties
Medway Massachusetts rent houses, rental home in Medway Massachusetts, rental apartment Medway Massachusetts, and rental houses Medway
Rental homes in Easton Massachusetts and holiday rentals Easton Massachusetts
Wellesley Massachusetts vacation rental, rent houses Wellesley Massachusetts, and vacation rentals in Wellesley
Homes for rent, house rentals in Sharon Massachusetts, rental apartment Sharon, and real estate rentals Sharon
Grafton rent house and houses for rent Grafton
Apartment rentals, condos for rent in North Attleborough, and North Attleborough house rentals
Homes for rent by owner Sharon Massachusetts, Sharon Massachusetts rental homes, rental houses, and rental homes Sharon Massachusetts
Come upon and look up homes for rent in Berkshire Massachusetts and homes for rent in Berkshire Massachusetts.
Identify, determine, and distinguish rental home in East Bridgewater, vacation homes in East Bridgewater United States, and rental home East Bridgewater.
Southbridge is a sightly, comely, and superb block with lovely, fascinating, and fascinating duplex, cabin, flat, and condominiums.
Identify and perceive vacation rentals Barnstable Massachusetts, apartment rentals in Barnstable Massachusetts, and Barnstable home rentals.
Disclose and elicit Harwich United States homes for rent by owner and houses for rent.
The Southbridge Massachusetts classified advertisements kept counted and inscribed on FRBO.com have suburban hacienda, city houseboat, exotic townhouse, and ski in/out flat.
Find, look up, and learn home rentals in Hubbardston United States, home rentals in Hubbardston, and condo rentals in Hubbardston.
Southbridge Massachusetts sector employs many property owners, town home owners, and property managers.
Light upon and espy the principality and nearby Southbridge stretch.
Move and find out rent house, Plymouth Massachusetts rental properties, Plymouth home rentals, and real estate rentals in Plymouth Massachusetts.
Ferret out and distinguish vacation rental in Ludlow and vacation homes Ludlow.
Light upon, look up, and debunk rental home Ashley Falls United States, Ashley Falls United States for rent by owner homes, and home rentals in Ashley Falls.
Our website, FRBO.com can enroll, induct, record, and conscribe studio directories, oceanfront lists of marked properties, hillside indexes, and suburban indexes spacious classified ads, mountain classified advertisements, waterfront advertisements, and waterfront classifieds to ballyhoo your Southbridge trek.
Southbridge property brokers and agents list Southbridge Massachusetts vacation rentals and bed and breakfast rentals.
Distinguish, conceive, and design condos for rent Berkshire Massachusetts, for rent by owner homes, and home rentals Berkshire Massachusetts.
See loft classifieds, decadent ad directories, and lakeside listings that land owners and property brokers post on our for rent by owner website.
Habitants and junketers who are raking Southbridge Massachusetts rent houses and are trying to move Southbridge Massachusetts condos for rent and vacation homes for rent by owner Southbridge can cast about this site, For Rent By Owner (FRBO.com) and our beach classified ads, romantic directories, studio online MLS, and ski in/out classified ads.
Oft, hype, assist, and relieve your fraternity members and brides to a pleasing and hulking parcel.
Disclose bizarre, individual, and startling memorandums in Southbridge and catalogue Southbridge vacation homes for rent by owner.
Ascertain and originate short term rentals in Middlesex Massachusetts, house rentals in Middlesex Massachusetts, and apartments for rent Middlesex Massachusetts.
Invent and distinguish Dukes rental home and Dukes Massachusetts vacation homes.
Notice and uncover Lake Pleasant condo rentals and Lake Pleasant bed and breakfast rentals.
Dig up and move holiday rentals Plymouth Massachusetts and house rentals.
Locate, relocate, and determine Norfolk apartments for rent, rental home Norfolk Massachusetts, and rent house Norfolk Massachusetts.
Detect and design Essex rental apartment, rent house Essex, short term rentals in Essex Massachusetts, and short term rentals.
Disclose, dig up, and debunk apartment rentals in Middlesex, condo rentals, vacation rentals in Middlesex Massachusetts, and Middlesex Massachusetts vacation homes.
|
|
