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

$10,890,000

For Sale - Active
495 Hugh Cargill Rd, Concord, MA 01742
6 Beds
9 Baths
10,395 Square Feet
23.51 Acres Lot
Built in 2004
For Sale - Active
Units n/a
Checked: 22 hours ago
Updated: May 29, 2025 at 07:18PM

Investment Summary


Monthly Cash Flow
-$56,264
Cap Rate
0.1%
Cash-on-Cash Return
-27.0%
Debt Coverage Ratio
0.01
Internal Rate of Return (5 years)
-22.0%

Property Description


23.51 Acres Lot
Built in 2004
For Sale - Active
Units n/a

SEE VIDEO VISUALLY DESCRIBING GROUNDS AND HOME DURING THE DAY AND AT NIGHT. Georgian Revival architectural masterpiece is sited on 23.5 acres less than 3 miles from the center of Concord and its many renowned public and private schools. Acres of level manicured gardens feature specimen plantings, lawns, waterfall and a koi pond, granite terraces, and walkways of stone and antique bricks. The sunken European-style garden features a central swimming pool designed to resemble a reflecting pond with fountain. Surrounding these formal gardens are acres of private woodlands with trails for walking, riding, snow shoeing, and cross-country skiing. These estate acres abut hundreds of acres of conservation land and provide tranquility rarely found so close to Boston. Constructed by master craftsmen using only the finest materials, the 10,375sf residence offers 6 bedrooms, fully integrates smart-house technology, and is in new construction condition. Do not approach house as driveway is alarmed.

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, Heated Garage, Driveway
  • Details: Attached, Garage Door Opener, Heated Garage, Garage Faces Side, Oversized, Driveway
  • Garage Spaces: 3
  • Spaces Total: 10

Bedroom Information

  • # of Bedrooms: 6

Bathroom Information

  • # of Baths (Full): 7
  • # of Baths (Partial): 2
  • # of Baths (Total): 9.0

Interior Features

  • # of Rooms: 15
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Full, Partially Finished, Interior Entry, Concrete
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Wood Siding
  • Foundation: Concrete Perimeter
  • Roof Type: Gable
  • Roof Material: Slate, Rubber
  • Pool: Yes

Land Information

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

Lot Information

  • Parcel ID: CONCM:4GB:1513L:1
  • Lot Size: 1023945 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Georgian
  • Year Built: 2004

Tax Information

  • Annual Tax: $74,894

Utilities

  • Water & Sewer: Private
  • Heating: Forced Air, Radiant, Humidity Control, Oil
  • Cooling: Central Air

Location

  • County: Middlesex

Investment Summary


Monthly Cash Flow
-$56,264
Cap Rate
0.1%
Cash-on-Cash Return
-27.0%
Debt Coverage Ratio
0.01
Internal Rate of Return (5 years)
-22.0%

Purchase Details

Find an Agent

Purchase price:
$10,890,000
Amount financed:
-$8,712,000
Down payment:
$2,178,000
Closing costs:
$326,700
Rehab costs:
$0
Initial cash invested:
$2,504,700
Square feet:
10,395
Cost per square foot:
$1,048
Monthly rent per square foot:
$0.95

Financing Details

Find a Lender

Loan amount:
$8,712,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$56,854
Property tax:
$6,241
Insurance:
$693
Private mortgage insurance (PMI):
$0
Monthly payment:
$63,788

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$9,900 $118,800
Vacancy loss: (6%)
6% -$594 -$7,128
Operating income:
$9,306 $111,672

Operating Expenses


% Rent Monthly Yearly
Property taxes: (63%)
63%-$6,241-$74,894
Insurance: (7%)
7%-$693-$8,316
Property management: (8%)
8%-$792-$9,504
Repairs & maintenance: (5%)
5%-$495-$5,940
Capital expenditures: (5%)
5%-$495-$5,940
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (88%)
88%-$8,716-$104,594

Cash Flow


Monthly Yearly
Net operating income:
$590 $7,080
Mortgage payments:
-$56,854 -$682,248
Cash flow:
$56,264 $675,168