$899,000
PENDING $50K PRICE DROP

Estimated payment $5,689/month

Total Views 4,787
3 Beds
3 Baths
-- Sq Ft
-- Price per Sq Ft

Highlights

  • Newly Remodeled
  • Wood Flooring
  • Terrace
  • Rooftop Deck
  • High Ceiling
  • Children's Playroom

About This Home

Property Features:

Completely Detached Single Family

Brand New, Fully Renovated Luxury Townhouse

Spacious 3 Bedrooms / 3 Full Baths

Large Lot with Fenced Backyard

Shared Driveway for Convenient Parking

Tons of Sunlight & Bright Rooms

Custom Kitchen Cabinetry with Quartz Countertops and Island

Brand New Central A/C and Heating System

Fully Finished Tiled Basement with Separate Entrance and Full Bath

Laundry Hookups in Basement

New Large Andersen Windows

White Oak Hardwood Flooring Throughout

Built in Camera Security System

Wired Ring Doorbell

Indoor and Outdoor Bluetooth Speakers

Wi-Fi Extenders Wired Throughout

Enormous Primary Bedroom Penthouse Leading out to Private Roofdeck Terrace

New Stainless Steel Appliances

New Brick & Stucco Facade

Gorgeous Full Tile Baths

Beautiful Recessed Lighting Throughout

Brand New Roof & Water Heaters

Prime Middle Village Location

Close to Many Supermarkets and Shops!

This stunning, fully reimagined luxury duplex single-family home in the prime Middle Village area of Queens offers the perfect combination of elegance, functionality, and cutting-edge technology. The completely detached property features a sleek and modern brick and stucco faade, enhancing its curb appeal. Step inside and be greeted by a spacious interior filled with natural light from the large Andersen windows.

The enormous penthouse primary bedroom upstairs is a true retreat, complete with an ensuite primary bath that boasts double vanity sinks, perfect for added comfort and style. This luxurious bedroom leads out to a gorgeous private roof deck terrace. Additionally, Wi-Fi extenders are installed throughout the house to ensure seamless internet connectivity in every room. This home is also equipped with smart home features, including a built-in Ring doorbell and a wired camera system for enhanced security and convenience.

The custom-built kitchen features sleek quartz countertops, an island, and brand new stainless steel appliances, while the rest of the home is outfitted with beautiful white oak hardwood flooring and recessed lighting.

Additional highlights include a fully finished basement with a separate entrance and a full bath, providing extra space for guests or family. Enjoy the convenience of a long shared driveway and a huge backyard, perfect for gardening or outdoor activities. With a brand new roof, water heaters, and central A/C and heating system, this home is designed for modern comfort.

Located just minutes from bus transportation, supermarkets, shops, schools, parks and restaurants, this prime property offers exceptional convenience. Don't miss outthis unique, smart home won't last long!

**Pictures are virtually staged.

Listing Agent

Aaron Hillel

Hillel Realty Group LLC License #10401215448 Listed on: 05/29/2025

Property Details

Home Type

  • Multi-Family

Year Built

  • Built in 1900 | Newly Remodeled

Lot Details

  • Lot Dimensions are 20 x 90
  • Garden
  • Property is in excellent condition

Home Design

  • Duplex

Interior Spaces

  • High Ceiling
  • Storage
  • Laundry in unit
  • Wood Flooring

Kitchen

  • Eat-In Kitchen
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Full Bathrooms

Outdoor Features

  • Balcony
  • Courtyard
  • Patio
  • Terrace
  • Outdoor Storage

Utilities

  • No Cooling
  • No Heating

Listing and Financial Details

  • Property Available on 9/8/25

Community Details

Overview

  • Ridgewood Subdivision

Amenities

  • Rooftop Deck
  • Community Garden
  • Courtyard
  • Children's Playroom
  • Laundry Facilities
  • Bike Room
  • Community Storage Space

Property Details

Home Type

Multi-Family

Year Built

Built in 1900 | Newly Remodeled

Lot Details

0

Listing Details

  • Property SubType: Duplex
  • Property Type: Residential
  • Neighborhood: Ridgewood
  • Structure Type: Duplex, Townhouse, Triplex
  • Special Features: NewHome
  • Property Sub Type: MultiFamily
  • Stories: 0

Interior Features

  • Interior Features: Eat-in Kitchen, High Ceilings, Storage
  • Appliances: Dishwasher, Stainless Steel Appliance(s)
  • Flooring: Hardwood
  • Living Area Units: Square Feet
  • Rooms (Total): 5

Beds/Baths

  • Full Bathrooms: 3
  • Bathrooms Integer: 3
  • Bedrooms: 3

Exterior Features

  • View: No
  • Exterior Features: Building Storage, Building Courtyard, Building Garden, Balcony, Building Roof Deck, Building Balcony, Courtyard, Garden, Private Outdoor Space Under 60 Sqft, Storage
  • Patio/Porch Features: Patio, Terrace, Balcony, Rooftop
  • Property Condition: Excellent

Garage/Parking

  • Garage: No

Utilities

  • Laundry Features: Building Inside, Common Area, In Unit
  • Green Building Features: Bike Storage, Common Playroom, Storage
  • Cooling: None
  • Cooling: No
  • Heating: None
  • Heating: No

Condo/Co-op/Association

  • Common Charge/Maintenance Fee Frequency: Monthly
  • Common Interest: None

Lot Info

  • Lot Size Units: Square Feet
  • Lot Size Dimensions: 20 x 90

Building Info

  • New Construction: Yes
  • Year Built: 1900

Rental Info

  • Furnished: Unfurnished
  • Available Date: 2025-09-08

Tax Info

  • Tax Block: 00000
  • Tax Lot: 0000

Multi Family

  • Building Area Units: Square Feet

Map

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

Property History

Date Event Price Change Sq Ft Price
07/22/2025 07/22/25 Pending -- -- --
06/16/2025 06/16/25 Price Changed $899,000 -5.3% --
05/29/2025 05/29/25 For Sale $949,000 -- --
Source: Real Estate Board of New York (REBNY)

Source: Real Estate Board of New York (REBNY)

MLS Number: RLS20027253

Real Estate Board of New York (REBNY)