$4,500,000
$1M PRICE DROP

Estimated payment $26,956/month

Total Views 32,486
10 Beds
10 Baths
6,526 Sq Ft
$690 Price per Sq Ft

Highlights

  • Guest House
  • Sub-Zero Refrigerator
  • 24.75 Acre Lot
  • Pool House
  • Waterfront
  • Open Floorplan

About This Home

Enter a world of opulent privacy on nearly twenty-five acres of pristine countryside, boasting five acres of serene lakes, elegant stone bridge, and expansive manicured lawns that cradle an entire valley just 45 miles from NYC! Discover a lavish retreat comprising of four distinct residences: a magnificent five-bedroom, four-bathroom main estate, a charming two-bedroom, two-bathroom guest cottage, a sophisticated two-bedroom, one-bathroom carriage house complete with a heated three-car garage, and a stylish one-bedroom, one-bathroom log cabin pool house overlooking a 20x50 heated saltwater pool. Additionally, luxuriate in a cozy "writers cabin," with a majestic fireplace. The compound also has a versatile storage barn with separate private driveway access, and a dog kennel. The property is artfully situated amidst majestic oak trees and vibrant flowering shrubs, adorned with professionally landscaped stone terraces, walls, and scenic viewpoints, featuring multiple rose and mixed flower gardens, an organic vegetable garden, and a host of other exquisite amenities. Stroll through this picturesque sanctuary of unmatched serenity - a truly enchanting haven of natural beauty and modern comforts.

Listing Agent

Dannel Malloy

NestSeekers International License #RES.0799799 Listed on: 06/21/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,522

Year Built

  • Built in 1939

Lot Details

  • 24.75 Acre Lot
  • Waterfront
  • Kennel
  • Fruit Trees
  • Garden
  • Property is zoned RA2

Home Design

  • Colonial Architecture
  • Contemporary Architecture
  • Stone Foundation
  • Slab Foundation
  • Stone Frame
  • Frame Construction
  • Ridge Vents on the Roof
  • Clap Board Siding
  • Stone Siding
  • Log Siding
  • Stone

Interior Spaces

  • 6,526 Sq Ft Home
  • Open Floorplan
  • Entertainment System
  • Built In Speakers
  • Sound System
  • 6 Fireplaces
  • Thermal Windows
  • Mud Room
  • Entrance Foyer
  • Concrete Flooring

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Sub-Zero Refrigerator
  • Ice Maker
  • Dishwasher
  • Wine Cooler

Bedrooms and Bathrooms

  • 10 Bedrooms

Laundry

  • Laundry Room
  • Laundry on lower level
  • Dryer
  • Washer

Attic

  • Storage In Attic
  • Attic or Crawl Hatchway Insulated

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Partial Basement
  • Interior Basement Entry
  • Basement Hatchway
  • Crawl Space
  • Basement Storage

Home Security

  • Smart Lights or Controls
  • Smart Thermostat

Parking

  • 5 Car Garage
  • Automatic Garage Door Opener

Eco-Friendly Details

  • Energy-Efficient Lighting
  • Pre-Wired For Photovoltaic Solar

Pool

  • Pool House
  • Heated In Ground Pool
  • Gunite Pool
  • Saltwater Pool
  • Pool has a Solar Cover

Outdoor Features

  • Patio
  • Gazebo
  • Shed
  • Rain Gutters

Additional Homes

  • Guest House

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Radiator
  • Heating System Uses Oil
  • Heating System Uses Oil Above Ground
  • Heating System Uses Propane
  • Programmable Thermostat
  • Power Generator
  • 60 Gallon+ Oil Water Heater
  • Private Water Source
  • Private Company Owned Well
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 327704

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,522

Year Built

Built in 1939

Lot Details

0

Listing Details

  • Neighborhood: North Stamford
  • Property Type: Single Family For Sale
  • Style: Colonial, Contemporary
  • Sq Ft Est Heated Above Grade: 6526
  • Total Sq Ft: 6526
  • Year Built: 1939
  • New Construction: No/Resale
  • Direct Waterfront: Yes
  • Encumbrances Restrictions: Inland-Wetland Restrictions
  • Home Warranty Offered: No
  • Directions: Long Ridge Road, Right Turn onto Old Long Ridge Road, Immediate Left Turn onto Rock Rimmon Road
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 10
  • Total Bathrooms: 10
  • Full Bathrooms: 8
  • Half Bathrooms: 2
  • Fireplaces: 6
  • Attic Description: Storage Space, Access Via Hatch
  • Basement Description: Crawl Space, Partial, Full, Storage, Hatchway Access, Interior Access, Concrete Floor, Partial With Walk-Out
  • Interior Amenities: Audio System, Auto Garage Door Opener, Cable - Pre-wired, Open Floor Plan
  • Appliances: Electric Cooktop, Gas Cooktop, Oven/Range, Wall Oven, Microwave, Range Hood, Subzero, Icemaker, Dishwasher, Washer, Dryer, Wine Chiller
  • Additional Rooms: Foyer, Laundry Room, Mud Room
  • Laundry Room Location: Each of the 4 dwellings has full laundry
  • Laundry Room Info: Lower Level, Main Level, Upper Level
  • Attic: Yes
  • Home Automation: Built In Audio, Entertainment System, Lighting, Thermostat(s), Wired For Audio
  • Street Number Modifier: 1021

Exterior Features

  • Exterior Features: Shed, Fruit Trees, Gazebo, Gutters, Garden Area, Guest House, Kennel, Patio
  • Exterior Siding: Clapboard, Logs, Stone
  • Foundation Type: Slab, Stone
  • Roof Information: Wood Shingle Slate
  • Waterfront Description: Pond River Walk to Water View Access
  • Swimming Pool: Yes
  • Pool: Gunite, Heated, Pool House, Salt Water, Solar Cover, In Ground Pool
  • Construction Description: Frame, Stone, Log

Garage/Parking

  • Garages Number: 5
  • Garage And Parking: Attached Garage, Detached Garage

Utilities

  • Cooling System: Central Air, Zoned
  • Heat Type: Hot Air, Radiator, Zoned
  • Heat Fuel Type: Oil, Propane
  • Fuel Tank Location: Above Ground
  • Hot Water Description: Oil, Electric, 65 Gallon Tank
  • Water Source: Private Water System, Private Well
  • Sewer: Septic

Schools

  • Elementary School: Per Board of Ed
  • High School: Per Board of Ed

Green Features

  • Energy Features: Generator, Programmable Thermostat, Ridge Vents, Thermopane Windows

Lot Info

  • Acres: 24.75
  • Lot Description: Secluded Treed Level Lot Professionally Landscaped Rolling Water View
  • Flood Zone: No
  • Zoning: RA2
  • Parcel #: 327704

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 31522
  • Total Assessed Value: 1349400
  • Mil Rate Total: 24.64

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Per Board of Ed

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $10,363 $445,340 $445,340 $0
2024 $10,136 $445,340 $445,340 $0
2023 $10,893 $445,340 $445,340 $0
2022 $8,883 $337,380 $337,380 $0
2021 $8,762 $337,380 $337,380 $0
2020 $8,546 $337,380 $337,380 $0
2019 $8,546 $337,380 $337,380 $0
2018 $8,249 $337,380 $337,380 $0
2017 $9,467 $352,060 $352,060 $0
2016 $8,738 $352,060 $352,060 $0
2015 $8,499 $352,060 $352,060 $0
2014 $8,207 $352,060 $352,060 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/30/2025 07/30/25 For Sale $4,500,000 0.0% $690 / Sq Ft
07/30/2025 07/30/25 Off Market $4,500,000 -- --
07/23/2025 07/23/25 For Sale $4,500,000 0.0% $690 / Sq Ft
07/23/2025 07/23/25 Off Market $4,500,000 -- --
07/03/2025 07/03/25 For Sale $4,500,000 0.0% $690 / Sq Ft
07/03/2025 07/03/25 Off Market $4,500,000 -- --
06/19/2025 06/19/25 For Sale $4,500,000 0.0% $690 / Sq Ft
06/19/2025 06/19/25 Off Market $4,500,000 -- --
06/09/2025 06/09/25 For Sale $4,500,000 0.0% $690 / Sq Ft
06/08/2025 06/08/25 Off Market $4,500,000 -- --
05/12/2025 05/12/25 Price Changed $4,500,000 0.0% $690 / Sq Ft
05/12/2025 05/12/25 For Sale $4,500,000 -24.9% $690 / Sq Ft
05/12/2025 05/12/25 Off Market $5,995,000 -- --
05/08/2025 05/08/25 For Sale $5,995,000 0.0% $919 / Sq Ft
05/08/2025 05/08/25 Off Market $5,995,000 -- --
04/01/2025 04/01/25 For Sale $5,995,000 0.0% $919 / Sq Ft
04/01/2025 04/01/25 Off Market $5,995,000 -- --
03/17/2025 03/17/25 For Sale $5,995,000 0.0% $919 / Sq Ft
03/15/2025 03/15/25 Off Market $5,995,000 -- --
03/10/2025 03/10/25 For Sale $5,995,000 0.0% $919 / Sq Ft
03/08/2025 03/08/25 Off Market $5,995,000 -- --
10/20/2024 10/20/24 For Sale $5,995,000 0.0% $919 / Sq Ft
10/20/2024 10/20/24 Off Market $5,995,000 -- --
06/21/2024 06/21/24 For Sale $5,995,000 -- $919 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $103,250 --
Source: Public Records

Source: SmartMLS

MLS Number: 24026683

SmartMLS

APN: STAM-000001-000000-007033