NOT LISTED FOR SALE

40 Heron Dr Hewlett, NY 11557

Estimated Value: $3,024,000 - $3,320,585

5 Beds
5.5 Baths
10,000 Sq Ft
$317/Sq Ft Est. Value

Last Sold March 15, 2022

Last sale price $2,750,000 $275 Per Sq Ft

Est. 15% increase in value since last sale

Current estimated payment $21,944/month

364 Days on Market

Highlights

  • Docks
  • In Ground Pool
  • Contemporary Architecture
  • George W Hewlett High School Rated A+
  • Waterfront
  • Property is near public transit

About This Home

As of March 2022

Beautiful Waterfront 10,000 Sq Ft Contemporary Home Tucked Away in Cul de Sac. 5 BR, 5.5 Bths with Magnificent Waterviews Throughout. Living Room with Floor to Ceiling Windows & Fpl, FDR, Gran/Wood EIK with Stainless Steel Appliances, Family Room with Theatre, Den with Wet Bar & Fpl. Master Suite Boasts Walls of Windows, Office/Gym, Dressing Rm with Handpainted Ceiling/ Walk in Closets & Master Bth w/ Sauna, Steam & Jacuzzi. Soaring Ceilings throughout. Resortlike 1 Acre Property Features 285' Vinyl Bulkhead Raised & Redone in 2013, 100' Dock, IG Heated Gunite pool, Hot Tub & Patio.. A GEM!!

Last Agent to Sell the Property

Ronnie Gerber

Douglas Elliman Real Estate License #40GE1035696 Listed on: 01/05/2021

Douglas Elliman Real Estate

Last Buyer's Agent

Ronnie Gerber

Douglas Elliman Real Estate License #40GE1035696 Listed on: 01/05/2021

Douglas Elliman Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $71,711

Year Built

  • Built in 1987

Lot Details

  • 1 Acre Lot
  • Waterfront
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Driveway

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Cedar

Interior Spaces

  • 10,000 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Cathedral Ceiling
  • Skylights
  • 2 Fireplaces
  • Entrance Foyer
  • Home Office
  • Storage
  • Home Gym
  • Wood Flooring
  • Water Views
  • Crawl Space
  • No Attic
  • Home Security System

Kitchen

  • Eat-In Kitchen
  • Oven
  • Dishwasher
  • Marble Countertops
  • Granite Countertops

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Powder Room
  • Marble Bathroom Countertops

Laundry

  • Dryer
  • Washer

Outdoor Features

  • In Ground Pool
  • Bulkhead
  • Docks

Location

  • Property is near public transit

Schools

  • Franklin Early Childhood Center Elementary School
  • Woodmere Middle School
  • George W Hewlett High School

Utilities

  • Forced Air Heating and Cooling System
  • 6 Heating Zones
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Municipal Trash

Listing and Financial Details

  • Exclusions: Chandelier(s)
  • Legal Lot and Block 76 / A
  • Assessor Parcel Number 2015-41-A-00-0076-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$71,711

Year Built

Built in 1987

Lot Details

1 Acres

Parking

3

Listing Details

  • Property Type: Residential
  • Architectural Style: Contemporary
  • Property SubType: Single Family Residence
  • Property Condition: Mint
  • Levels: Two
  • Exclusions: Chandelier(s)
  • Building Size: 10000
  • Year Built: 1987
  • New Construction: No
  • Attribution Contact: 516-623-4500
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Dryer, Oven, Refrigerator, Washer
  • Interior Amenities: 1st Floor Bedrm, Cathedral Ceiling(s), Den/Family Room, Eat-in Kitchen, Exercise Room, Entrance Foyer, Granite Counters, Home Office, Marble Bath, Marble Countertops, Master Bath, Pantry, Powder Room, Storage, Walk-In Closet(s), Wet Bar
  • Living Area Units: Square Feet
  • Fireplaces: 2
  • Attic Description: None
  • Flooring: Hardwood
  • Common Walls: No Common Walls
  • Total Bathrooms: 6
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Basement: Crawl Space
  • Inclusions: Dishwasher, Dryer, Refrigerator, Washer
  • Total Bedrooms: 5
  • Fireplace: Yes
  • Living Area: 10000.00
  • Kitchens: 1
  • Window Features: Skylight(s)
  • Square Footage: 10000.00

Exterior Features

  • Construction Materials: Frame, Cedar
  • Flood Zone Date: 2021-01-06
  • Flood Zone Report: Yes
  • Frontage Length: 285
  • Waterfront Features: Waterfront
  • Pool Features: Inground Pool
  • Pool Private: Yes
  • View: Open, Water
  • Exterior Features: Sprinkler Lawn System, Bulkhead, Dock
  • Waterfront: Yes
  • View YN: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.00
  • Garage: Yes
  • Parking Description: Private, Attached, 3 Car Attached, Driveway

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Garbage Removal: Public
  • Heating: Natural Gas, Forced Air
  • Hot Water: Gas Stand Alone
  • Heating Zones: 6
  • Security: Security System
  • Separate Hotwater Heater Detail: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Association/Amenities

  • Community Features: Near Public Transportation

Condo/Co-op/Association

  • Senior Community: No

Schools

  • Middle School: Woodmere Middle School

Lot Info

  • Lot Size Acres: 1.0000
  • Lot Dimensions: 1 Acre
  • Lot Size Sq Ft: 43508.00
  • Lot Size Units: Acres
  • Parcel Number: 2015-41-A-00-0076-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Tax Info

  • Close Date: 2022-03-15
  • Included in Taxes: Sewer, Trash
  • Tax Annual Amount: 71711.00
  • Tax Block: A
  • Tax Lot: 76
  • Tax Other Annual Assessment Amount: 1779.00
  • Tax Map Number: 2015-41-A-00-0076-0

MLS Schools

  • Elementary School: Franklin Early Childhood Center, Hewlett Elementary School
  • High School: George W Hewlett High School
  • Middle School District: Hewlett-Woodmere

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 5, 2021
Closed on
Mar 15, 2022
Sold by
Libertoff Gary and Roni Libertoff 2020 Living Trust
Bought by
Koen Alexander and Koen Ester
Seller's Agent
Ronnie Gerber
Douglas Elliman Real Estate
Buyer's Agent
Ronnie Gerber
Douglas Elliman Real Estate
List Price
$3,499,000
Sold Price
$2,750,000
Premium/Discount to List
-$749,000
-21.41%
Current Estimated Value
$3,172,293

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$422,293
Avg. Annual Appreciation
3.60%
Original Mortgage
$1,475,000
Outstanding Balance
$1,353,412
Interest Rate
2.62%
Mortgage Type
New Conventional
Estimated Equity
$1,818,881

Purchase Details

Closed on
Sep 8, 2020
Sold by
Libertoff Roni
Bought by
Libertoff 2020 Trust
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
Koen Alexander $2,750,000 First American Title Ins Co
Koen Alexander $2,750,000 First American Title Ins Co
Koen Alexander $2,750,000 First American Title Ins Co
Koen Alexander $2,750,000 First American Title Ins Co
Libertoff 2020 Trust -- None Available
Libertoff 2020 Trust -- None Available
Libertoff 2020 Trust -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Koen Alexander $1,475,000
Closed Koen Alexander $1,475,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/15/2022 03/15/22 Sold $2,750,000 -21.4% $275 / Sq Ft
01/04/2022 01/04/22 Pending -- -- --
12/13/2021 12/13/21 For Sale $3,499,000 +27.2% $350 / Sq Ft
12/12/2021 12/12/21 Off Market $2,750,000 -- --
09/25/2021 09/25/21 Price Changed $3,499,000 -5.4% $350 / Sq Ft
07/22/2021 07/22/21 Price Changed $3,699,000 -7.5% $370 / Sq Ft
05/27/2021 05/27/21 Price Changed $3,999,000 -14.0% $400 / Sq Ft
01/05/2021 01/05/21 For Sale $4,650,000 -- $465 / Sq Ft
Source: OneKey® MLS

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 $59,914 $1,980 $774 $1,206
2024 $13,144 $2,172 $849 $1,323
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: KEY3278397

OneKey® MLS

APN: 2015-41-A-00-0076-0

Your Personal Tour Guide

Ask me questions while you tour the home.