NOT LISTED FOR SALE

42-40 247th St Little Neck, NY 11363

Douglaston Neighborhood

Estimated Value: $1,200,000 - $1,524,000

8 Beds
3 Baths
2,625 Sq Ft
$527/Sq Ft Est. Value

Last Sold August 21, 2023

Last sale price $1,180,000 $450 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $8,186/month

70 Days on Market

Highlights

  • Colonial Architecture
  • Property is near public transit
  • Main Floor Primary Bedroom
  • P.S. 94 - David D. Porter Rated A
  • Wood Flooring
  • 2 Fireplaces

About This Home

As of August 2023

Large Multi Family in quiet residential area bordering parkland. Perfect for investment or extended family. Little Neck offers its residents the best school district, SD26, transportation to city via LIRR, Q12 bus to Flushing, 10 minute ride to bridges, lower property taxes and convenience to shopping. Sold as is

Last Agent to Sell the Property

Cathy Moran

Arash Real Estate & Mgmt License #30MO0768907 Listed on: 03/13/2023

Last Buyer's Agent

Cathy Moran

Arash Real Estate & Mgmt License #30MO0768907 Listed on: 03/13/2023

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $9,700

Year Built

  • Built in 1940

Lot Details

  • 4,600 Sq Ft Lot
  • Lot Dimensions are 40x115
  • No Common Walls
  • East Facing Home
  • Level Lot

Parking

  • 2 Car Detached Garage
  • Driveway

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Exterior

Interior Spaces

  • 2,625 Sq Ft Home
  • 3-Story Property
  • 2 Fireplaces
  • Entrance Foyer
  • Formal Dining Room
  • Wood Flooring
  • Eat-In Kitchen
  • Finished Basement

Bedrooms and Bathrooms

  • 8 Bedrooms
  • Primary Bedroom on Main
  • 3 Full Bathrooms

Location

  • Property is near public transit

Schools

  • Ps 94 David D Porter Elementary School
  • JHS 67 Louis Pasteur Middle School
  • Benjamin N Cardozo High School

Utilities

  • Cooling System Mounted In Outer Wall Opening
  • Hot Water Heating System
  • Heating System Uses Oil

Listing and Financial Details

  • Assessor Parcel Number 08116-0106

Community Details

Overview

  • 2 Units

Recreation

  • Park

Building Details

  • 3 Separate Electric Meters
  • 3 Separate Gas Meters

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$9,700

Year Built

Built in 1940

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential Income
  • Architectural Style: Colonial
  • Property SubType: Multi Family
  • Levels: Three Or More
  • Year Built: 1940
  • New Construction: No
  • BuildingSize: 25x42
  • Special Features: None
  • Property Sub Type: MultiFamily

Interior Features

  • Interior Amenities: Master Downstairs, Eat-in Kitchen, Formal Dining, Entrance Foyer
  • Living Area Units: Square Feet
  • Fireplaces: 2
  • Flooring: Hardwood
  • Common Walls: No Common Walls
  • Full Bathrooms: 3
  • Basement: Finished
  • Total Bedrooms: 8
  • Fireplace: Yes
  • Living Area: 2625
  • SquareFootage: 2625.00
  • NumberOfKitchens: 2

Exterior Features

  • Direction Faces: East
  • Construction Materials: Block, Brick
  • FloodZoneReportYN: 1

Garage/Parking

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

Utilities

  • Cooling: Wall Unit(s)
  • Cooling: Yes
  • Heating: Oil, Hot Water
  • Sewer: Public Sewer
  • Water Source: Public
  • GarbageRemoval: Public
  • Hot Water: Fuel Oil Stand Alone

Association/Amenities

  • Community Features: Park, Near Public Transportation

Condo/Co-op/Association

  • Senior Community: No

Schools

  • Middle School: Jhs 67 Louis Pasteur

Lot Info

  • Lot Size Acres: 0.11
  • Lot Dimensions: 40x115
  • Lot Size Sq Ft: 4600
  • Lot Size Units: Acres
  • Lot Features: Level, Near Public Transit
  • Parcel Number: 08116-0106
  • Property Attached: No
  • ResoLotSizeUnits: Acres
  • FloodZoneDate: 2023-03-14

Rental Info

  • Lease Considered: No
  • Available Date: 2023-07-31

Multi Family

  • Units Total: 2
  • Separate Electric Meters: 3
  • Separate Gas Meters: 3

Tax Info

  • Tax Annual Amount: 9700
  • Tax Map Number: 08116-0106
  • IncludedInTaxes: Sewer,Trash

MLS Schools

  • Elementary School: Ps 94 David D Porter
  • High School: Benjamin N Cardozo High School
  • Middle School District: Queens 26

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 13, 2023
Closed on
Aug 21, 2023
Sold by
Ambery Frances and Ambery James
Bought by
Hu Haiguang and Wang Huimei
Seller's Agent
Cathy Moran
Arash Real Estate & Mgmt
Buyer's Agent
Cathy Moran
Arash Real Estate & Mgmt
List Price
$1,495,000
Sold Price
$1,180,000
Premium/Discount to List
-$315,000
-21.07%
Views
117
Current Estimated Value
$1,382,590

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$202,590
Avg. Annual Appreciation
7.50%
Original Mortgage
$590,000
Outstanding Balance
$576,927
Interest Rate
6.96%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$805,663
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
Hu Haiguang $1,180,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hu Haiguang $590,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/21/2023 08/21/23 Sold $1,180,000 -6.2% $450 / Sq Ft
05/22/2023 05/22/23 Pending -- -- --
04/27/2023 04/27/23 Price Changed $1,258,000 -15.9% $479 / Sq Ft
03/13/2023 03/13/23 For Sale $1,495,000 -- $570 / 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 $10,951 $57,792 $13,102 $44,690
2024 $10,951 $54,521 $12,532 $41,989
2023 $10,050 $51,437 $11,084 $40,353
2022 $9,981 $84,600 $19,860 $64,740
2021 $10,381 $72,300 $19,860 $52,440
2020 $9,898 $79,440 $19,860 $59,580
2019 $9,211 $68,040 $19,860 $48,180
2018 $8,440 $42,864 $13,951 $28,913
2017 $8,438 $42,864 $14,034 $28,830
2016 $8,142 $42,864 $14,034 $28,830
2015 $4,657 $40,133 $19,407 $20,726
2014 $4,657 $37,862 $15,568 $22,294
Source: Public Records

Agents Affiliated with this Home

  • Cathy Moran

    Seller's Agent in 2023

    Cathy Moran

    Arash Real Estate & Mgmt

    (917) 957-4619

    17 in this area

    31 Total Sales

    Cathy Moran
    Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: KEY3464089

OneKey® MLS

APN: 08116-0106

New York Queens County Little Neck 11363 Douglaston

42-40 247th St, Little Neck, NY

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

OneKey® MLS The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Copyright 2025 OneKey® MLS. All rights reserved.

Nearby Homes