4647 204 St
Exceptional custom-built all-brick detached two-family residence in the prestigious Bayside School District 26. Built in 2005, this impressive four-level home sits on a rare 130’ × 41’ corner lot with three-sided street frontage, offering nearly 5,600 SF of living space. Hardwood flooring throughout, including the finished basement and attic. Expertly designed with a DOB-approved engineered foundation, exceptional natural light, and 6 full bathrooms. Ideal for luxury living, investment, or potential professional use (subject to approvals). Low annual taxes Conveniently located near shopping, parks, schools, bus lines, and just 15 minutes to Flushing Main Street.
Listing Information
Facts & Features
Location
Community Information
Architecture
Features & Amenities
Property Features
Square Footage
Tax & Financial Information
Schools
Ps 162 John Golden
Assigned school for this home
Middle School 158 Marie Curie
Civic School Of Bayside Hills (The)
Ps 177
Ps 130
Ps 203 Oakland Gardens
Ps 376
World Journalism Preparatory: A College Board School
School ratings are provided for informational purposes only and are subject to change. Attendance boundaries are for reference only — contact the school or district directly to verify enrollment eligibility.
Historical Data
Price History
| Date | Event | Price |
|---|---|---|
| 09/13/2026 | Price change | $2,180,000 |
| 08/24/2026 | Listed for sale | $2,448,800 |
Listed by Ding Yu · B Square Realty · 7189398388
Listing information provided exclusively for consumers' 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 deemed reliable but not guaranteed by the MLS. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, OneKey MLS. All rights reserved.
Last Updated: October 18, 2026 at 8:14 PM | Source: OneKey MLS | MLS#: 1042342
Start Your Real Estate Journey
Whether you have questions about this listing, want to schedule a showing, or just want to talk through your options, James Haydon is here to help. Reach out and expect a response within one business day.
How can I help?
James Haydon is here to help. Reach out and expect a response within one business day.
Thanks — James Haydon will be in touch shortly.
Make A Plan For Your Purchase
Know what you can afford before you start shopping — then run the numbers on any home you have in mind.
How much house can I afford?
- Principal & interest
- Property taxes
- Homeowner's insurance
- HOA dues
If your monthly savings are applied to the loan principal.
Enter your income, debts, and down payment to see how much home you may qualify for. Estimates only — not a lending decision.
Want to know more?
James Haydon is here to help. Reach out and expect a response within one business day.
✓ Thanks — James Haydon will be in touch shortly.