NOT LISTED FOR SALE

290 Bayberry Dr Hewlett, NY 11557

Estimated Value: $1,907,990 - $2,042,000

3 Beds
7 Baths
4,040 Sq Ft
$489/Sq Ft Est. Value

Sale Details

Date Sold: December 6, 2024

Last sale price $1,775,000 $439 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $13,200 / mo

103 Days on Market

Highlights

  • In Ground Pool
  • 2-Story Property
  • Main Floor Primary Bedroom
  • George W Hewlett High School Rated A+
  • Wood Flooring
  • Formal Dining Room

About This Home

As of December 2024

Enter 290 Bayberry Dr an elegant and graciously appointed custom built home with beautiful open verdant views from every room. The living space begins with a large foyer, powder room and a library/ den to a sprawling open concept living room and dining room with original patina wide plank floors. The FIRST FLOOR master bedroom now encompasses 2 bedrooms (never too many closets) and there is another bedroom on same floor. Upstairs is a very large bedroom and full bathroom and a HUGH OPEN HIGH CEILING ATTIC (more bedrooms?) Entertainment is made effortless from the large eat in kitchen through the back sliding doors to a gorgeous planted backyard with inground gunite pool and cabana with kitchen and 2 full bathrooms. 3/4 acres 2 lots., Additional information: Appearance:Excellent,Interior Features:Marble Bath

Last Agent to Sell the Property

Wendy Lichtenberg

Howard Hanna Coach Brokerage Phone: 516-374-0100 License #40LI1036125 Listed on: 06/07/2024

Last Buyer's Agent

Gil Shemtov

Douglas Elliman Real Estate License #10401250882

Douglas Elliman Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $32,252

Year Built

  • Built in 1951

Lot Details

  • 34,702 Sq Ft Lot
  • Partially Fenced Property
  • Front Yard Sprinklers

Home Design

  • 2-Story Property
  • Brick Exterior Construction
  • Frame Construction
  • Cedar

Interior Spaces

  • Entrance Foyer
  • Formal Dining Room
  • Wood Flooring
  • Eat-In Kitchen

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • En-Suite Primary Bedroom
  • Walk-In Closet

Home Security

  • Home Security System
  • Fire Sprinkler System

Parking

  • Attached Garage
  • Driveway

Pool

  • In Ground Pool

Schools

  • Hewlett Elementary School
  • Woodmere Middle School
  • George W Hewlett High School

Utilities

  • Central Air
  • Hot Water Heating System
  • Heating System Uses Natural Gas
  • Heating System Uses Oil
  • Gas Water Heater

Listing and Financial Details

  • Exclusions: Chandelier(s)
  • Legal Lot and Block 6 and 114 / 202
  • Assessor Parcel Number 2017-42-202-00-0006-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$32,252

Year Built

Built in 1951

Lot Details

0.8 Acres

Listing Details

  • Property Type: Residential
  • Architectural Style: Exp Ranch
  • Property SubType: Single Family Residence
  • Levels: Two
  • Exclusions: Chandelier(s)
  • Year Built: 1951
  • Attribution Contact: 516-374-0100
  • CurrentPrice: 1775000.00
  • MlsMajorChangeType: Sold
  • ListPrice_By_OriginalListPrice: 0.89621
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Gas Water Heater
  • Interior Amenities: Eat-in Kitchen, Entrance Foyer, Master Downstairs, Walk-In Closet(s), Formal Dining, Primary Bathroom
  • Flooring: Hardwood
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Basement: None
  • Total Bedrooms: 3
  • Basement YN: No
  • ResoLivingAreaSource: PublicRecords

Exterior Features

  • Construction Materials: Frame, Brick, Cedar
  • Fencing: Partial
  • Pool Features: In Ground
  • Pool Private: Yes
  • Spa: No

Garage/Parking

  • Parking Description: Private, Attached, Driveway

Utilities

  • Cooling: Central Air
  • Heating: Hot Water, Natural Gas, Oil
  • Security: Fire Sprinkler System, Security System
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: Woodmere Middle School

Lot Info

  • Lot Dimensions: 119x217+
  • Lot Size Sq Ft: 34702
  • Lot Features: Sprinklers In Front
  • Parcel Number: 2017-42-202-00-0006-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Multi Family

  • Units Total: 1

Tax Info

  • Tax Annual Amount: 32252.08
  • Tax Block: 202
  • Tax Lot: 6 and 114

MLS Schools

  • Elementary School: Hewlett Elementary School
  • High School: George W Hewlett High School

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 7, 2024
Closed on
Dec 5, 2024
Sold by
Bought by
Seller's Agent
Wendy Lichtenberg
Howard Hanna Coach
Buyer's Agent
Gil Shemtov
Douglas Elliman Real Estate
List Price
$2,399,000
Sold Price
$1,775,000
Premium/Discount to List
-$624,000
-26.01%
Current Estimated Value
$1,974,995

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$199,995
Avg. Annual Appreciation
7.43%
Original Mortgage
$1,420,000
Outstanding Balance
$1,398,418
Interest Rate
6.79%
Mortgage Type
New Conventional
Estimated Equity
$576,577

Purchase Details

Closed on
Aug 16, 2004
Sold by
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$1,775,000 Commonwealth Land Ttl Ins Co
$1,775,000 Commonwealth Land Ttl Ins Co
$1,775,000 Commonwealth Land Ttl Ins Co
$1,775,000 Commonwealth Land Ttl Ins Co
-- --
-- --
-- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $1,420,000
Closed $1,420,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
12/06/2024 12/06/24 Sold $1,775,000 -26.0% $439 / Sq Ft
09/18/2024 09/18/24 Pending -- -- --
06/07/2024 06/07/24 For Sale $2,399,000 -- $594 / Sq Ft
Source: OneKey® MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $30,518 $1,051 $629 $422
2025 $30,518 $1,009 $604 $405
2024 $5,835 $1,010 $604 $406
2023 $27,638 $1,013 $606 $407
2022 $27,638 $1,051 $629 $422
2021 $39,259 $1,100 $625 $475
2020 $28,775 $1,314 $986 $328
2019 $27,842 $1,408 $990 $418
2018 $27,936 $1,502 $0 $0
2017 $23,240 $1,596 $945 $651
2016 $28,665 $1,689 $916 $773
2015 $5,639 $1,783 $967 $816
2014 $5,639 $1,783 $967 $816
2013 $5,669 $1,947 $1,056 $891
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: L3557326

OneKey® MLS

APN: 2017-42-202-00-0006-0

Your Personal Tour Guide

Ask me questions while you tour the home.