About 25 Fairview Ave
This waterfront retreat is located directly on 82-acre Locustville Pond and is an entertainer's or sport enthusiast paradise! The property consists of a 6155 SF, 3/4 bedroom home, all rooms are individually insulated, 4-1/2 bath, 2 full kitchens, one upstairs and one downstairs, a large owner's suite with two large closets, 2 laundry areas, a full body gym, a climate controlled safe room - which would make a great wine cellar, a generator, large decks and patios, a 2 car and 4 car heated garage and a separate 3-bay commercial garage with electricity located at the far end of the property, a built-in pool and two docks; one has a boat lift and a storage shed, an additional barn/shed, an electric pet fence, security system - all on 3.07 private, beautifully landscaped and hard-scaped secluded acres! Horses/farm permitted, multi generational living, vacation retreat, car collectors, home occupation. Located minutes from "The Preserve" sporting center, easy access from major highways.
Pricing and availability subject to change.
Features of 25 Fairview Ave
| MLS® # | 1356477 |
|---|---|
| Price | $1,600,000 |
| Bedrooms | 3 |
| Bathrooms | 5 |
| Full Baths | 4 |
| Half Baths | 1 |
| Square Footage | 6,155 |
| Square Footage | 133729 |
| Acres | 3.07 |
| Year Built | 2001 |
| Type | Residential |
| Sub-Type | Single Family Residence |
| Style | Contemporary |
| Status | Active |
Community Information
| Address | 25 Fairview Ave |
|---|---|
| Subdivision | Locustville Pond/Hope Valley |
| City | Hopkinton |
| County | Washington |
| State | RI |
| Zip Code | 02832 |
Amenities
| Features | Multiple lots, Wooded, Private, Secluded, Waterfront |
|---|---|
| Parking Spaces | 19 |
| Parking | Detached, Garage, Garage Door Opener, Built In |
| # of Garages | 9 |
| Garages | Detached, Garage, Garage Door Opener, Built In |
| View | Water |
| Is Waterfront | Yes |
| Has Pool | Yes |
| Pool | In Ground |
Interior
| Interior | Ceramic Tile, Hardwood |
|---|---|
| Interior Features | Bathtub, Skylights, Tub Shower, Cable TV, Central Vacuum |
| Appliances | Dryer, Dishwasher, Electric Water Heater, Microwave, Oven, Range, Refrigerator, Washer |
| Heating | Baseboard, Hot Water, Oil, Hydro Air |
| Cooling | Central Air |
| Fireplace | Yes |
| # of Fireplaces | 1 |
| Fireplaces | Stone |
| # of Stories | 2 |
| Stories | 2 |
| Has Basement | Yes |
| Basement | Full, Finished, Walk-Out Access |
Exterior
| Exterior | Drywall, Plaster, Vinyl Siding |
|---|---|
| Exterior Features | Deck, Porch, Patio, Paved Driveway |
| Lot Description | Multiple lots, Wooded, Private, Secluded, Waterfront |
| Windows | Skylight(s), Thermal Windows |
| Construction | Drywall, Plaster, Vinyl Siding |
| Foundation | Concrete Perimeter |
Additional Information
| Date Listed | April 11th, 2024 |
|---|---|
| Days on Market | 10 |
| Zoning | RFR-8 |
| Short Sale | No |
| RE / Bank Owned | No |
Listing Details
| Office | RE/MAX FLAGSHIP, INC. |
|---|