NOT LISTED FOR SALE

Estimated Value: $1,283,000 - $1,645,491

5 Beds
6 Baths
4,257 Sq Ft
$346/Sq Ft Est. Value

Last Sold March 23, 2023

Last sale price $1,380,000 $324 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $9,058/month

37 Days on Market

Highlights

  • Beach Access
  • Heated In Ground Pool
  • Deck
  • Barn
  • 2.54 Acre Lot
  • Property is near public transit

About This Home

As of March 2023

Enchanting former Andrew Mellon Estate set far back from the road on magnificently landscaped 2.5 acres with an in-ground pool. This one of a kind home has been renovated and meticulously maintained to preserve the charm of its 1927 origins, yet updated for today's lifestyle. Vaulted ceilings, abundant windows, built-ins, hardwood floors throughout and custom mill work are just some of the many interior details. The versatile floorpan includes one level living with a renovated primary suite on the first floor, separate wing for guests plus private office with separate entrance. The recently renovated eat in kitchen features custom cabinetry, quartz countertops and top grade wolf appliances. The first floor also includes a vaulted ceiling living room with fireplace & beams plus an enclosed porch for relaxing and enjoying nature. The charming library off the primary bedroom also includes a cozy fireplace, custom built-ins, 9ft ceilings & leaded glass windows. A holiday sized dining room with custom built-ins and floor to ceiling windows showcasing the gardens year round. A separate family room above the garages offers a private space with vaulted ceilings, hardwood floors, built-ins full bath and gym area. Not to be overlooked are the professionally landscaped gardens highlighted by a heated salt water pool, two stone patios, a private deck off the kitchen, separate heated & cooled garage, automatic transfer generator plus shed add to the ambience of a mini estate.

Last Agent to Sell the Property

Tom Vozzella

Berkshire Hathaway NE Prop. License #RES.0760084 Listed on: 01/18/2023

Berkshire Hathaway NE Prop.

Last Buyer's Agent

Cora Lynch-O'Meara

Brown Harris Stevens License #RES.0803479

Brown Harris Stevens

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,464

Year Built

  • Built in 1927

Lot Details

  • 2.54 Acre Lot
  • Secluded Lot
  • Sprinkler System
  • Many Trees

Home Design

  • Ranch Style House
  • Cottage
  • Stone Foundation
  • Stone Frame
  • Frame Construction
  • Asphalt Shingled Roof
  • Wood Siding
  • Radon Mitigation System
  • Stone

Interior Spaces

  • 4,257 Sq Ft Home
  • 2 Fireplaces
  • French Doors
  • Entrance Foyer
  • Heated Enclosed Porch
  • Unfinished Basement
  • Partial Basement
  • Home Security System
  • Attic

Kitchen

  • Built-In Oven
  • Gas Range
  • Range Hood
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry Room
  • Laundry on main level

Parking

  • 3 Car Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Private Driveway

Pool

  • Heated In Ground Pool
  • Saltwater Pool
  • Vinyl Pool
  • Fence Around Pool

Outdoor Features

  • Beach Access
  • Deck
  • Patio
  • Terrace
  • Exterior Lighting
  • Shed

Location

  • Property is near public transit
  • Property is near a bus stop

Schools

  • Roxbury Elementary School
  • Cloonan Middle School
  • Westhill High School

Farming

  • Barn

Utilities

  • Central Air
  • Heating System Uses Oil
  • Power Generator
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Public Transportation

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,464

Year Built

Built in 1927

Lot Details

0

Listing Details

  • Neighborhood: North Stamford
  • Property Type: Single Family For Sale
  • Style: Ranch, Cottage
  • Sq Ft Est Heated Above Grade: 4257
  • Public Record Living Room Sq Ft: 3957
  • Total Sq Ft: 4257
  • Year Built: 1927
  • Nearby Amenities: Public Transportation, Stables/Riding, Walk to Bus Lines
  • In Law Access: First Floor
  • In Law Apartment: Possible
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Radon Mitigation Water Ynu: No
  • Public Record Gross Sq Ft: 9848
  • Tax Year Updated Dt: 01/18/2023
  • Directions: North On Long Ridge To 2297 Long Driveway On Right just before yellow mailbox.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 11
  • Total Bedrooms: 5
  • Total Bathrooms: 6.00
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 2
  • Basement Description: Partial, Unfinished
  • Interior Amenities: Auto Garage Door Opener, Cable - Pre-wired, Security System
  • Appliances: Gas Range, Wall Oven, Range Hood, Refrigerator, Dishwasher
  • Additional Rooms: Foyer, Laundry Room
  • Laundry Room Location: First Floor-Off Kit
  • Laundry Room Info: Main Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Barn, Deck, French Doors, Lighting, Patio, Porch-Heated, Shed, Terrace, Underground Sprinkler
  • Exterior Siding: Wood
  • Foundation Type: Stone
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Beach Rights
  • Swimming Pool: Yes
  • Pool: In Ground Pool, Heated, Salt Water, Safety Fence, Vinyl
  • Construction Description: Frame, Stone

Garage/Parking

  • Garage Parking Info: Attached Garage, Detached Garage
  • Garages Number: 3
  • Driveway Type: Private, Paved

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Oil
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • HOA: No
  • Special Association Assessment Y: No

Green Features

  • Energy Features: Generator

Lot Info

  • Acres: 2.5400
  • Lot Description: Secluded, Treed, Fence - Partial, Professionally Landscaped
  • Zoning: RES

Tax Info

  • Tax Year: July 2022-June 2023
  • Property Tax: 14464
  • Mil Rate Base: 26.330
  • Assessor Parcel Number: 313877

MLS Schools

  • Elementary School: Roxbury
  • Middle Jr High School: Cloonan
  • High School: Westhill

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 18, 2023
Closed on
Mar 16, 2023
Sold by
Rosenblatt Doreen
Bought by
Wu Yichun and Zhang Xiaobing
Seller's Agent
Tom Vozzella
Berkshire Hathaway NE Prop.
Buyer's Agent
Cora Lynch-O'Meara
Brown Harris Stevens
List Price
$1,379,000
Sold Price
$1,380,000
Premium/Discount to List
$1,000
0.07%
Views
67
Current Estimated Value
$1,470,873

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$90,873
Avg. Annual Appreciation
2.48%

Purchase Details

Closed on
Apr 24, 2018
Sold by
Rosenblatt Robert
Bought by
Rosenblatt Doreen

Purchase Details

Listed on
Apr 26, 2012
Closed on
Mar 27, 2013
Sold by
Ohalpin Valerie L and Ohalpin James J
Bought by
Rosenblatt Doreen and Rosenblatt Robert
Seller's Agent
Isabel Dreyer
Berkshire Hathaway NE Prop.
Buyer's Agent
Joann Alexander
Coldwell Banker Realty
List Price
$1,299,000
Sold Price
$865,000
Premium/Discount to List
-$434,000
-33.41%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.30%
Original Mortgage
$150,000
Interest Rate
3.56%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 5, 1990
Sold by
Volk Spencer
Bought by
Ohalpin James

Purchase Details

Closed on
Jul 30, 1987
Sold by
Kaufman Michael
Bought by
Volk Spencer
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Wu Yichun $1,380,000 None Available
Rosenblatt Doreen -- --
Rosenblatt Doreen $864,500 --
Ohalpin James $800,000 --
Volk Spencer $1,150,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Volk Spencer $150,000
Previous Owner Volk Spencer $249,690
Previous Owner Volk Spencer $249,690
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/23/2023 03/23/23 Sold $1,380,000 +0.1% $324 / Sq Ft
02/24/2023 02/24/23 Pending -- -- --
01/18/2023 01/18/23 For Sale $1,379,000 +59.4% $324 / Sq Ft
03/26/2013 03/26/13 Sold $865,000 -33.4% $219 / Sq Ft View Prior Sale
02/24/2013 02/24/13 Pending -- -- --
04/26/2012 04/26/12 For Sale $1,299,000 -- $328 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

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 $16,306 $700,730 $308,110 $392,620
2024 $15,949 $700,730 $308,110 $392,620
2023 $17,140 $700,730 $308,110 $392,620
2022 $14,464 $549,350 $233,410 $315,940
2021 $14,267 $549,350 $233,410 $315,940
2020 $13,915 $549,350 $233,410 $315,940
2019 $13,915 $549,350 $233,410 $315,940
2018 $13,432 $549,350 $233,410 $315,940
2017 $13,825 $540,240 $243,570 $296,670
2016 $13,409 $540,240 $243,570 $296,670
2015 $13,041 $540,240 $243,570 $296,670
2014 $12,593 $540,240 $243,570 $296,670
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170545353

SmartMLS

APN: STAM-000000-000000-001417