Situated on 80± acres, Aquila Farm, is one of the few fully operational equestrian estates on the N. Shore. The property includes a 5-bed house, a farm office, barns with 19 stalls, outdoor riding arena & fenced paddocks and pastures. A pool, tennis court, gardens, & ponds complete this offering. The property has direct access to the ECTA. Subdivision potential up to 5 lots. Income from current boarding/stable operation currently offsets annual real estate taxes (rates and vacancy dependent).
Interior Features: Study, Sitting Room, Sun Room, Wine Cellar, Bathroom, Wet Bar
Exterior
Building Information
Building Area (Total): 8,140
Foundation Area: 99,999
Foundation Details: Concrete Perimeter
Construction Materials: Frame
Year Built Source: Public Records
Year Built Details: Actual
Exterior Features
Fencing: Fenced/Enclosed, Fenced
Roof: Shingle
Patio And Porch Features: Patio
Exterior Features: Patio, Pool - Inground, Tennis Court(s), Hot Tub/Spa, Storage, Barn/Stable, Paddock, Greenhouse, Professional Landscaping, Sprinkler System, Decorative Lighting, Fenced Yard
Pool Information
Has Private Pool
Has Spa
Pool Features: In Ground
Spa Features: Private
Property Information
PropertySubType: Single Family Residence
Security Features: Security System
Other Structures: Barn/Stable, Greenhouse
Lot Information
Lot Size (Acres): 80
Lot Features: Wooded, Cleared, Farm, Gentle Sloping
ViewYN: Has View
View: Scenic View(s)
Financial
Tax Information
Tax Annual Amount: $61,284
Tax Year: 2011
Utilities
Utility Information
Sewer: Private Sewer
Water Source: Public, Private
Electric: Other (See Remarks)
Heating & Cooling
Has Heating
Has Cooling
Heating: Baseboard, Radiant, Natural Gas
Cooling: Central Air
Location
Location Information
Directions: Off Route 1A on the right; driveway after 639 Bay Road
UnparsedAddress: 641 Bay Road, Hamilton MA 01982
Community Information
Senior CommunityYN: No
Community Features: Pool, Tennis Court(s), Park, Walk/Jog Trails, Stable(s), Golf, Bike Path, Conservation Area, Highway Access, Private School, T-Station
Horse Amenities: Paddocks
Public facts
Beds: 5
Baths: 3.5
Sq. Ft.: 6,687
Stories: 3.0
Lot Size: 32.54 acres
Style: Other
Year Built: 2002
Year Renovated: —
County: Essex County
APN: 1918455
Home facts updated by county records on Jul 30, 2025
Other
Listing Information
Exclusions: See Listing Broker; Eagles On Gate Entry
StandardStatus: Closed
Around this home
Schools
Winthrop School
Public PreK-5 • Assigned • 1.1mi
9/10
Miles River Middle School
Public 6-8 • Assigned • 0.5mi
8/10
Hamilton-Wenham Regional High School
Public 9-12 • Assigned • 0.5mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Historical weather
South Hamilton, MA • 01982
Average low and high temperatures (°F)
33
20
35
22
48
31
56
39
66
49
78
59
81
65
77
59
72
55
63
45
52
37
39
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.
Provided by Shadowmap
Estimated sale price
$5.16M – $6.24M
Reach more buyers when you sell with Redfin. Save up to $54,288 in fees.3 minutes to get started.