NOT LISTED FOR SALE

175-40 Underhill Ave Fresh Meadows, NY 11365

Auburndale Neighborhood

Estimated Value: $1,278,343

3 Beds
3.5 Baths
1,888 Sq Ft
$677/Sq Ft Est. Value

Sale Details

Date Sold: August 2, 2024

Last sale price $1,200,000 $636 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $8,026 / mo

59 Days on Market

Highlights

  • Colonial Architecture
  • Property is near public transit
  • 1 Car Detached Garage
  • P.S. 107 Thomas A Dooley Rated A-
  • Corner Lot
  • Park

About This Home

As of August 2024

Bright, modern and spacious side hall colonial that was expanded in 2004. Interiors include recessed lighting, central AC, large living room, open kitchen, master bedroom with ensuite bath and a finished basement with separate outside entrance. Great location right across from Peck Park. Near the Q31 bus and Utopia Pkwy.

Last Agent to Sell the Property

Lucy Lu

Landmark International R E LLC Brokerage Phone: 718-898-8300 License #10491208898 Listed on: 03/25/2024

Last Buyer's Agent

Lucy Lu

Landmark International R E LLC Brokerage Phone: 718-898-8300 License #10491208898 Listed on: 03/25/2024

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,322

Year Built

  • Built in 1940 | Remodeled in 2004

Lot Details

  • 3,900 Sq Ft Lot
  • Lot Dimensions are 39x100
  • Corner Lot

Parking

  • 1 Car Detached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Frame Construction

Interior Spaces

  • 1,888 Sq Ft Home
  • Basement Fills Entire Space Under The House

Bedrooms and Bathrooms

  • 3 Bedrooms

Location

  • Property is near public transit

Schools

  • JHS 216 George J Ryan Middle School
  • Francis Lewis High School

Utilities

  • Central Air
  • Hot Water Heating System
  • Heating System Uses Natural Gas

Community Details

  • Park

Listing and Financial Details

  • Legal Lot and Block 36 / 5590
  • Assessor Parcel Number 05590-0036

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,322

Year Built

Built in 1940 | Remodeled in 2004

Lot Details

3,900 Sq Ft Lot

Parking

1

Listing Details

  • Property Type: Residential
  • Architectural Style: Colonial
  • Property SubType: Single Family Residence
  • Property Condition: Excellent
  • Year Built: 1940
  • New Construction: No
  • Year Built Effective: 2004
  • Attribution Contact: 718-898-8300
  • BuildingSize: 22 x 38
  • Special Features: None
  • Property Sub Type: Detached
  • Year Renovated: 2004

Interior Features

  • Living Area Units: Square Feet
  • Common Walls: No Common Walls
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Full
  • Total Bedrooms: 3
  • Living Area: 1888
  • AtticDescription: Pull Stairs
  • SquareFootage: 1888.00
  • SquareFootageSource: Other
  • NumberOfKitchens: 1

Exterior Features

  • Construction Materials: Frame, Brick
  • FloodZoneReportYN: 0

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Natural Gas, Hot Water
  • Sewer: Sewer
  • Water Source: Public
  • Hot Water: Gas Stand Alone

Association/Amenities

  • Community Features: Park

Condo/Co-op/Association

  • Senior Community: No

Schools

  • Middle School: Jhs 216 George J Ryan

Lot Info

  • Lot Size Acres: 0.09
  • Lot Dimensions: 39x100
  • Lot Size Sq Ft: 3900
  • Lot Size Units: Acres
  • Lot Features: Corner Lot, Near Public Transit
  • Parcel Number: 05590-0036
  • Property Attached: No
  • ResoLotSizeUnits: Acres

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 10322
  • Tax Block: 5590
  • Tax Lot: 36
  • Tax Map Number: 05590-0036

MLS Schools

  • High School: Francis Lewis High School
  • Middle School District: Queens 25

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 25, 2024
Closed on
Aug 1, 2024
Sold by
Benetti Luigi and Gorman Elizabeth
Bought by
Seller's Agent
Lucy Lu
Landmark International R E LLC
Buyer's Agent
Lucy Lu
Landmark International R E LLC
List Price
$1,350,000
Sold Price
$1,200,000
Premium/Discount to List
-$150,000
-11.11%
Views
52
Current Estimated Value
$1,278,343

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$78,343
Avg. Annual Appreciation
3.03%
Original Mortgage
$200,000
Outstanding Balance
$195,750
Interest Rate
6.95%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$1,082,593

Purchase Details

Closed on
Aug 7, 2008
Sold by
Costello Bernard P and Costello Eileen A
Bought by
Benetti Luigi and Gorman Elizabeth

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.4%

Purchase Details

Closed on
May 18, 2000
Sold by
Deluna Maria Olha and Deluna Juan Manuel
Bought by
Costello Eileen A and Costello Bernard P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$256,500
Interest Rate
8.14%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Sep 29, 1997
Sold by
Ferreri Pasquale L and Ferreri Josephine
Bought by
Deluna Juan Manuel and Deluna Maria Olha
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Auburndale, NY

  • King Hong Chin Real Estate Agent - Keller Williams Rlty Landmark

    King Hong Chin

    Keller Williams Rlty Landmark

    (844) 708-2647

    44 Total Sales

    3 in Auburndale

    $990K - $1.7M Price Range

    King Hong Chin
     Section Image
  • Titan Ren Real Estate Agent - Century Titan Group Inc

    Titan Ren

    Century Titan Group Inc

    (866) 471-9429

    14 Total Sales

    1 in Auburndale

    $2,060,000 Price

    Titan Ren
     Section Image
  • Vincent Koo Real Estate Agent - EXP Realty

    Vincent Koo

    EXP Realty

    (929) 552-9370

    94 Total Sales

    1 in Auburndale

    $1,120,000 Price

    Vincent Koo
     Section Image
  • Jessica Akde Elmazi Real Estate Agent - Compass Greater NY LLC

    Jessica Akde Elmazi

    Compass Greater NY LLC

    (888) 904-8014

    240 Total Sales

    2 in Auburndale

    $878K - $1.2M Price Range

    Jessica Akde Elmazi
     Section Image
  • Jagmeet Bedi Real Estate Agent - Compass

    Jagmeet Bedi

    Compass

    (855) 934-0730

    111 Total Sales

    1 in Auburndale

    $1,100,000 Price

    Jagmeet Bedi
     Section Image
  • Linda Faraldo Real Estate Agent - Daniel Gale Sothebys Intl Rlty

    Linda Faraldo

    Daniel Gale Sothebys Intl Rlty

    (516) 518-6918

    39 Total Sales

    1 in Auburndale

    $960,000 Price

    Linda Faraldo
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$1,200,000 --
Benetti Luigi $850,000 --
Costello Eileen A $270,000 Commonwealth Land Title Ins
Deluna Juan Manuel $198,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open -- $200,000
Previous Owner Benetti Luigi $2,747
Previous Owner Benetti Luigi $417,000
Previous Owner Costello Bernard P $65,000
Previous Owner Costello Bernard P $250,000
Closed Costello Bernard P $5,276
Closed Costello Eileen A $256,500
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/02/2024 08/02/24 Sold $1,200,000 -6.3% $636 / Sq Ft
05/24/2024 05/24/24 Pending -- -- --
04/30/2024 04/30/24 Price Changed $1,280,000 -5.2% $678 / Sq Ft
03/25/2024 03/25/24 For Sale $1,350,000 -- $715 / Sq Ft
Source: OneKey® MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $11,271 $58,445 $15,698 $42,747
2025 $10,634 $56,118 $14,450 $41,668
2024 $10,634 $52,943 $13,890 $39,053
2023 $10,322 $51,390 $14,249 $37,141
2022 $9,806 $65,760 $21,660 $44,100
2021 $10,250 $68,220 $21,660 $46,560
2020 $9,899 $65,040 $21,660 $43,380
2019 $9,229 $64,500 $21,660 $42,840
2018 $8,730 $42,825 $16,713 $26,112
2017 $8,345 $40,935 $16,257 $24,678
2016 $8,114 $40,935 $16,257 $24,678
2015 $4,658 $38,971 $18,004 $20,967
2014 $4,658 $36,766 $20,196 $16,570
Source: Public Records

Agents Affiliated with this Home

  • LL

    Seller's Agent in 2024

    Lucy Lu

    Landmark International R E LLC

    Section Image

  • YC

    Buyer Co-Listing Agent in 2024

    Yanmei Cao

    Landmark International R E LLC

    (718) 898-8300

    6 in this area

    27 Total Sales

    Yanmei Cao
    Section Image
See All Agents

Map

Source: OneKey® MLS

MLS Number: KEY3540093

OneKey® MLS

APN: 05590-0036

New York Queens County New York 11365 Auburndale

175-40 Underhill Ave, New York, 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.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. 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 2026 OneKey® MLS. All rights reserved.
Based on information submitted to the MLS GRID
Listings courtesy of OneKey® MLS as distributed by MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.