#25002633, Attilio Adamo, Listing Office: Serhant New Jersey LLC
#25012641·
Listing office: Serhant New Jersey LLC·
Listing agent: Attilio Adamo·
Listing office phone: 201-814-6000
$2,890,000 List price
23 Fred St Old Tappan, NJ 07675
5 beds
4 full, 4 partial
House
Property details
About 23 Fred St
Welcome to this exceptional Leonard-built custom home, designed for luxurious living. Spanning 9,200sq. ft. w/base-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.
Highlights
Home typeSingle Family Residence
HeatingBaseboard, Natural Gas, Hot Water, Radiant
StatusActive
(Active Attorney Review)
(Active Attorney Review)
CoolingCentral Air
BasementYes
ParkingGar Opener
MLS #25012641
Garage3 spaces
Fireplace3 Fireplaces, Gas
ViewOther
Summary
- Partial Bathrooms: 4
- Full Bathrooms: 4
- Basement: Yes
- Flooring Type: Hardwood
- Interior: Central Vacuum
- Fireplace: 3 Fireplaces, Gas
- Total Bedroom Count: 5
- Garage Space: 3 spaces
- Parking: Gar Opener
- Waterfront: None
- View: Other
- Exterior: Patio/Deck, Security Fence, Sprinklers
- Architectural Style: Colonial
- Heating: Baseboard, Natural Gas, Hot Water, Radiant
- Cooling: Central Air
- List Price: $2,890,000
- Annual Tax Amount: $39,310
- Tax Year: 2024
- MLS Number: 25012641
- Office Name: Serhant New Jersey LLC
- Office Phone: (201) 814-6000
- Listing Agent: Attilio Adamo
Disclaimer: 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 Rocket Homes Real Estate, LLC are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Information provided is for consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
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. Source: New Jersey Multiple Listing Service, Inc. Copyright© 2025 New Jersey Multiple Listing Service, Inc. All rights reserved.
Rocket Homes Real Estate, 701 Griswold St, Suite 21, Detroit, MI 48226
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 5/22/2025, 10:20:38 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$2,890,000
23 Fred St
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Sep 06, 2011 | Home Sold | $2,300,000 |
| Dec 27, 2004 | Home Sold | $750,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $1,825,000 | $39,310 |
| 2022 | $1,825,000 | $38,744 |
| 2021 | $1,825,000 | $38,744 |
| 2020 | $1,825,000 | $38,179 |
| 2019 | $1,825,000 | $36,883 |
History based on county public records data.
Nearby schools
9
T. Baldwin Demarest Elementary School
Public District KG-4
0.8 mi
•1 School St
8
Roberge Elementary School
Public District KG-5
1.0 mi
•617 Westwood Ave
8
Meadowbrook School
Public District PK-4
1.6 mi
•50 Piermont Ave
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $185,054. The majority of Old Tappan, NJ residents have income $200k+ annually. Most families are married, with kids. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
7%
<35k
12%
35k-100k
37%
100k-200k
44%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
15%
Single, No Kids
5%
Single, with Kids
39%
Married, No Kids
41%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
18%
<11 yrs old
12%
12-17 yrs old
12%
18-34 yrs old
45%
35-64 yrs old
13%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
Men's Tennis- Tennis
Where do the neighbors shop?
Nordstrom
Bloomingdales
Brooks Brothers
Where do the neighbors go to eat?
California Pizza Kitchen
Bonefish Grill
Qdoba
What do the neighbors drive?
BMW
Lexus
Acura
What do the neighbors listen to?
Talk/Personality
News
Sports
All data provided by Home Junction and Claritas
Similar homes for sale
#25005576, Attilio Adamo, Listing Office: Serhant New Jersey LLC
#25013953, Philip Soo, Listing Office: Prominent Properties Sothebys International Realty-Tenafly
22 hours on Rocket
$10,000 Closing Credit¹
#25017129, Christina L. Gibbons, Listing Office: Christies International Real Estate Group-Ridgewood
#25003036, Risa Corson, Listing Office: Coldwell Banker, Alpine/Closter
#24031213, Attilio Adamo, Listing Office: Serhant New Jersey LLC
$10,000 Closing Credit¹
#25002342, Ana Enersen, Listing Office: Keller Williams Town Life
5 days on Rocket
$10,000 Closing Credit¹
#25016639, Listing Office: Mike Koen Realty
$10,000 Closing Credit¹
#3962249, Listing Office: MIKE KOEN REALTY LLC
Tour
$10,000 Closing Credit¹
#25011925, David Arabia, Listing Office: Corcoran Infinity Properties
Frequently asked questions
About 23 Fred St
The listing price of 23 Fred St property is $2,890,000.
The property 23 Fred St is a house located in Old Tappan, New Jersey, 07675.
Active Listing: 23 Fred St is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 23 Fred St are: T. Baldwin Demarest Elementary School (GreatSchools Rating 9/10), Roberge Elementary School (GreatSchools Rating 8/10), Meadowbrook School (GreatSchools Rating 8/10), Charles DeWolf Middle School (GreatSchools Rating 9/10), Harrington Park School (GreatSchools Rating 8/10), Holdrum Middle School (GreatSchools Rating 7/10), Northern Valley Regional High School at Old Tappan (GreatSchools Rating 9/10), Pascack Valley High School (GreatSchools Rating 9/10), Emerson Junior/Senior High School (GreatSchools Rating 6/10).
According to the records, the last property tax for 2024 is $39,310 (source: MLS/based on county public records data).
The last sale was on September 6, 2011 for $2,300,000 (source: MLS/tax record).
The property at 23 Fred St has 5 bedrooms and 4 full and 4 half bathrooms.
This home is located at 23 Fred St in Old Tappan, NJ and zip code 07675. Features: 5 bedrooms, 8 bathrooms. It has been listed on Rocket Homes since April 25, 2025 and is currently priced at $2,890,000.
The number of listings in Old Tappan, NJ decreased by 5.3% between March and April 2025. While the average time on the market in April 2025 was 52 days, the median list price was $1,299,000.
From Rocket Homes Real Estate and based on county public records data.