14027 247th St
Whether you're seeking a sophisticated primary residence with supplemental income or a valuable addition to your investment portfolio, this remarkable property offers the perfect blend of luxury, flexibility, and long-term value. This custom built brand new construction two family will captivate you from the moment you arrive with its warm & welcoming energy. Ideal for buyers looking for space, plus income generating rental property to assist with mortgage payments. Welcome to 140-27-247th Street! Sitting on a 50x100 lot on a beautiful picturesque block of Rosedale! Featuring a wide private driveway, garage, and tons of yard space to enjoy outdoor gatherings. Offering two 3 bedroom 2 bath units over a high ceiling full finished basement with both interior and exterior access. Both units enjoy modern, open concept living/dining areas which provide great space for entertaining. Beautiful chefs granite kitchens equipped with floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances and equipped with island for bar stool seating. Well proportioned bedrooms with ample closet space. The primary suite is your private escape. Featuring a private en suite with spa like finishes. Fully tiled bathrooms that boast state of the art wall & floor tiles. The high ceiling full finished basement can easily be used as a media den, guest quarters, additional recreational space or ADU. This exceptional two family presents a rare opportunity to own a piece of Rosedale while enjoying the space, privacy, and lifestyle the neighborhood has to offer. Conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Francis Lewis Blvd, Memphis Avenue, S Conduit, Belt Parkway. Short blocks to schools, Green Acres Commons, JFK Airport, restaurants, cafes, parks and many other vibrant neighborhood amenities. Do not miss your opportunity to own one of the last houses in the Rosedale market that checks all the boxes for modern day luxury, space, & style!
Listing Information
Open Houses
-
Sunday, November 110:00 AM – 11:00 AM
Facts & Features
Location
Community Information
Architecture
Features & Amenities
Property Features
Tax & Financial Information
Schools
Ps 181 Brookfield
Ps/Middle School 138 Sunrise
Ps 156 Laurelton
Valley Stream South High School
Forest Road School
Clearstream Avenue School
Ogden Elementary School
Ps 38 Rosedale
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 |
|---|---|---|
| 08/21/2026 | Price change | $1,555,000 |
| 07/17/2026 | Listed for sale | $1,595,000 |
Listed by Gabriel Kashi · Keystone Realty USA Corp · 6312612800
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 27, 2026 at 5:43 PM | Source: OneKey MLS | MLS#: 1027504

Similar Homes For Sale In Rosedale
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, Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
How can I help?
Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
Thanks — Jeromy Dunn-Portella 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?
Jeromy Dunn-Portella is here to help. Reach out and expect a response within one business day.
✓ Thanks — Jeromy Dunn-Portella will be in touch shortly.





