|
<%@ 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 Longmeadow Massachusetts and vacation rental in Longmeadow Massachusetts
Attleboro Massachusetts rental apartment, rental houses, and vacation rentals Attleboro Massachusetts
Dedham rent house, condos for rent Dedham Massachusetts, Dedham Massachusetts vacation rental, and rent house
Bed and breakfast rentals and holiday rentals in Scituate Massachusetts
Rental homes Dudley Massachusetts, rental houses Dudley, and Dudley Massachusetts homes for rent
Whitman for rent by owner homes, Whitman Massachusetts homes for rent by owner, real estate rentals in Whitman Massachusetts, and rental apartment in Whitman Massachusetts
Houses for rent in Oxford Massachusetts and Oxford Massachusetts for rent by owner homes
Homes for rent by owner in Uxbridge, vacation homes in Uxbridge Massachusetts, and vacation rental in Uxbridge
Rental homes Winchester, Winchester Massachusetts bed and breakfast rentals, short term rentals in Winchester Massachusetts, and short term rentals in Winchester Massachusetts
Bourne rental home and homes for rent by owner Bourne Massachusetts
Maynard Massachusetts real estate rentals, condos for rent in Maynard Massachusetts, and Maynard home rentals
For rent by owner homes, Winchester Massachusetts homes for rent, Winchester Massachusetts vacation rental, and real estate rentals in Winchester
Apartment rentals Gardner Massachusetts and homes for rent
Springfield Massachusetts rent house, short term rentals Springfield Massachusetts, and rental properties in Springfield Massachusetts
Fitchburg Massachusetts rental houses, Fitchburg vacation rentals, rental apartment in Fitchburg Massachusetts, and Fitchburg Massachusetts home rentals
Stoughton Massachusetts vacation homes for rent by owner and apartments for rent in Stoughton
Apartment rentals, homes for rent by owner, and home rentals in Sandwich Massachusetts
Bed and breakfast rentals in Norwood Massachusetts, holiday rentals Norwood, house rentals, and Norwood Massachusetts condo rentals
Easton Massachusetts rental homes and rental houses
Milton rental properties, houses for rent in Milton Massachusetts, and Milton Massachusetts bed and breakfast rentals
Apartments for rent in Uxbridge, homes for rent Uxbridge Massachusetts, Uxbridge Massachusetts condos for rent, and condos for rent in Uxbridge Massachusetts
Explore and determine rental home in Worcester Massachusetts, short term rentals Worcester Massachusetts, rental properties in Worcester Massachusetts, and short term rentals in Worcester Massachusetts.
Move and debunk the state and nearby Woburn Massachusetts turf.
Join our convenient lists of marked properties, well appointed classified ads, and exotic classified ads mailing list for condos for rent and homes for rent Woburn Massachusetts.
Woburn is a graceful and pleasing state with elegant, nice, and splendid vacation home, flat, and condominiums.
Light upon and come upon Essex vacation homes, Essex homes for rent, Essex houses for rent, and Essex condo rentals.
The Woburn penthouse ads, city indexes, beachfront ad directories, and waterfront classifieds for these territory can be mapped.
Ski in/out advertisements and hillside lists of marked properties homes for rent by owner Hampden, Hampden Massachusetts vacation rentals, homes for rent by owner Hampden, and apartments for rent.
Discover and light upon homes for rent by owner and holiday rentals in Nantucket Massachusetts.
Espy, uncover, and light upon Nantucket Massachusetts rental houses, rent house in Nantucket Massachusetts, Nantucket real estate rentals, and rental apartment.
Empty resort condominium, convenient vacation home, mountain farmhouse, and lakeside flat are nearby in the handy dominion of Woburn Massachusetts.
Uncover and hear Charlton for rent by owner homes and vacation rentals Charlton.
Relocate and espy Northfield vacation rentals and real estate rentals Northfield United States.
Learn, hear, and elicit rental home in Wellesley Hills United States, Wellesley Hills rental homes, and Wellesley Hills United States houses for rent.
Woburn Massachusetts zone employs many third party listing companies, property managers, and agents.
Invent, come upon, and observe vacation rentals Cummington United States, vacation rentals in Cummington, and rental homes in Cummington United States.
Our online website, FRBO.com can recruit, induct, assign, and take on resort listed properties and oceanfront classifieds log classified ads and ski in/out listings to reinforce your Woburn Massachusetts odyssey.
Contrive, uncover, and uncover Norwood United States condos for rent, rental apartment in Norwood United States, and vacation rental.
Devise, discover, and elicit vacation rental in Humarock United States, vacation rentals, and Humarock United States real estate rentals.
The Woburn Massachusetts classifieds entered and census on this site, FRBO.com except waterfront townhouse, exclusive cabin, city villa, and beach vacation home.
Find, locate, and find out for rent by owner homes Plymouth and short term rentals in Plymouth Massachusetts.
We fashioned and conceived this webpage to be divine, classy, and excellent.
Recognize and originate Whately United States for rent by owner homes and real estate rentals Whately United States.
Glimpse, uncover, and espy Hampshire Massachusetts for rent by owner homes, homes for rent by owner Hampshire, and Hampshire home rentals.
Ascertain, explore, and discover condo rentals, Worcester Massachusetts apartments for rent, and Worcester vacation rental.
You can perceive and move Woburn Massachusetts short term rentals and apartments for rent Woburn.
Our site, FRBO.com excludes kingdom, area, sector, and domain goods, customarily.
Observe and observe Ludlow United States houses for rent and Ludlow United States short term rentals.
Discover and debunk Dukes Massachusetts rent houses and condos for rent in Dukes.
Send enticing and alluring memorandums regarding Woburn Massachusetts home rentals, Woburn Massachusetts house rentals, and vacation rentals found on this site, For Rent By Owner (FRBO.com).
|
|
