Introducing a newly constructed multi-family residence that redefines contemporary living. This exceptional property boasts cutting-edge design and state-of-the-art features, making it a standout in the market. Each unit offers open floor plans, high ceilings, and large windows, creating airy, light-filled spaces. Premium materials and modern finishes are evident throughout, from gourmet kitchens to RAIN STYLE -inspired bathrooms. With energy-efficient systems and smart home technology, residents enjoy both comfort and sustainability. The beautifully landscaped communal areas and top-tier amenities, setting a new standard for multi-family residences.
Sold for $1,375,000
$1,375,000
238-23 149th Avenue, Rosedale, NY 11422
7beds
--sqft
Duplex, Multi Family
Built in 2022
-- sqft lot
$1,434,300 Zestimate®
$--/sqft
$3,787 Estimated rent
Home value
$1,434,300
$1.29M - $1.61M
$3,787/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$3,787/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$3,787/mo
Rent Zestimate®
Refinance and save
$8,147/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$8,147/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: November 15, 2024 at 11:22pm
Listed by:
Arshdeep Singh 516-946-6342,
Omni Realty Corp 718-441-7000,
Saad Murtaza 718-441-7000,
Omni Realty Corp
Bought with:
Erika A. Fernandez, 10401349946
Gold Coast Real Estate Group
Source: OneKey® MLS,MLS#: L3568909
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 5
- Full bathrooms: 5
Primary bedroom
- Description: 3 Bedroom 2 Full Baths
- Level: First
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Dryer, Refrigerator, Washer
Features
- Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Master Downstairs, Marble Counters
- Flooring: Hardwood
- Basement: Walk-Out Access,Finished,Full
- Attic: Pull Stairs
Property
Parking
- Total spaces: 6
- Parking features: Detached, Private
Features
- Levels: Two
- Patio & porch: Porch
- Exterior features: Mailbox
Lot
- Size: 4,000 sqft
- Dimensions: 40 x 100
- Features: Near Public Transit, Near School, Near Shops
Details
- Parcel number: 137470076
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Post Modern
- Property subtype: Duplex, Multi Family
Materials
- Brick
Condition
- New Construction
- New construction: Yes
- Year built: 2022
Utilities & green energy
- Gas: Separate Gas Meters: 3
- Water: Public
- Utilities for property: Trash Collection Public
Community & neighborhood
Location
- Region: Rosedale
Other
Other facts
- Listing agreement: Exclusive Right To Lease
Price history
| Date | Event | Price |
|---|---|---|
| 11/15/2024 | Sold | $1,375,000-5.2% |
Source:  OneKey® MLS #L3568909 Report a problem | ||
| 8/29/2024 | Pending sale | $1,450,000 |
Source: OneKey® MLS #3568909 Report a problem | ||
| 7/29/2024 | Listed for sale | $1,450,000+241.2% |
Source: OneKey® MLS #3568909 Report a problem | ||
| 3/28/2018 | Sold | $425,000-15% |
Source: OneKey® MLS #L2989039 Report a problem | ||
| 2/5/2018 | Price change | $499,999-4.8% |
Source: RE/MAX Family Matters Realty #2989039 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $58,620 -5.6% |
| 2023 | -- | $62,100 +20.1% |
| 2022 | -- | $51,720 +5.8% |
Find assessor info on the county website
Neighborhood: Brookville
Nearby schools
GreatSchools rating
- 8/10Ps 181 BrookfieldGrades: PK-5Distance: 0.4 mi
- 4/10Collaborative Arts Middle SchoolGrades: 6-8Distance: 1.1 mi
- 5/10Excelsior Preparatorty High SchoolGrades: 9-12Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Ps 36 St Albans School
- High: Cambria Heights Academy
Source: OneKey® MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- New York
- Queens County
- New York
- 11422
- Queens
- Brookville
- 238-23 149th Avenue