NOT LISTED FOR SALE

240 Bayberry Dr Hewlett, NY 11557

Estimated Value: $1,868,425 - $2,110,000

5 Beds
4.5 Baths
4,380 Sq Ft
$448/Sq Ft Est. Value

Last Sold March 10, 2022

Last sale price $1,675,000 $382 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $11,247/month

128 Days on Market

Highlights

  • Skyline View
  • Property is near public transit
  • Cathedral Ceiling
  • George W Hewlett High School Rated A+
  • Private Lot
  • Wood Flooring

About This Home

As of March 2022

Magnificent home in the heart of Hewlett Harbor sitting on .43 acres at the end of a private cul-de-sac surrounded by a beautiful landscape & exquisite Green Giant trees for privacy. Picture windows for natural light & amazing forest view. 5 bedrooms 4.5 baths, 4380 sq ft living area invites you w/vestibule entrance, foyer, formal living room w/wood burning fireplace & bar, family room, formal dining room, gourmet eat-in kitchen w/Thermador SS appliances, sep. o/s entrance to Guest Suite w/office/den, Master Suite w/master bath & office, Master Bedroom. NEWER: roof, windows, siding, stone finish, brick/stone patio; NEW: California closets, walk-in closets, 5 panel interior & closet doors, moldings, LED lightings; UPGRADED: electric, 10 zones heating sys. Entire house Aqualife water filtration sys, smart thermostat Nest, huge walk-up attic for storage, central AC, 15 camera sys, huge backyard w/playground & much more. LOTS OF ROOM FOR POOL. Award winning Hewlett-Woodmere SD 14 MUST SEE!

Last Agent to Sell the Property

Asya Bangiyeva

Coldwell Banker American Homes License #10401301425 Listed on: 09/14/2021

Coldwell Banker American Homes

Last Buyer's Agent

Avi Dubin

Avid Homes Inc License #10311209037

Avid Homes Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $32,720

Year Built

  • Built in 1957

Lot Details

  • 0.42 Acre Lot
  • Lot Dimensions are 160x119
  • Cul-De-Sac
  • Back Yard Fenced
  • Private Lot
  • Sprinkler System

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

  • Split Level Home
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • 4,380 Sq Ft Home
  • 3-Story Property
  • Cathedral Ceiling
  • Skylights
  • 1 Fireplace
  • Entrance Foyer
  • Formal Dining Room
  • Home Office
  • Storage
  • Skyline Views
  • Crawl Space

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Granite Countertops

Flooring

  • Wood
  • Wall to Wall Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Powder Room

Laundry

  • ENERGY STAR Qualified Dryer
  • Dryer
  • Washer

Attic

  • Partial Attic
  • Walkup Attic
  • Unfinished Attic

Home Security

  • Home Security System
  • Smart Thermostat

Schools

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

Utilities

  • Ductless Heating Or Cooling System
  • Central Air
  • 10 Heating Zones
  • Hot Water Heating System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Additional Features

  • ENERGY STAR Qualified Equipment for Heating
  • Patio
  • Property is near public transit

Community Details

  • Park

Listing and Financial Details

  • Legal Lot and Block 11 / 202
  • Assessor Parcel Number 2017-42-202-00-0011-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$32,720

Year Built

Built in 1957

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Split Level
  • Property SubType: Single Family Residence
  • Property Condition: Excellent
  • Levels: Three Or More
  • Year Built: 1957
  • New Construction: No
  • Attribution Contact: 516-223-2525
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Cooktop, Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer, ENERGY STAR Qualified Dryer
  • Interior Amenities: Smart Thermostat, Master Downstairs, 1st Floor Bedrm, Cathedral Ceiling(s), Den/Family Room, Eat-in Kitchen, Formal Dining Room, Entrance Foyer, Granite Counters, Home Office, Living Room / Dining Room, Marble Bath, Master Bath, Pantry, Powder Room, Storage, Walk-In Closet(s)
  • Living Area Units: Square Feet
  • Fireplaces: 1
  • Attic Description: Partial, Unfinished, Walkup
  • Flooring: Hardwood, Wall To Wall Carpet
  • Common Walls: No Common Walls
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Crawl Space
  • Inclusions: Alarm System, Chandelier(s), Cook Top, Dishwasher, Dryer, Energy Star Appliance(s), Garage Door Opener, Garage Remote, Intercom, Light Fixtures, Microwave, Refrigerator, Screens, Shades/Blinds, Video Cameras, Wall Oven, Wall to Wall Carpet, Washer
  • Total Bedrooms: 5
  • Fireplace: Yes
  • Living Area: 4380.00
  • Kitchens: 1
  • Window Features: Skylight(s)
  • Square Footage: 4380.00

Exterior Features

  • Construction Materials: Other, Stone, Vinyl Siding
  • Flood Zone Report: No
  • Fencing: Back Yard, Fenced, Partial
  • View: Skyline
  • Exterior Features: Sprinkler Lawn System
  • Patio and Porch Features: Patio
  • View YN: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Description: Private, Attached, 2 Car Attached, Driveway

Utilities

  • Cooling: Central Air, Ductless
  • Cooling: Yes
  • Heating: Natural Gas, ENERGY STAR Qualified Equipment, Hot Water
  • Hot Water: Gas Stand Alone
  • Heating Zones: 10
  • Security: Security System
  • Separate Hotwater Heater Detail: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Association/Amenities

  • Community Features: Park

Condo/Co-op/Association

  • Senior Community: No

Schools

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

Lot Info

  • Lot Size Acres: 0.4200
  • Lot Size Area: 0.4200
  • Lot Dimensions: 160x119
  • Lot Size Sq Ft: 18191.00
  • Lot Size Units: Acres
  • Lot Features: Near Public Transit, Cul-De-Sec, Private
  • Parcel Number: 2017-42-202-00-0011-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Tax Info

  • Close Date: 2022-03-10
  • Included in Taxes: Sewer, Trash
  • Tax Annual Amount: 32720.00
  • Tax Block: 202
  • Tax Lot: 11
  • Tax Other Annual Assessment Amount: 699.00
  • Tax Map Number: 2017-42-202-00-0011-0

MLS Schools

  • Elementary School: 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
Sep 14, 2021
Closed on
Mar 10, 2022
Sold by
Bangiyeva Asya and Bangiyev Boris
Bought by
Rogers Erik Lewis and Dickstein Rogers Ruth
Seller's Agent
Asya Bangiyeva
Coldwell Banker American Homes
Buyer's Agent
Avi Dubin
Avid Homes Inc
List Price
$1,699,000
Sold Price
$1,675,000
Premium/Discount to List
-$24,000
-1.41%
Current Estimated Value
$1,961,856

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$286,856
Avg. Annual Appreciation
4.75%
Original Mortgage
$1,340,000
Outstanding Balance
$1,258,686
Interest Rate
3.92%
Mortgage Type
New Conventional
Estimated Equity
$706,228

Purchase Details

Closed on
Apr 11, 2018
Sold by
Bangiyev Boris
Bought by
Bangiyev Family Trust

Purchase Details

Closed on
Nov 3, 2014
Sold by
Blue Harold and Blue Rebecca
Bought by
Bangiyev Boris

Purchase Details

Closed on
May 24, 2011
Sold by
Fensterman Howard and Fensterman Lori
Bought by
Blue Harold and Blue Rebecca

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
3.5%
Mortgage Type
Purchase Money Mortgage
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
Rogers Erik Lewis $1,675,000 Old Republic
Rogers Erik Lewis $1,675,000 Old Republic
Bangiyev Family Trust -- None Available
Bangiyev Family Trust -- None Available
Bangiyev Boris $1,125,000 None Available
Bangiyev Boris $1,125,000 None Available
Blue Harold $1,050,000 --
Blue Harold $1,050,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Rogers Erik Lewis $90,000
Open Rogers Erik Lewis $1,340,000
Closed Rogers Erik Lewis $1,340,000
Previous Owner Blue Harold $550,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/10/2022 03/10/22 Sold $1,675,000 -1.4% $382 / Sq Ft
01/20/2022 01/20/22 Pending -- -- --
09/14/2021 09/14/21 For Sale $1,699,000 -- $388 / Sq Ft
Source: OneKey® MLS

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 $6,687 $1,109 $545 $564
2024 $6,687 $1,130 $555 $575
2023 $32,584 $1,130 $555 $575
2022 $32,584 $1,130 $555 $575
2021 $45,451 $1,130 $554 $576
2020 $30,385 $1,434 $794 $640
2019 $5,723 $1,511 $836 $675
2018 $24,256 $1,672 $0 $0
2017 $29,720 $2,041 $947 $1,094
2016 $36,658 $2,041 $947 $1,094
2015 -- $2,041 $947 $1,094
2014 -- $2,041 $947 $1,094
2013 $5,943 $2,041 $947 $1,094
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: KEY3345317

OneKey® MLS

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