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

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$4,695,000

For Sale - Active
174 Branchville Rd, Ridgefield, CT 06877
6 Beds
9 Baths
7,376 Square Feet
0.00 Acres Lot
Built in 2001
For Sale - Active
Units n/a
Checked: 21 hours ago
Updated: Oct 08, 2025 at 10:08AM

Investment Summary


Monthly Cash Flow
-$21,511
Cap Rate
0.2%
Cash-on-Cash Return
-23.9%
Debt Coverage Ratio
0.03
Internal Rate of Return (5 years)
-19.1%

Property Description


0.00 Acres Lot
Built in 2001
For Sale - Active
Units n/a

Welcome to Stonewall Manor-a spectacular mini-estate on 2.76 level manicured acres just minutes to town. A gated entry and circular drive lead to this custom residence that blends timeless elegance with high-end design. Inside, a 2-story foyer introduces exquisite millwork, coffered ceilings, arched doorways and grand-scale rooms. Formal living and dining rooms flank the entry, while the Bilotta-designed chef's kitchen is sure to impress with professional grade appliances, island, pantry, breakfast area and a circular conservatory opening to the mahogany deck and patio with hot tub. The adjacent family room includes a fireplace and custom cabinetry. An impressive billiard room with English-style bar and wet bar opens to a private patio. The majestic maple library boasts a 16-ft vaulted coved ceiling w/murals. Mudroom w/built-ins and two powder rooms complete the main level. Upstairs, the primary suite offers a sitting room w/fireplace, 2 walk-in closets/dressing rooms and a renovated spa-like bath. Four en-suite bedrooms finish this level. The 3rd flr offers a sky-lit guest suite. Designed for enjoyment, the lower level features a rec room, 1,600-bottle wine room, home theater and gym. For your outdoor entertaining, the resort style pool house expanded in 2019, showcases a spectacular kitchen, seating area w/fireplace & dining area with firewall overlooking the Gunite saltwater pool and spa. Garaging for 6 cars, includes a heated carriage house. A truly exceptional offering.

Build Your Team


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

Avatar
Avatar
Avatar

Agents

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

Find an Agent
Avatar
Avatar
Avatar

Lenders

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

Find a Lender
Avatar
Avatar
Avatar

Property Managers

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

Find a Property Manager
Avatar
Avatar
Avatar

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: Garage
  • Details: Attached
  • Garage Spaces: 6
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 6

Bathroom Information

  • # of Baths (Full): 6
  • # of Baths (Partial): 3
  • # of Baths (Total): 9.0

Interior Features

  • # of Rooms: 18
  • Basement: Yes
  • Basement Description: Full, Finished, Sump Pump, Storage Space
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter
  • Roof Material: Wood
  • Pool: Yes

Land Information

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

Lot Information

  • Parcel ID: RIDGM:F16B:0119
  • Lot Size: 0 sqft

Property Information

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

Tax Information

  • Annual Tax: $64,381

Utilities

  • Water & Sewer: Well
  • Heating: Oil, Zoned
  • Cooling: Central Air, Zoned

Location

  • County: Fairfield

Listing Details


Listed by:
John Pellegrino
William Raveis Real Estate
(203) 322-0200

Source:
SmartMLS
MLS#: 24109582
SmartMLS

Investment Summary


Monthly Cash Flow
-$21,511
Cap Rate
0.2%
Cash-on-Cash Return
-23.9%
Debt Coverage Ratio
0.03
Internal Rate of Return (5 years)
-19.1%

Purchase Details

Find an Agent

Purchase price:
$4,695,000
Amount financed:
-$3,756,000
Down payment:
$939,000
Closing costs:
$140,850
Rehab costs:
$0
Initial cash invested:
$1,079,850
Square feet:
7,376
Cost per square foot:
$637
Monthly rent per square foot:
$1.19

Financing Details

Find a Lender

Loan amount:
$3,756,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$22,218
Property tax:
$5,365
Insurance:
$616
Private mortgage insurance (PMI):
$0
Monthly payment:
$28,199

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$8,800 $105,600
Vacancy loss: (6%)
6% -$528 -$6,336
Operating income:
$8,272 $99,264

Operating Expenses


% Rent Monthly Yearly
Property taxes: (61%)
61%-$5,365-$64,381
Insurance: (7%)
7%-$616-$7,392
Property management: (8%)
8%-$704-$8,448
Repairs & maintenance: (5%)
5%-$440-$5,280
Capital expenditures: (5%)
5%-$440-$5,280
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (86%)
86%-$7,565-$90,781

Cash Flow


Monthly Yearly
Net operating income:
$707 $8,484
Mortgage payments:
-$22,218 -$266,616
Cash flow:
-$21,511 -$258,132