NOT LISTED FOR SALE

Estimated Value: $3,144,262 - $3,635,000

4 Beds
4.5 Baths
5,229 Sq Ft
$653/Sq Ft Est. Value

Last Sold October 11, 2024

Last sale price $3,400,000 $650 Per Sq Ft

Current estimated payment $21,836/month

34 Days on Market

Highlights

  • Home fronts a sound
  • 0.61 Acre Lot
  • Attic
  • Sub-Zero Refrigerator
  • Colonial Architecture
  • 2 Fireplaces

About This Home

As of October 2024

This is a unique opportunity to own a direct waterfront home on the LI Sound in prestigious Shippan Point. This stunning French Chateau style home has 172 feet of water frontage, a private neighborhood beach, on over 1/2 acre of land. It features a stunning kitchen with top-of-the-line appliances, 2 family rooms, 2 offices, dining room, living room with fireplace, and a gym, all with gorgeous water views. There is also rec room over garage with a 1/2 bath. The primary bedroom is a suite, with a sitting area with fireplace, and a private balcony overlooking the water. There are 3 additional bedrooms all that lead out to a huge balcony and one with an ensuite bath. The property is professionally landscaped with many perennial gardens. Enjoy spectacular sunsets and sail boats sailing by from almost every room. Move right in to this turn-key coastal home and enjoy every day as if you are on vacation. Close to the Stamford Yacht Club, train station, vibrant downtown Stamford, and Chelsea Piers.

Last Agent to Sell the Property

Barbara Ryan

William Raveis Real Estate License #RES.0765723 Listed on: 08/23/2024

William Raveis Real Estate

Last Buyer's Agent

Bradley Brammer

William Pitt Sotheby's Int'l License #RES.0791473

William Pitt Sotheby's Int'l

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $49,925

Year Built

  • Built in 1930

Lot Details

  • 0.61 Acre Lot
  • Home fronts a sound
  • Property is zoned R10

Parking

  • 2 Car Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Stone Foundation
  • Frame Construction
  • Slate Roof
  • Masonry Siding

Interior Spaces

  • 5,229 Sq Ft Home
  • 2 Fireplaces
  • Partial Basement
  • Pull Down Stairs to Attic

Kitchen

  • Gas Range
  • Range Hood
  • Microwave
  • Sub-Zero Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Schools

  • Toquam Magnet Elementary School
  • Rippowam Middle School
  • Stamford High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 313009

Home Details

Home Type

Single Family

Est. Annual Taxes

$49,925

Year Built

Built in 1930

Lot Details

0.61 Acres

Listing Details

  • Neighborhood: Shippan
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 5229
  • Total Sq Ft: 5229
  • Year Built: 1930
  • New Construction: No/Resale
  • Direct Waterfront: Yes
  • Home Warranty Offered: No
  • Directions: Front door is at the end of Ralsey Rd. House is to the right of the beach. Park on street.
  • Financing Used: Conventional Fixed
  • Street Type: Avenue
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Attic Description: Pull-Down Stairs
  • Basement Description: Partial
  • Appliances: Gas Range, Microwave, Range Hood, Subzero, Dishwasher, Disposal, Washer, Dryer
  • Laundry Room Location: On first floor
  • Laundry Room Info: Main Level
  • Attic: Yes

Exterior Features

  • Exterior Siding: Brick
  • Foundation Type: Stone
  • Roof Information: Slate
  • Waterfront Description: L. I. Sound Frontage
  • Swimming Pool: No
  • Construction Description: Frame, Brick

Garage/Parking

  • Garages Number: 2
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Natural Gas, Tank Size Unknown
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Lot Info

  • Acres: 0.61
  • Lot Description: Level Lot Water View
  • Zoning: R10
  • Parcel #: 313009

Tax Info

  • Tax Year: July 2024-June 2025
  • Property Tax: 49925

MLS Schools

  • Elementary School: Toquam Magnet
  • Middle Jr High School: Rippowam
  • High School: Stamford

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 23, 2024
Closed on
Oct 11, 2024
Sold by
Lavy Samantha and Lavy Gad
Bought by
Mckay Duncan K
Seller's Agent
Barbara Ryan
William Raveis Real Estate
Buyer's Agent
Bradley Brammer
William Pitt Sotheby's Int'l
List Price
$3,350,000
Sold Price
$3,400,000
Premium/Discount to List
$50,000
1.49%
Views
53
Current Estimated Value
$3,415,316

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$15,316
Avg. Annual Appreciation
0.33%
Original Mortgage
$2,720,000
Outstanding Balance
$2,676,084
Interest Rate
6.13%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$739,232

Purchase Details

Listed on
Nov 1, 2021
Closed on
Feb 16, 2022
Sold by
Hoiles Pamela J
Bought by
Lavy Gad and Lavy Samantha
Seller's Agent
Rhoda Freedberg
Brown Harris Stevens
Buyer's Agent
Steve Anastos
William Raveis Real Estate
List Price
$3,000,000
Sold Price
$3,230,000
Premium/Discount to List
$230,000
7.67%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.95%
Original Mortgage
$1,500,000
Interest Rate
3.55%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jun 15, 2016
Sold by
Sussan David L and Lynch-Sussan Eileen
Bought by
Hoiles Pamela J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,100,000
Interest Rate
2%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Mar 23, 2000
Sold by
Anderson Gilda
Bought by
Sussan David L and Lynch Eileen
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Mckay Duncan K $3,400,000 None Available
Mckay Duncan K $3,400,000 None Available
Mckay Duncan K $3,400,000 None Available
Lavy Gad $3,230,000 None Available
Lavy Gad $3,230,000 None Available
Lavy Gad $3,230,000 None Available
Hoiles Pamela J $2,595,666 --
Hoiles Pamela J $2,595,666 --
Sussan David L $1,425,000 --
Hoiles Pamela J $2,595,666 --
Sussan David L $1,425,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mckay Duncan K $2,720,000
Closed Mckay Duncan K $2,720,000
Previous Owner Lavy Gad $1,500,000
Previous Owner Hoiles Pamela J $1,100,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/11/2024 10/11/24 Sold $3,400,000 +1.5% $650 / Sq Ft
09/26/2024 09/26/24 Pending -- -- --
08/23/2024 08/23/24 For Sale $3,350,000 +3.7% $641 / Sq Ft
02/17/2022 02/17/22 Sold $3,230,000 +7.7% $618 / Sq Ft View Prior Sale
12/06/2021 12/06/21 Pending -- -- --
11/01/2021 11/01/21 For Sale $3,000,000 -- $574 / Sq Ft
Source: SmartMLS

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 $51,122 $2,137,200 $1,332,540 $804,660
2024 $49,925 $2,137,200 $1,332,540 $804,660
2023 $53,943 $2,137,200 $1,332,540 $804,660
2022 $46,753 $1,720,770 $1,042,900 $677,870
2021 $46,358 $1,720,770 $1,042,900 $677,870
2020 $45,342 $1,720,770 $1,042,900 $677,870
2019 $45,342 $1,720,770 $1,042,900 $677,870
2018 $43,931 $1,720,770 $1,042,900 $677,870
2017 $55,635 $2,068,990 $1,427,110 $641,880
2016 $54,042 $2,068,990 $1,427,110 $641,880
2015 $52,614 $2,068,990 $1,427,110 $641,880
2014 $53,817 $2,170,910 $1,529,030 $641,880
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24040436

SmartMLS

APN: STAM-000000-000000-000419

Your Personal Tour Guide

Ask me questions while you tour the home.