NOT LISTED FOR SALE

51 Hampshire Rd Great Neck, NY 11023

Estimated Value: $1,650,973 - $1,681,000

4 Beds
3 Baths
2,760 Sq Ft
$604/Sq Ft Est. Value

Last Sold October 30, 2024

Last sale price $1,580,000 $572 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $10,046/month

20 Days on Market

Highlights

  • Deck
  • Property is near public transit
  • 1 Fireplace
  • Elizabeth M. Baker Elementary School Rated A+
  • Tudor Architecture
  • Granite Countertops

About This Home

As of October 2024

Nestled in the serene neighborhood of Great Neck, this exquisite residence offers the essence of luxurious living. Featuring timeless elegance and modern amenities, this property presents a rare opportunity to indulge in comfort and sophistication. As you step inside, you're greeted by a grand foyer that sets the tone for the rest of the home. Beautiful tile floors lead you through the spacious layout, adorned with intricate details and fine craftsmanship at every turn. The heart of this home is its gourmet kitchen, featuring top-of-the-line appliances, granite countertops custom cabinetry, and a center island perfect for culinary adventures and casual dining. Entertain guests in the formal dining room, or unwind in the living room by the fireplace. The home features a first-floor guest quarters/office with a private entrance. Upstairs, the lavish primary suite awaits, offering a private sanctuary complete with a luxurious spa-like bathroom and walk-in closets. An additional primary bedroom and additional bedroom provide comfort and versatility, ideal for family living or accommodating guests. Outside, the expansive backyard is ideal for outdoor gatherings and al fresco dining. A beautiful deck, lush landscaping, and manicured gardens create a tranquil oasis, perfect for relaxation and recreation. It is conveniently located near top-rated schools, upscale shopping, dining, and recreational amenities., Additional information: Appearance:Excellent,Interior Features:Guest Quarters,Separate Hotwater Heater:yes

Last Agent to Sell the Property

Andrea Levine

Keller Williams Rty Gold Coast License #10301221387 Listed on: 05/24/2024

Keller Williams Rty Gold Coast

Last Buyer's Agent

Andrea Levine

Keller Williams Rty Gold Coast License #10301221387 Listed on: 05/24/2024

Keller Williams Rty Gold Coast

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $19,136

Year Built

  • Built in 1935

Lot Details

  • 5,300 Sq Ft Lot
  • Lot Dimensions are 53x100
  • Partially Fenced Property
  • Front Yard Sprinklers

Home Design

  • Tudor Architecture
  • Brick Exterior Construction
  • Frame Construction

Interior Spaces

  • 2,760 Sq Ft Home
  • 2-Story Property
  • 1 Fireplace
  • New Windows
  • Blinds
  • Entrance Foyer
  • Formal Dining Room
  • Carpet
  • Partial Basement

Kitchen

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Parking

  • Attached Garage
  • Garage Door Opener

Outdoor Features

  • Deck

Location

  • Property is near public transit
  • Property is near schools
  • Property is near shops

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Baseboard Heating
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Gas Water Heater

Community Details

  • Park

Listing and Financial Details

  • Legal Lot and Block 114 / 107
  • Assessor Parcel Number 2209-01-107-00-0114-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,136

Year Built

Built in 1935

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architectural Style: Tudor
  • Property SubType: Single Family Residence
  • Levels: Two
  • Year Built: 1935
  • CurrentPrice: 1580000.00
  • MlsMajorChangeType: Sold
  • CurrentPrice_By_LivingArea: 572.46377
  • ListPrice_By_LivingArea: 543.47826
  • ListPrice_By_OriginalListPrice: 1.00000
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Cooktop, Dishwasher, Dryer, Humidifier, Microwave, Oven, Refrigerator, Washer, Gas Water Heater
  • Interior Amenities: Eat-in Kitchen, Entrance Foyer, Granite Counters, Pantry, Walk-In Closet(s), Formal Dining, Primary Bathroom
  • Fireplaces: 1
  • Flooring: Carpet
  • Full Bathrooms: 3
  • Basement: Partial
  • Total Bedrooms: 4
  • Living Area: 2760
  • Window Features: Blinds, New Windows
  • Basement YN: No
  • ResoLivingAreaSource: Other

Exterior Features

  • Construction Materials: Brick, Frame
  • Fencing: Partial
  • Pool Private: No
  • Spa: No
  • Patio and Porch Features: Deck

Garage/Parking

  • Parking Description: Attached, Garage Door Opener, Private

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas, Baseboard, Forced Air, Radiant
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Association Amenities: Park
  • Senior Community: No
  • Association: No

Schools

  • Middle School: Great Neck North Middle School

Lot Info

  • Lot Dimensions: 53x100
  • Lot Size Sq Ft: 5300
  • Lot Features: Sprinklers In Front, Near Public Transit, Near School, Near Shops
  • Parcel Number: 2209-01-107-00-0114-0
  • Property Attached: No
  • Additional Parcels: No

Rental Info

  • Lease Considered: No

Multi Family

  • Units Total: 1

Tax Info

  • Tax Annual Amount: 19135.97
  • Tax Block: 107
  • Tax Lot: 114

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 24, 2024
Closed on
Oct 30, 2024
Sold by
Adlow Rita L and Adlow Steven J
Bought by
Ding Yinan
Seller's Agent
Andrea Levine
Keller Williams Rty Gold Coast
Buyer's Agent
Andrea Levine
Keller Williams Rty Gold Coast
List Price
$1,500,000
Sold Price
$1,580,000
Premium/Discount to List
$80,000
5.33%
Views
52
Current Estimated Value
$1,634,976

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$54,976
Avg. Annual Appreciation
4.89%

Purchase Details

Closed on
Mar 15, 2019
Sold by
Adlow Steven J and Adlow Rita L
Bought by
Adlow 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
Ding Yinan $1,580,000 Libra Title Agency Llc
Ding Yinan $1,580,000 Libra Title Agency Llc
Ding Yinan $1,580,000 Libra Title Agency Llc
Adlow Trust -- None Available
Adlow Trust -- None Available
Adlow Trust -- None Available
Adlow Trust -- None Available
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/30/2024 10/30/24 Sold $1,580,000 0.0% $572 / Sq Ft
06/14/2024 06/14/24 Pending -- -- --
06/04/2024 06/04/24 Off Market $1,580,000 -- --
05/24/2024 05/24/24 For Sale $1,500,000 -- $543 / 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 $17,660 $936 $401 $535
2024 $4,776 $960 $411 $549
2023 $15,399 $1,028 $440 $588
2022 $13,812 $1,028 $440 $588
2021 $12,004 $1,021 $386 $635
2020 $12,004 $964 $963 $1
2019 $9,777 $1,033 $1,005 $28
2018 $9,880 $1,102 $0 $0
2017 $6,801 $1,171 $1,012 $159
2016 $10,240 $1,240 $965 $275
2015 $3,677 $1,309 $926 $383
2014 $3,677 $1,309 $926 $383
2013 $3,675 $1,378 $974 $404
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: L3554121

OneKey® MLS

APN: 2209-01-107-00-0114-0