• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON MAY 10 2025 AT 12:49 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

23 Fred St

old tappan, NJ 07675

$2,890,000

  • 5 BR
    4 BA, 4 HALF BA

INTERESTED? LET'S CONNECT

Welcome to this exceptional Leonard-built custom home, designed for luxurious living. Spanning 6,000 sq. ft. with a newly finished 3,000 sq. ft. basement, this residence features a stunning two-story foyer, elegant living and dining rooms, and a spacious family room with a cozy fireplace. The gourmet kitchen boasts state-of-the-art appliances and a generous layout, complemented by a convenient mudroom and multiple baths throughout. The second floor is a haven of relaxation, hosting a sprawling primary suite with a sitting area and large walk-in closet, along with a junior suite, a Jack-and-Jill bath, and a study. The beautifully finished basement offers endless entertainment options with a theater, game room, gym, and rec room with a fireplace. Step outside to discover a resort-style backyard featuring a heated saltwater pool, waterfall, hot tub, custom built-in fire pit, water slide and a fully equipped outdoor cabana perfect for gatherings. This dream home truly has it all.

Details

Single Family Home

$40,186 Annual Tax

MLS/Listing ID 25012641

Amenities & Features

Heating - Baseboard

Gas Fireplace

Cooling - Central Air

Lot - Regular Lot

Heating - Radiant

Heating - Hot Water

Heating - Gas

Listing Courtesy of SERHANT NEW JERSEY LLC, ATTILIO ADAMO - 201-264-8305

NJMLS

Source of Data: NEW JERSEY MLS

Interested in 23 Fred St?

NJMLS

The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Douglas Elliman of NJ are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website.

All information deemed reliable but not guaranteed. Last date updated: 05/10/2025.
Source: New Jersey Multiple Listing Service, Inc.

© 2025 New Jersey Multiple Listing Service, Inc. All rights reserved.