NOT LISTED FOR SALE

124 Hampshire Rd Great Neck, NY 11023

Estimated Value: $1,251,000 - $1,283,425

4 Beds
1.5 Baths
2,000 Sq Ft
$634/Sq Ft Est. Value

Last Sold April 08, 2024

Last sale price $1,218,000 $609 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $7,766/month

34 Days on Market

Highlights

  • Basketball Court
  • Bridge View
  • Deck
  • Elizabeth M. Baker Elementary School Rated A+
  • Colonial Architecture
  • Property is near public transit

About This Home

As of April 2024

Welcome to this beautiful sunlit colonial gem that's been thoughtfully renovated for today's modern family. With its prime location on an expansive 7500 sq ft lot, this residence captures both space and sophistication in its 2,000 sq ft interior. Upon entry, you're greeted by a spacious, bright, and open living area, family room, formal dining room, and a newly updated eat in kitchen, equipped with the latest appliances. The sliding doors from the kitchen and dining room allow for an extended area for you to host your family and friends. Second floor features four bedrooms, full bath, and access to the walkup finished attic. The finished basement offers a family game room, a quiet workspace, a fitness area, and laundry room. The house was recently updated with new Pella brand windows throughout, ductless A/C and heat, new exterior siding, and more! Steps away from the community pool, the tennis courts, parks and the ice-skating rink, recreational activities abound year-round. Zoned for Baker Hill Elementary, Great Neck North Middle, and Great Neck North High School. This house won't last !

Last Agent to Sell the Property

Soheil Payami

Pomp Realty Advisors Inc Brokerage Phone: 718-850-6000 License #10401289393 Listed on: 12/01/2023

Co-Listed By

Nancy Moinian

LAFFEY REAL ESTATE Brokerage Phone: 718-850-6000 License #30MO0888811

Last Buyer's Agent

Rebecca Namdar

Blue Island Homes NY LLC License #10401361943

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,311

Year Built

  • Built in 1923 | Remodeled in 2020

Lot Details

  • 7,500 Sq Ft Lot
  • Lot Dimensions are 50x150
  • East Facing Home
  • Private Entrance
  • Back Yard Fenced

Parking

  • 2 Car Detached Garage
  • Driveway

Property Views

  • Bridge
  • Skyline

Home Design

  • Colonial Architecture
  • Blown Fiberglass Insulation
  • Aluminum Siding
  • Block Exterior

Interior Spaces

  • 2,000 Sq Ft Home
  • 3-Story Property
  • 1 Fireplace
  • New Windows
  • Double Pane Windows
  • ENERGY STAR Qualified Doors
  • Insulated Doors
  • Entrance Foyer
  • Formal Dining Room
  • Home Office
  • Storage
  • Home Gym
  • Wood Flooring
  • Finished Basement
  • Walk-Out Basement

Kitchen

  • Eat-In Kitchen
  • Stove
  • ENERGY STAR Qualified Refrigerator
  • Freezer
  • ENERGY STAR Qualified Dishwasher
  • Marble Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Powder Room

Laundry

  • ENERGY STAR Qualified Dryer
  • Dryer
  • Washer

Home Security

  • Home Security System
  • Storm Doors

Outdoor Features

  • Basketball Court
  • Deck
  • Patio

Location

  • Property is near public transit

Schools

  • E M Baker Elementary School
  • Great Neck North Middle School
  • Great Neck North High School

Utilities

  • Ductless Heating Or Cooling System
  • Humidifier
  • Hot Water Heating System
  • Heating System Uses Natural Gas
  • ENERGY STAR Qualified Water Heater

Community Details

  • Park

Listing and Financial Details

  • Exclusions: Chandelier(s)
  • Legal Lot and Block 9 / 87
  • Assessor Parcel Number 2209-01-087-00-0009-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,311

Year Built

Built in 1923 | Remodeled in 2020

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Colonial
  • Property SubType: Single Family Residence
  • Property Condition: EXCELLENT
  • Levels: Three Or More
  • Exclusions: Chandelier(s)
  • Year Built: 1923
  • New Construction: No
  • Year Built Effective: 2020
  • Attribution Contact: 718-850-6000
  • Co List Office Mls Id: ONELRE12
  • Co List Office Phone: 516-482-1111
  • Special Features: None
  • Property Sub Type: Detached
  • Year Renovated: 2020

Interior Features

  • Appliances: Dishwasher, Dryer, Freezer, Humidifier, Refrigerator, Washer, ENERGY STAR Qualified Dishwasher, ENERGY STAR Qualified Dryer, ENERGY STAR Qualified Refrigerator, ENERGY STAR Qualified Stove, ENERGY STAR Qualified Water Heater
  • Interior Amenities: Den/Family Room, Eat-in Kitchen, Exercise Room, Formal Dining, Entrance Foyer, Home Office, Marble Counters, Pantry, Powder Room, Storage, Walk-In Closet(s)
  • Living Area Units: Square Feet
  • Fireplaces: 1
  • Flooring: Hardwood
  • Door Features: ENERGY STAR Qualified Doors, Insulated Doors, Storm Door(s)
  • Common Walls: No Common Walls
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement: Finished, Walk-Out Access
  • Inclusions: A/C Units,Alarm System,Basketball Hoop,Ceiling Fan,Chandelier(s),Convection Oven,Curtains/Drapes,Dehumidifier,Dishwasher,Dryer,Fireplace Equip,Flat Screen TV Bracket,Freezer,Humidifier,Refrigerator,Screens,Shades/Blinds,Washer
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Living Area: 2000
  • Window Features: New Windows, Double Pane Windows
  • AtticDescription: Dormer,Finished,Full,Walkup
  • SquareFootage: 2000.00
  • SquareFootageSource: Municipality
  • NumberOfKitchens: 1

Exterior Features

  • Direction Faces: East
  • Construction Materials: Block, Fiberglass Insulation, Aluminum Siding
  • Fencing: Back Yard, Fenced
  • View: Bridge(s), City, Skyline
  • Exterior Features: Basketball Court, Private Entrance
  • Patio and Porch Features: Deck, Patio
  • View YN: Yes
  • FloodZoneReportYN: 1

Garage/Parking

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

Utilities

  • Cooling: Ductless
  • Cooling: Yes
  • Heating: Natural Gas, Hot Water
  • Security: Security System
  • Sewer: Public Sewer
  • Water Source: Public
  • GarbageRemoval: Public
  • Hot Water: Gas Stand Alone
  • NumberOfHeatingZones: 2

Association/Amenities

  • Community Features: Park, Near Public Transportation

Condo/Co-op/Association

  • Senior Community: No

Schools

  • Middle School: Great Neck North Middle School

Lot Info

  • Lot Size Acres: 0.17
  • Lot Dimensions: 50x150
  • Lot Size Sq Ft: 7500
  • Lot Size Units: Acres
  • Lot Features: Near Public Transit
  • Parcel Number: 2209-01-087-00-0009-0
  • Property Attached: No
  • ResoLotSizeUnits: Acres
  • FloodZoneDate: 2023-12-04

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 15311
  • Tax Block: 87
  • Tax Lot: 9
  • Tax Other Annual Assessment Amount: 1298
  • Tax Map Number: 2209-01-087-00-0009-0
  • IncludedInTaxes: Sewer,Trash

MLS Schools

  • Elementary School: E M Baker School
  • High School: Great Neck North High School
  • Middle School District: Great Neck

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 1, 2023
Closed on
Apr 8, 2024
Sold by
Yazdan Esther and Yazdan Edmond
Bought by
Livian Mitchell and Livian Azita
Seller's Agent
Soheil Payami
Pomp Realty Advisors Inc
Buyer's Agent
Rebecca Namdar
Blue Island Homes NY LLC
List Price
$1,298,000
Sold Price
$1,218,000
Premium/Discount to List
-$80,000
-6.16%
Views
96
Current Estimated Value
$1,267,213

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$49,213
Avg. Annual Appreciation
2.41%
Original Mortgage
$550,000
Outstanding Balance
$541,273
Interest Rate
6.88%
Mortgage Type
New Conventional
Estimated Equity
$725,940

Purchase Details

Closed on
Jul 30, 2015
Sold by
Sabetfard Eliza
Bought by
Yazdan Esther and Yazdan Edmond

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$625,000
Interest Rate
4.08%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 16, 2004
Sold by
Pogue Edith
Bought by
Sabetfard Eliza
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
Livian Mitchell $1,218,000 Fidelity Title Insurance Co
Livian Mitchell $1,218,000 Fidelity Title Insurance Co
Yazdan Esther $790,000 Judicial Title Insurance
Yazdan Esther $790,000 Judicial Title Insurance
Yazdan Esther $790,000 Judicial Title Insurance
Sabetfard Eliza $700,000 --
Sabetfard Eliza $700,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Livian Mitchell $550,000
Closed Livian Mitchell $550,000
Previous Owner Yazdan Esther $625,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/08/2024 04/08/24 Sold $1,218,000 -6.2% $609 / Sq Ft
01/09/2024 01/09/24 Pending -- -- --
12/05/2023 12/05/23 For Sale $1,298,000 -- $649 / 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 $13,434 $712 $350 $362
2024 $3,993 $785 $386 $399
2023 $14,501 $900 $442 $458
2022 $14,501 $912 $448 $464
2021 $13,981 $944 $464 $480
2020 $14,349 $1,134 $1,133 $1
2019 $12,425 $1,260 $1,259 $1
2018 $13,010 $1,260 $0 $0
2017 $8,420 $1,305 $1,304 $1
2016 $12,253 $1,478 $1,477 $1
2015 $4,151 $1,478 $1,477 $1
2014 $4,151 $1,478 $1,477 $1
2013 $3,942 $1,478 $1,477 $1
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: OneKey® MLS

MLS Number: KEY3519053

OneKey® MLS

APN: 2209-01-087-00-0009-0