249-17 147th Road is a newly constructed custom two family home that will captivate you from the moment you arrive with its warm & welcoming energy. This 26x51 built two family sits on a 42x97 lot tucked away on a beautiful, quiet, tree lined street of Rosedale. Featuring a wide private driveway, garage and a spacious yard to enjoy outdoor gatherings. Ideal for buyers looking for space, plus income generating rental property to assist with mortgage payments.
Configured as 3 bedroom 2 bath rental unit which has the ability to generate $4,000/month to assist with mortgage payments. The owners 3 bedroom 2 bath unit can easily be used as a garden-basement duplex to create additional living/recreational space.
Both units feature expansive sun drenched, modern open concept living/dining areas provide great space for entertaining. Jaw dropping chefs granite kitchens equipped with floor to ceiling custom cabinetry & adorned with a full fleet of state of the art stainless steel appliances. Spacious bedrooms equipped with ample closet space. Primary suite equipped with private en suite that boast spa-like finishes and a fully functional walk in closet. Fully tiled bathrooms adorned with state of the art wall & floor tiles.
Renovations include brand new select wood flooring, recessed lighting, central HVAC systems, LED lighting, designer wood panels, LED fireplaces. Brand new electrical, heating and plumbing systems throughout.
Prime Rosedale Location. Just off Huxley Street, 147th Avenue, 253 Street. Short blocks to schools, shopping centers, restaurants, cafes, Green Acres commons, JFK Airport, Airport hotels and many other vibrant neighborhood amenities.
Pending
$1,495,000
24917 147th Road, Rosedale, NY 11422
6beds
3,978sqft
Duplex, Multi Family
Built in 1945
-- sqft lot
$-- Zestimate®
$376/sqft
$-- HOA
What's special
Led fireplacesCentral hvac systemsRecessed lightingWide private drivewayLed lightingDesigner wood panels
- 53 days |
- 104 |
- 9 |
Likely to sell faster than
Zillow last checked: 8 hours ago
Listing updated: December 22, 2025 at 03:17pm
Listing by:
Keystone Realty USA Corp 631-261-2800,
Gabriel Kashi 347-419-5268,
Eric Rashtian 917-727-0527,
Keystone Realty USA Corp
Source: OneKey® MLS,MLS#: 943373
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 5
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Laundry: Washer/Dryer Hookup
Features
- First Floor Bedroom, First Floor Full Bath, Granite Counters, Recessed Lighting, Wired for Sound
- Basement: Finished,Full
Interior area
- Total structure area: 3,978
- Total interior livable area: 3,978 sqft
Property
Parking
- Total spaces: 1
- Parking features: Driveway, Garage, Private
- Garage spaces: 1
- Has uncovered spaces: Yes
Lot
- Size: 4,074 Square Feet
Details
- Parcel number: 136360064
- Special conditions: None
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex, Multi Family
Condition
- Year built: 1945
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Community & HOA
Location
- Region: Rosedale
Financial & listing details
- Price per square foot: $376/sqft
- Tax assessed value: $39,180
- Annual tax amount: $5,240
- Date on market: 12/11/2025
- Cumulative days on market: 54 days
- Listing agreement: Exclusive Right To Sell
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/22/2025 | Pending sale | $1,495,000$376/sqft |
Source: | ||
| 12/11/2025 | Listed for sale | $1,495,000+273.8%$376/sqft |
Source: | ||
| 3/17/2025 | Sold | $400,000$101/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $41,700 -2.4% |
| 2023 | -- | $42,720 +8.4% |
| 2022 | -- | $39,420 +11.7% |
Find assessor info on the county website
BuyAbility℠ payment
Estimated monthly payment
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
Neighborhood: Rosedale
Nearby schools
GreatSchools rating
- 4/10P.S. / M.S. 138 SunriseGrades: PK-8Distance: 0.3 mi
- 5/10Excelsior Preparatorty High SchoolGrades: 9-12Distance: 1.3 mi
- 4/10Collaborative Arts Middle SchoolGrades: 6-8Distance: 1.3 mi
- Loading





