$2,150,000
OPEN SAT 1PM - 3PM

Estimated payment $14,687/month

Total Views 8,255
5 Beds
7 Baths
-- Sq Ft
-- Price per Sq Ft

Highlights

  • Hot Property
  • Views to the East
  • Cul-De-Sac
  • Robert D. Reynolds Elementary School Rated A
  • Multiple Fireplaces
  • En-Suite Primary Bedroom

About This Home

Welcome to this exquisite all-brick manor, tucked away on a quiet double cul-de-sac in desirable Upper Saddle River. The Belgium block driveway & paver walkway lead to a grand 2-stry foyer w/ radiant heated limestone floors & an elegant sweeping staircase. French doors open to a cozy library with built-ins and a marble fireplace, perfect for work or quiet moments. An elegant formal dining room w/custom woodwork & walnut inlay floors sets the stage for memorable gatherings. The butlerâ€s pantry leads into the newly renovated chefâ€s kitchen, w/Wolf 36" gas range, Miele double ovens, 2 Miele dishwashers & a SubZero refrigerator that flows into the sunny breakfast area. Host family gatherings in the breathtaking 2-story great room with stone fireplace, wet bar, bev fridge & sliders to the expansive backyard. The main level also offers a walk-in pantry, spacious laundry rm, powder rm, mudroom w/built-ins, guest bedrm, and full bath. Upstairs, the spacious primary suite features dual walk-in closets, a spa-like bath & an ensuite office/bonus room. No one has to share with 3 more ensuite bedrms completing this level! The amazing lower level has it all—an entertaining area which includes a wetbar w/ fridge, sink, dishwasher, a rec area for games, a TV area w/ fireplace, plus a bonus room, gym & 1/2 bath, plenty of storage plus access to the 3-car heated garage. Outdoors, enjoy a large paver patio, expansive yard & the added peace of mind of a Generac generator.Your dream home is

Last Listed By

Lisa Marino Ceccon

Keller Williams Village Square Realty Listed on: 05/27/2025

Keller Williams Village Square Realty

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,825

Year Built

  • 2004

Lot Details

  • 0.86 Acre Lot
  • Cul-De-Sac
  • Rectangular Lot

Parking

  • 3 Car Garage

Home Design

  • Brick Exterior Construction

Interior Spaces

  • Multiple Fireplaces
  • Gas Fireplace
  • Views to the East
  • Finished Basement

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom

Schools

  • Reynolds/Bogert Elementary School
  • Emil A Cavallini Middle School
  • Northern Highlands School

Utilities

  • Central Air
  • Baseboard Heating
  • Heating System Uses Natural Gas
  • Radiant Heating System

Listing and Financial Details

  • Legal Lot and Block 14 / 1105

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,825

Year Built

2004

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Su Prop: Residentia
  • Ownership: Private
  • PropertySubType: Single Family Residence
  • ResoLotFeatures: Cul-De-Sac, Regular
  • View Type:Pond View: East, Sunrise
  • Co List Office Phone: 201-445-4300
  • Outside Inclusions: LIGHT FIXTURES, WINDOW TREATMENTS, GENERAC GENERATOR
  • MLS Status: Active - Active
  • Directions: Union to Riverview Terrace, Left on Sunset
  • Reso Fireplace Features: 3 Fireplaces, Gas, Self-start
  • Year Built Details: 2000's
  • PropertySubTypeAdditional: Manor
  • Power Production Ownership: Unknown
  • Special Features: OpenHouse
  • Property Sub Type: Detached
  • Year Built: 2004

Interior Features

  • Basement: Finished
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 5
  • Primary Bathroom: Yes
  • Basement Remarks: ENTR AREA W/ RFRG,DW,SINK, TV AREA W/FRPL, GAME AREA, GYM, 1/2 BATH, GRG ACCSS

Exterior Features

  • Pool Features: None
  • Waterfront Features: None
  • Disclosures: Seller's Agent, Seller Disclosure - Yes
  • Construction Type: Brick

Garage/Parking

  • Garage Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Heating: Baseboard, Natural Gas, Zoned, Radiant

Schools

  • Elementary School: REYNOLDS/BOGERT
  • High School: NORTHERN HIGHLANDS
  • Middle Or Junior School: EMIL A CAVALLINI M.S
  • Elementary: REYNOLDS/BOGERT

Lot Info

  • Lot Dimensions: .86
  • Lot Size Sq Ft: 37462.0

Tax Info

  • Tax Annual Amount: 31825.0
  • Tax Block: 1105
  • Tax Lot: 14

MLS Schools

  • High School Text: NORTHERN HIGHLANDS

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $31,000 $1,250,000 $334,400 $915,600
2023 $30,913 $1,250,000 $334,400 $915,600
2022 $30,913 $1,250,000 $334,400 $915,600
2021 $30,850 $1,250,000 $334,400 $915,600
2020 $30,425 $1,250,000 $334,400 $915,600
2019 $33,180 $1,395,300 $334,400 $1,060,900
2018 $32,943 $1,395,300 $334,400 $1,060,900
2017 $32,678 $1,395,300 $334,400 $1,060,900
2016 $31,687 $1,395,300 $334,400 $1,060,900
2015 $31,227 $1,395,300 $334,400 $1,060,900
2014 $30,669 $1,395,300 $334,400 $1,060,900
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/27/2025 05/27/25 For Sale $2,150,000 0.0% --
12/18/2018 12/18/18 Rented $6,400 -8.6% --
12/18/2018 12/18/18 For Rent $7,000 -- --
Source: New Jersey MLS

Purchase History

Date Type Sale Price Title Company
Deed $1,750,000 --
Deed $1,575,000 --
Deed $525,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $500,000 Credit Line Revolving
Closed $67,200 Unknown
Closed $1,000,000 Stand Alone Refi Refinance Of Original Loan
Closed $1,038,000 Unknown
Closed $1,062,000 Unknown
Previous Owner $1,150,000 No Value Available
Previous Owner $975,000 No Value Available
Source: Public Records

About the Listing Agent

Lisa Marino Ceccon

Keller Williams Village Square Realty

(201) 778-6061

Section Image

With over 30 years of experience in a family-owned General Contracting and Real Estate Development business, I bring a deep understanding of building and property development to my real estate practice. This extensive background equips me with the expertise to find not just any property, but the perfect one tailored to my clients' specific needs and desires.

For the past 4 years, I’ve been applying this knowledge in the real estate industry, where I’ve honed my skills in sourcing the

Lisa's Other Listings

  • 25 Harriot Ave, Harrington Park, NJ 07640

    $779,000 Pending

    • 4 Beds
    • 3.5 Baths
    • 25 Harriot Ave
    • Harrington Park, NJ

    Built in 2000, this home offers almost 3000 square feet of beautifully designed living space and a layout that feels expansive & inviting. The entry foyer opens to a seamless flow between the living room, dining room & eat-in kitchen, enhanced by nearly floor-to-ceiling windows that bring in incredible light! The kitchen features a spacious dining area & a large bay window that floods the space

    Lisa Marino Ceccon Keller Williams Village Square Realty

    Section Image

Source: New Jersey MLS

MLS Number: 25016807

New Jersey MLS

APN: 63-01105-0000-00014