This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/23
$1,299,999
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/23
Property Description
Welcome to this brand-new, two-family home in the heart of Locust Manor - a rare find that perfectly blends space, style, and modern comfort. Built with a massive 20' x 60' footprint on an oversized 28' x 174' lot, this property gives you room to breathe both inside and out - including a backyard deep enough to create your own private oasis. Constructed with spray foam insulation, brick exterior, and central heating and cooling, every inch of this home was designed for long-term comfort and energy efficiency. Each apartment features king-sized bedrooms, double-door closets, and primary suites with real walk-in closets - no wasted space, just functional luxury. Downstairs, the 60-foot open basement has no center posts, a full bath, and a private entrance, offering endless potential - from entertainment space to extended family use or rental opportunities. This is modern construction done right - space, quality, and flexibility all in one.
Full Property Details
Full Property Details for 174-41 125th Ave
General
- Price: $1,299,999
- Taxes: $7,500
- Status: Active
- Type: Multi-Family
- Source: Long_Island
- MLS ID: 931907
- Updated: 1/5/2026
- Added to Site: 74 day(s) ago
Interior
- Interior Features: First Floor Bedroom
- Laundry Facilities: Yes
- Flooring: Hardwood
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 5
Bedrooms
- Total Bedrooms: 6
Other Rooms
- Laundry: Common Area
Parking
- Total Spaces: 25
- Parking Features: Driveway, Private
Location
- County: Queens
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Available, Electricity Connected, Natural Gas Connected, Phone Available, Sewer Connected, Water Connected
Structural Information
- Detached/Attached: Detached
- Construction: Brick, Vinyl Siding
- Basement: Yes
- Basement Desc.: Finished, Full Basement, Walk-Out Access
- Building Size: 3600
- Square Feet: 3,600
- Year Built: 2025
Lot Features
- Lot Size (Sq. Ft.): 4,872
- Lot Dimensions: 28 x 174
Financial Considerations
- Tax Amount: $7,500
Disclosures and Reports
- Special Conditions: None
Listed by Exclusive Homes Group Inc
Get Pre-Approved Today
Schools
Schools serving 174-41 125th Ave
School District:New York City Geographic School District 28
| Name | Grades | Distance |
|---|---|---|
The Jermaine L. Green STEM Institute of Queens 126-10 Bedell St, Queens, NY 11434 | K-5 | 0.4 mi |
Catherine And Count Basie Middle School 72 133-25 Guy R Brewer Blvd, Queens, NY 11434 | 6-8 | 0.7 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 174-41 125th Ave
Date
Details
Price
Change
Source
1/05/2026
Price Reduced
$1,299,999
-3.35%
MLS
11/04/2025
Listed
$1,345,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 174-41 125th Ave
174-41 125 Avenue, Rochdale, NY 11434 (MLS# 931907) is a Multi-Family property with 2 units containing 6 bedrooms and 5 full bathrooms. 174-41 125 Avenue is currently listed for $1,299,999 and was received on November 04, 2025. Want to learn more about 174-41 125 Avenue? Do you have questions about finding other Multi-Family real estate for sale in Rochdale? You can browse all Rochdale real estate or contact a Coldwell Banker agent to request more information.

