174-41 125 Avenue, Rochdale, NY, 11434 | $1,345,000

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.

Features

  • Bedrooms: 6
  • Baths: 5 full
  • Laundry: Common Area
  • Style: Duplex
  • Year Built: 2025
  • Heating: Forced Air
  • Cooling: Central Air
  • Basement: Finished, Full, Walk-Out Access
  • Est. Taxes: $7,500
  • MLS#: 931907
  • Days on Market: 30 days
  • Website: https://www.raveis.com
    /eprop/931907/17441125avenue_rochdale_ny?source=qrflyer
Listing information has been assembled from various sources of varying degrees of reliability. Any information critical to the buying decision should be independently verified.Listing courtesy of Exclusive Homes Group Inc   Phone: 917-703-1772

William Raveis Family of Services

Our family of companies partner in delivering quality services in a one-stop-shopping environment. Together, we integrate the most comprehensive real estate, mortgage and insurance services available to fulfill your specific real estate needs.

Customer Service

888.699.8876

Contact@raveis.com

Our family of companies offer our clients a new level of full-service real estate. We shall:

  • Market your home to realize a quick sale at the best possible price
  • Place up to 20+ photos of your home on our website, raveis.com
  • Provide frequent communication and tracking reports showing the Internet views your home received on raveis.com
  • Showcase your home on raveis.com with a larger and more prominent format
  • Give you the full resources and strength of William Raveis Real Estate, Mortgage & Insurance and our cutting-edge technology

To learn more about our credentials, visit raveis.com today.

Sarah DeFlorioVP, Mortgage Banker, William Raveis Mortgage, LLC

NMLS Mortgage Loan Originator ID 1880936

347.223.0992

Sarah.DeFlorio@Raveis.com

Our Executive Mortgage Banker:

  • Is available to meet with you in our office, your home or office, evenings or weekends
  • Offers you pre-approval in minutes!
  • Provides a guaranteed closing date that meets your needs
  • Has access to hundreds of loan programs, all at competitive rates
  • Is in constant contact with a full processing, underwriting, and closing staff to ensure an efficient transaction

Ryan FortierInsurance Sales Director, William Raveis Insurance

516.739.7731

Ryan.Fortier@raveis.com

Our Insurance Division:

  • Will Provide a home insurance quote within 24 hours
  • Offers full-service coverage such as Homeowner's, Auto, Life, Renter's, Flood and Valuable Items
  • Partners with major insurance companies including Chubb, Kemper Unitrin, The Hartford, Progressive,
    Encompass, Travelers, Fireman's Fund, Middleoak Mutual, One Beacon and American Reliable

174-41 125 Avenue, Rochdale, NY, 11434

$1,345,000

Customer Service

William Raveis Real Estate

Phone: 888.699.8876

Contact@raveis.com

Sarah DeFlorio

VP, Mortgage Banker

William Raveis Mortgage, LLC

Phone: 347.223.0992

Sarah.DeFlorio@Raveis.com

NMLS Mortgage Loan Originator ID 1880936

5/6 (30 Yr)
Adjustable Rate Jumbo*
30 Year
Fixed-Rate Jumbo
15 Year
Fixed-Rate Jumbo
Loan Amount $1,076,000 $1,076,000 $1,076,000
Term 360 months 360 months 180 months
Initial Interest Rate** 5.125% 6.000% 5.750%
Interest Rate based on Index + Margin 8.125%
Annual Percentage Rate 6.246% 6.110% 5.932%
Monthly Tax Payment $625 $625 $625
H/O Insurance Payment $125 $125 $125
Initial Principal & Interest Pmt $5,859 $6,451 $8,935
Total Monthly Payment $6,609 $7,201 $9,685

* The Initial Interest Rate and Initial Principal & Interest Payment are fixed for the first and adjust every six months thereafter for the remainder of the loan term. The Interest Rate and annual percentage rate may increase after consummation. The Index for this product is the SOFR. The margin for this adjustable rate mortgage may vary with your unique credit history, and terms of your loan.

** Mortgage Rates are subject to change, loan amount and product restrictions and may not be available for your specific transaction at commitment or closing. Rates, and the margin for adjustable rate mortgages [if applicable], are subject to change without prior notice.

The rates and Annual Percentage Rate (APR) cited above may be only samples for the purpose of calculating payments and are based upon the following assumptions: minimum credit score of 740, 20% down payment (e.g. $20,000 down on a $100,000 purchase price), $1,950 in finance charges, and 30 days prepaid interest, 1 point, 30 day rate lock. The rates and APR will vary depending upon your unique credit history and the terms of your loan, e.g. the actual down payment percentages, points and fees for your transaction. Property taxes and homeowner's insurance are estimates and subject to change.