NOT LISTED FOR SALE

Estimated Value: $1,878,574 - $2,108,000

4 Beds
5.5 Baths
3,800 Sq Ft
$525/Sq Ft Est. Value

Last Sold December 01, 2021

Last sale price $1,800,000 $474 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $11,560/month

8 Days on Market

Highlights

  • New Construction
  • Sauna
  • 1 Fireplace
  • Herricks High School Rated A+
  • Wood Flooring
  • Granite Countertops

About This Home

As of December 2021

42 Queens Ln, Manhasset Hills is for Sale and it's going to take your breath away! This Absolutely Stunning Custom-Built Home has been crafted w/amazing attention to details & meticulously tailored w/the highest quality material & millwork. This Magnificent Home boast 3,800 sqft of living, 4 Beds (2 ensuite) 5.5 Baths Chef's Kitchen w/Island & Pantry, Dining Area & Living Rm, Family Rm, Entertainer's Grand Living/Game Rm, a sunroom, and a heated attached 2 car garage. The luxurious interior features Porcelain Italian Heated Floors, St. Martin Cabinetry, Quartz Kitchen Counter Tops, Thermador & Miele appliances, Minka Lavery Chandelier & Light Fixtures, Original Michelangelo ceiling medallion, Italian Marbled & Porcelain Baths, Canadian Solid Mahogany throughout, custom molding & wainscoting, cedar closets in every bedroom and much more. This home was built in its entirety w/Black Platinum Bricks and is nestled in a 10,080 sqft lot in one of the most sought-after streets in Mahasset Hil

Last Agent to Sell the Property

James Chung

Keller Williams Rlty Landmark License #10301214776 Listed on: 09/25/2021

Keller Williams Rlty Landmark

Last Buyer's Agent

James Chung

Keller Williams Rlty Landmark License #10301214776 Listed on: 09/25/2021

Keller Williams Rlty Landmark

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $22,847

Year Built

  • Built in 2019 | New Construction

Lot Details

  • 10,080 Sq Ft Lot
  • Lot Dimensions are 105x96
  • Sprinkler System

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

  • Split Level Home
  • Brick Exterior Construction

Interior Spaces

  • 3,800 Sq Ft Home
  • 3-Story Property
  • Wet Bar
  • 1 Fireplace
  • Entrance Foyer
  • Formal Dining Room
  • Home Office
  • Storage
  • Sauna
  • Wood Flooring
  • Unfinished Attic

Kitchen

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Powder Room

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Home Security System
  • Fire Sprinkler System

Outdoor Features

  • Balcony
  • Patio

Schools

  • Searingtown Elementary School
  • Herricks Middle School
  • Herricks High School

Utilities

  • ENERGY STAR Qualified Air Conditioning
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Natural Gas Water Heater

Community Details

  • Park

Listing and Financial Details

  • Legal Lot and Block 2 / 264
  • Assessor Parcel Number 2289-08-264-00-0002-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$22,847

Year Built

Built in 2019 | New Construction

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Split Level
  • Property SubType: Single Family Residence
  • Property Condition: Diamond
  • Levels: Three Or More
  • Year Built: 2019
  • New Construction: Yes
  • Attribution Contact: 718-475-2700
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Microwave, Oven
  • Interior Amenities: 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, Sauna, Storage, Walk-In Closet(s), Wet Bar
  • Living Area Units: Square Feet
  • Fireplaces: 1
  • Attic Description: Unfinished
  • Flooring: Hardwood
  • Common Walls: No Common Walls
  • Total Bathrooms: 6
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Basement: Finished, Full, Walk-Out Access
  • Inclusions: Alarm System, Basketball Hoop, Ceiling Fan, Chandelier(s), Dishwasher, Light Fixtures, Microwave, Wall Oven
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Living Area: 3800.00
  • Kitchens: 1
  • Square Footage: 3800.00

Exterior Features

  • Construction Materials: Brick
  • Flood Zone Date: 2021-09-27
  • Flood Zone Report: Yes
  • Exterior Features: Balcony, Sprinkler Lawn System
  • Patio and Porch Features: Patio

Garage/Parking

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

Utilities

  • Cooling: Central Air, ENERGY STAR Qualified Equipment
  • Cooling: Yes
  • Heating: Electric, Natural Gas, Forced Air, Radiant
  • Hot Water: Gas Stand Alone
  • Security: Security System, Fire Sprinkler System
  • Sewer: Sewer
  • Water Source: Public

Association/Amenities

  • Community Features: Park

Condo/Co-op/Association

  • Senior Community: No

Schools

  • Elementary School: Searingtown School
  • Middle School: Herricks Middle School
  • High School: Herricks High School
  • Middle School: Herricks Middle School

Lot Info

  • Lot Size Acres: 0.2300
  • Lot Size Area: 0.2300
  • Lot Dimensions: 105x96
  • Lot Size Sq Ft: 10080.00
  • Lot Size Units: Acres
  • Parcel Number: 2289-08-264-00-0002-0
  • Property Attached: No

Rental Info

  • Lease Considered: No

Tax Info

  • Close Date: 2021-12-01
  • Tax Annual Amount: 22847.00
  • Tax Block: 264
  • Tax Lot: 2
  • Tax Map Number: 2289-08-264-00-0002-0

MLS Schools

  • Elementary School: Searingtown School
  • High School: Herricks High School
  • Middle School District: Herricks

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 25, 2021
Closed on
Nov 29, 2021
Sold by
Akula Lavania
Bought by
Aayan In Property Holdings Llc
Seller's Agent
James Chung
Keller Williams Rlty Landmark
Buyer's Agent
James Chung
Keller Williams Rlty Landmark
List Price
$1,800,000
Sold Price
$1,800,000
Current Estimated Value
$1,999,689

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$199,689
Avg. Annual Appreciation
1.31%
Original Mortgage
$1,000,000
Outstanding Balance
$923,507
Interest Rate
3.11%
Mortgage Type
Commercial
Estimated Equity
$965,576

Purchase Details

Listed on
Oct 6, 2012
Closed on
Dec 10, 2012
Sold by
Qu Keliang and Wu Guo Qin
Bought by
Akula Lavania
Seller's Agent
Kenny Lin
Century Homes Realty Group LLC
Buyer's Agent
Lalita Mansukhani
LAFFEY REAL ESTATE
List Price
$699,000
Sold Price
$630,000
Premium/Discount to List
-$69,000
-9.87%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.40%

Purchase Details

Closed on
Jul 15, 2004
Sold by
Wan Alice
Bought by
Qu Keliang

Purchase Details

Closed on
Aug 11, 1995
Sold by
Wan Anthony and Wan Alice
Bought by
Wan Alice

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$5,805
Interest Rate
7.61%
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
Aayan In Property Holdings Llc $1,800,000 Stewart Title
Aayan In Property Holdings Llc $1,800,000 Stewart Title
Akula Lavania $630,000 Chicago Title Insurance Comp
Akula Lavania $630,000 Chicago Title Insurance Comp
Qu Keliang $772,000 --
Qu Keliang $772,000 --
Wan Alice -- --
Wan Alice -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Aayan In Property Holdings Llc $1,000,000
Previous Owner Wan Alice $5,805
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/01/2021 12/01/21 Sold $1,800,000 0.0% $474 / Sq Ft
10/04/2021 10/04/21 Pending -- -- --
09/25/2021 09/25/21 For Sale $1,800,000 +185.7% $474 / Sq Ft
12/10/2012 12/10/12 Sold $630,000 -9.9% $330 / Sq Ft
10/31/2012 10/31/12 Pending -- -- --
10/06/2012 10/06/12 For Sale $699,000 -- $366 / 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 $7,330 $1,002 $493 $509
2024 $7,330 $1,034 $509 $525
2023 $21,476 $1,034 $509 $525
2022 $21,476 $1,034 $509 $525
2021 $21,775 $903 $497 $406
2020 $22,978 $1,523 $1,273 $250
2019 $20,376 $1,523 $1,273 $250
2018 $20,376 $1,523 $0 $0
2017 $13,230 $1,523 $1,273 $250
2016 $19,343 $1,523 $1,273 $250
2015 $5,824 $1,523 $1,273 $250
2014 $5,824 $1,523 $1,273 $250
2013 $5,524 $1,523 $1,273 $250
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: OneKey® MLS

MLS Number: KEY3348123

OneKey® MLS

APN: 2289-08-264-00-0002-0