Brand-new luxury all-brick detached two-family residence ideally located in the heart of Bayside, within top-rated School District 26. Situated on a prime, quiet block just steps from Bell Boulevard’s shops, dining, and cafés, and only minutes to the LIRR station with express service to Flushing Main Street and Midtown Manhattan.
This elegant home features solid all-brick construction with refined architectural details throughout. Each floor offers a spacious 3-bedroom, 2-bathroom layout, designed with open-concept living and dining areas for modern living.
The fully finished basement boasts 9.5-foot ceilings and a separate entrance, providing excellent flexibility for recreation, home office, or extended living space.
Luxury finishes include hardwood floors throughout, floor-to-ceiling windows that flood the home with natural light, and premium materials and contemporary design showcasing sophistication and prestige.
Enjoy a private landscaped backyard, perfect for outdoor relaxation and entertaining. Additional highlights include a detached garage and a wide private driveway.
Built with exceptional craftsmanship and attention to detail, this home seamlessly blends comfort, style, and long-term value—ideal for both end-users and investors.
37 days
|
1,279
|
51
|
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Sweet Key Realty Group Inc347-323-2443,
Qun D. Lin347-323-2443
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1014529
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 5
Full bathrooms: 5
Heating
Heat Pump
Cooling
Ductless
Features
First Floor Bedroom, Eat-in Kitchen, Natural Woodwork, Open Kitchen
Flooring: Hardwood
Doors: ENERGY STAR Qualified Doors
Windows: ENERGY STAR Qualified Windows, Floor to Ceiling Windows, Insulated Windows, New Windows
Basement: Finished,Full
Attic: Crawl
Interior area
Total structure area: 2,438
Total interior livable area: 2,438 sqft
Property
Parking
Total spaces: 4
Parking features: Detached, Driveway
Garage spaces: 1
Carport spaces: 3
Has uncovered spaces: Yes
Lot
Size: 3,500 Square Feet
Dimensions: 35 x 100
Details
Parcel number: 062400036
Special conditions: None
Construction
Type & style
Home type: MultiFamily
Property subtype: Triplex, Multi Family
Materials
Brick
Condition
Year built: 2025
Utilities & green energy
Sewer: Public Sewer
Water: Public
Utilities for property: Electricity Connected, Sewer Connected, Trash Collection Public, Water Connected
Community & HOA
Location
Region: Bayside
Financial & listing details
Price per square foot: $939/sqft
Annual tax amount: $4,055
Date on market: 6/16/2026
Cumulative days on market: 277 days
Listing agreement: Exclusive Right To Sell
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
6/16/2026
Listed for sale
$2,290,000$939/sqft
Source: OneKey® MLS as distributed by MLS GRID #1014529Report a problem
6/10/2026
Listing removed
$2,290,000$939/sqft
Source: OneKey® MLS as distributed by MLS GRID #945223Report a problem
12/20/2025
Listed for sale
$2,290,000$939/sqft
Source: OneKey® MLS as distributed by MLS GRID #945223Report a problem
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.