Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$12,500,000

For Sale - Active
3 Idlewile Ln, Weston, MA 02493
6 Beds
11 Baths
14,620 Square Feet
8.27 Acres Lot
Built in 2010
For Sale - Active
Units n/a
Checked: 12 hours ago
Updated: Jun 17, 2025 at 03:17AM

Investment Summary


Monthly Cash Flow
-$64,083
Cap Rate
-0.5%
Cash-on-Cash Return
-26.7%
Debt Coverage Ratio
-0.08
Internal Rate of Return (5 years)
-21.8%

Property Description


8.27 Acres Lot
Built in 2010
For Sale - Active
Units n/a

Exceptional gated estate privately sited on 8+acres abutting conservation in one of Weston's most exclusive south side neighborhoods. There is 14,000 +sq. ft. of living space featuring uncompromising design in custom mill & stonework with fabulous amenities for entertaining on a grand scale & the ultimate facilities for sports & leisure. Formal living room with arched doors lead to an expansive formal dining room, Chef’s dream kitchen, comfortable family room with domed ceiling. Private, paneled office & den. Serene primary suite with sitting room, 2 dressing rooms, 5 add'l bedrooms with en suite baths. Stunning 3-story foyer, venetian plaster walls, arched doorways, coffered ceilings, elevator, whole house generator. Fantastic entertainment level features game room with theater, indoor lap pool, indoor basketball court, gym & spa, as well as a bunk bed room. 7 car heated garage with 4 EV chargers. Expansive lawn & specimen plantings. A true gem.

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Description: Attached, Garage Door Opener, Heated Garage, Oversized, Paved Drive, Off Street, Paved
  • Details: Paved, Attached, Garage Door Opener, Heated Garage, Oversized, Off Street
  • Garage Spaces: 7
  • Spaces Total: 8

Bedroom Information

  • # of Bedrooms: 6

Bathroom Information

  • # of Baths (Full): 8
  • # of Baths (Partial): 3
  • # of Baths (Total): 11.0

Interior Features

  • # of Rooms: 19
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Full, Partially Finished
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Stucco
  • Foundation: Concrete Perimeter
  • Roof Type: Gable
  • Roof Material: Slate
  • Pool: Yes

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: WESTM:044.0L:0049S:030.0
  • Lot Size: 360241 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Colonial
  • Year Built: 2010

Tax Information

  • Annual Tax: $142,776

Utilities

  • Water & Sewer: Public
  • Heating: Natural Gas, Geothermal, Forced Air, Fireplace(s)
  • Cooling: Central Air, Geothermal

Location

  • County: Middlesex

Investment Summary


Monthly Cash Flow
-$64,083
Cap Rate
-0.5%
Cash-on-Cash Return
-26.7%
Debt Coverage Ratio
-0.08
Internal Rate of Return (5 years)
-21.8%

Purchase Details

Find an Agent

Purchase price:
$12,500,000
Amount financed:
-$10,000,000
Down payment:
$2,500,000
Closing costs:
$375,000
Rehab costs:
$0
Initial cash invested:
$2,875,000
Square feet:
14,620
Cost per square foot:
$855
Monthly rent per square foot:
$0.69

Financing Details

Find a Lender

Loan amount:
$10,000,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$59,154
Property tax:
$11,898
Insurance:
$707
Private mortgage insurance (PMI):
$0
Monthly payment:
$71,759

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$10,100 $121,200
Vacancy loss: (6%)
6% -$606 -$7,272
Operating income:
$9,494 $113,928

Operating Expenses


% Rent Monthly Yearly
Property taxes: (118%)
118%-$11,898-$142,776
Insurance: (7%)
7%-$707-$8,484
Property management: (8%)
8%-$808-$9,696
Repairs & maintenance: (5%)
5%-$505-$6,060
Capital expenditures: (5%)
5%-$505-$6,060
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (143%)
143%-$14,423-$173,076

Cash Flow


Monthly Yearly
Net operating income:
-$4,929 -$59,148
Mortgage payments:
-$59,154 -$709,848
Cash flow:
$64,083 $768,996