$3,150,000
PENDING

817 Apple Ridge Rd Franklin Lakes, NJ 07417

Estimated payment $19,811/month

Total Views 6,417
6 Beds
8 Baths
-- Sq Ft
-- Price per Sq Ft

Highlights

  • Gunite Pool
  • Custom Home
  • Wood Flooring
  • Colonial Road School Rated A-
  • Great Room with Fireplace
  • Wine Refrigerator

About This Home

Designer Home 2.0!....Completely reimagined over the past few years this exceptional home features approx.8000sq.ft of living and entertaining space situated on one of Franklin Lakes most coveted streets.The layout of this beauty flows effortlessly & designed for everyday living and grand scale entertaining.This home welcomes you with a grand foyer leading to a central staircase adorned w/crown molding,tray ceilings and custom millwork throughout.Gourmet kitchen offers SS appliances,oversized Xtra deep Quartz center island, floor to ceiling custom cabinetry+ large covered balcony from kitchen & dining room. overlooking pool w/waterfalls.Additional adjacent flex space ideal for den or entertainment room.The open floor plan connects both dining and living room as well as the sun drenched Great Rm w/wet bar.Upstairs finds the lavish owners suite,balcony,multiple walk- in closets,LUXE spa like bath w/soaking tub.Additional 3 bedroom en-suites one w/ balcony completing the 2nd floor.The walk out lower level equally impressive boasts a spacious entertainment room w/stone FPL,wet bar,2 beverage centers along w/(3) sets of sliders to patio.Two additional bedrooms with sliding doors also which lead out to the private patio.Enjoy the ultimate backyard oasis with salt water gunite pool, spa, outdoor lounge areas and lush landscaping.Located in ansopught after neighborhood,low taxes and convenient access to dining, shopping and NYC. Don't miss this opportunity!

Listing Agent

Ellen Horowytz

PROMINENT PROPERTIES SIR Brokerage Phone: 201-410-1332 Listed on: 05/15/2025

PROMINENT PROPERTIES SIR

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $28,973

Year Built

  • Built in 1989 | Remodeled

Lot Details

  • 0.92 Acre Lot
  • Sprinkler System

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener
  • Circular Driveway

Home Design

  • Custom Home
  • Colonial Architecture
  • Siding
  • Composite Building Materials

Interior Spaces

  • Gas Fireplace
  • Entrance Foyer
  • Great Room with Fireplace
  • 4 Fireplaces
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Library with Fireplace
  • Recreation Room with Fireplace
  • Game Room
  • Wood Flooring

Kitchen

  • Gas Oven or Range
  • Self-Cleaning Oven
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary bedroom located on second floor
  • Powder Room
  • Soaking Tub
  • Separate Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Gunite Pool
  • Patio
  • Gazebo
  • Porch

Schools

  • High Mtn Elementary School
  • Franklin Middle School
  • Ramapo High School

Utilities

  • Forced Air Zoned Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 1120-02312-0000-00003-0000-
  • Tax Block *

Home Details

Home Type

Single Family

Est. Annual Taxes

$28,973

Year Built

Built in 1989 | Remodeled

Lot Details

0

Parking

3

Listing Details

  • Style: Colonial, Custom Home
  • Primary Style: Colonial
  • Subproperty Type: Single Family
  • Year Built: 1989
  • Year Built Description: Renovated
  • County Name: Bergen
  • Renovated Year: 2020
  • Street Number Display: 817
  • Directions: High Woods to Apple Ridge Rd
  • I D: 5358324
  • Modified: 2025-07-16
  • Number Images: 46
  • Attribution Contact: 201-410-1332
  • MLS Status: Under Contract
  • Special Features: None
  • Property Sub Type: Detached
  • Year Renovated: 2020

Interior Features

  • Flooring: Wood
  • Fireplace Description: Bedroom 1, Gas Fireplace, Great Room, Library, Rec Room
  • Number of Fireplaces: 4
  • Appliances: Central Vacuum, Dishwasher, Dryer, Range/Oven-Gas, Refrigerator, Self Cleaning Oven, Washer, Wine Refrigerator
  • Number Rooms: 16
  • Bedrooms: 6
  • Bedroom 1 Level: Second
  • Bedroom 2 Level: Second
  • Bedroom 3 Level: Second
  • Primary Bathroom Features: Soaking Tub, Stall Shower
  • Bathrooms: 6.20
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Description: Finished, Full, Walkout
  • Dining Room Level: First
  • Den Level: First
  • Family Room Level: First
  • Kitchen Area: Center Island
  • Kitchen Level: First
  • Living Room Level: First
  • Level 1 Rooms: Breakfast Room, Dining Room, Family Room, Foyer, GarEnter, Great Room, Kitchen, Laundry Room, Living Room, Powder Room
  • Level 2 Rooms: 4 Or More Bedrooms, Bath Main, Bath(s) Other
  • Ground Level Rooms: 2 Bedrooms, Bath Main, Bath(s) Other, GameRoom, GarEnter, Walkout

Exterior Features

  • Exterior Description: Composition Siding
  • Exterior Features: Barbeque, Gazebo, Open Porch(es), Patio, Underground Lawn Sprinkler, FencVnyl
  • Pool: Yes
  • Pool Description: Gunite, Heated
  • Roof Description: Asphalt Shingle

Garage/Parking

  • Garage Description: Built-In Garage, Garage Door Opener
  • Number Garage Spaces: 3
  • Parking Driveway Description: Blacktop, Circular

Utilities

  • Cooling: Central Air, Multi-Zone Cooling
  • Fuel Type: Gas-Natural
  • Heating: Forced Hot Air, Multi-Zone
  • Sewer: Septic 5+ Bedroom Town Verified
  • Utilities: Gas-Natural
  • Water: Public Water

Schools

  • Elementary School: HIGH MTN
  • Middle School: FRANKLIN
  • High School: RAMAPO
  • High School: RAMAPO
  • Middle Jr High School: FRANKLIN

Lot Info

  • Lot Size: .918AC.
  • Assessed Improvement Value: 1179600
  • Assessed Land Value: 433600
  • Assessment: 1613200
  • Easement: Unknown
  • Lot Identifier: 3
  • Lot I D Tax: *
  • Lot Size Tax: *
  • Total Acres: 0.92

Tax Info

  • Tax Acres: *
  • Assessed Improvement Value: *
  • Assessed Land Value: *
  • Total Tax Assessed: *
  • Streetname Tax: *
  • Street Number Tax: *
  • Tax Amount: 28973
  • Tax Amount Tax: *
  • Assessor Parcel Number: 1120-02312-0000-00003-0000-
  • Assessor Parcel Number: *
  • Tax Rate Amount: 1.796
  • Tax Rate Tax: *
  • Tax Rate Year: 2024
  • Tax Year Tax: *
  • Tax Year: 2024

MLS Schools

  • Grade School: HIGH MTN

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 $27,908 $1,613,200 $433,600 $1,179,600
2023 $27,199 $1,613,200 $433,600 $1,179,600
2022 $27,199 $1,613,200 $433,600 $1,179,600
2021 $14,958 $900,000 $433,600 $466,400
2020 $14,832 $900,000 $433,600 $466,400
2019 $17,272 $1,051,900 $433,600 $618,300
2018 $17,093 $1,051,900 $433,600 $618,300
2017 $17,209 $1,051,900 $433,600 $618,300
2016 $17,262 $1,051,900 $433,600 $618,300
2015 $16,820 $1,051,900 $433,600 $618,300
2014 $16,536 $1,051,900 $433,600 $618,300
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/16/2025 07/16/25 Pending -- -- --
05/15/2025 05/15/25 For Sale $3,150,000 +61.8% --
12/10/2021 12/10/21 Sold $1,947,000 -2.6% $363 / Sq Ft
10/21/2021 10/21/21 Pending -- -- --
10/05/2021 10/05/21 Price Changed $1,999,500 -7.0% $373 / Sq Ft
09/13/2021 09/13/21 For Sale $2,149,000 0.0% $401 / Sq Ft
09/09/2021 09/09/21 Pending -- -- --
06/04/2021 06/04/21 Price Changed $2,149,000 -6.5% $401 / Sq Ft
04/27/2021 04/27/21 For Sale $2,299,000 +182.1% $429 / Sq Ft
05/09/2018 05/09/18 Sold $815,000 +41.7% $152 / Sq Ft
04/13/2018 04/13/18 Pending -- -- --
03/28/2018 03/28/18 For Sale $575,000 -- $107 / Sq Ft
Source: Garden State MLS

Purchase History

Date Type Sale Price Title Company
Deed $1,947,000 Old Republic National Title
Deed $815,000 --
Sheriffs Deed -- None Available
Deed -- --
Deed $1,500,000 --
Bargain Sale Deed $900,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $750,000 New Conventional
Previous Owner $500,000 New Conventional
Previous Owner $250,000 Credit Line Revolving
Previous Owner $1,000,000 No Value Available
Previous Owner $232,800 Credit Line Revolving
Previous Owner $720,000 Unknown
Source: Public Records

Similar Homes in the area

  • 249 Terrace Rd, Franklin Lakes, NJ 07417

    $3,499,000

    • 5 Beds
    • 4.5 Baths
    • 249 Terrace Rd
    • Franklin Lakes, NJ

    Stunning new construction set high atop Terrace Road with spectacular views. This custom home features 5 bedrooms, 4 and a half bathrooms, 3 car garage, an elevator, soaring 21 foot ceilings in the grand two story foyer and great room, a bridal staircase, 10 ft ceilings on the main floor, a luxurious primary suite, a finished basement and room for a pool. Roughly 6000 sq ft on the first and

    Jamie Oakley Prominent Properties Sotheby's International Realty-Franklin Lakes

    Section Image
  • 396 Crescent Dr, Franklin Lakes, NJ 07417

    $2,750,000

    • 4 Beds
    • 3.5 Baths
    • 396 Crescent Dr
    • Franklin Lakes, NJ

    Timeless elegance defines this custom built stone villa ,set on 1 acre of lush grounds with a view of Baker's Pond.A paver driveway leads to a secluded mini-estate that truly is a one-of-a-kind.This exceptional 2008 lakefront colonial features finely crafted architectural details incorporated into a spacious and modern floor plan designed for today's lifestyle demands.A soaring two-story great

    Grazyna Ziarko Christie's International Real Estate Group-Franklin Lakes

    Section Image
  • 291 Lynn Dr, Franklin Lakes, NJ 07417

    $3,300,000

    • 5 Beds
    • 5.5 Baths
    • 291 Lynn Dr
    • Franklin Lakes, NJ

    Introducing brand NEW CONSTRUCTION in prestigious Franklin Lakes! Design & build by renowned local builder & interior designer, this exceptional home offers 7,000+sf of living space featuring unparalleled craftsmanship and style at an incredible VALUE - sitting on approx 1 acre. Featuring high-end finishes, an exceptional floor plan, & luxury touches throughout, this home is perfect for today's

    Tony Nabhan Keller Williams City Views Realty

    Section Image
  • 703 Ginger Ln, De Soto, NJ 07417

    $2,675,000

    • 5 Beds
    • 6.5 Baths
    • 703 Ginger Ln
    • De Soto, NJ

    ABSOLUTELY Amazing Opportunity to Own This Stunning, All-Brick, Center Hall Colonial with an in-ground gunite pool and poolhouse in a coveted neighborhood in Franklin Lakes. This home has it all- a Grand 2 story entrance with sweeping staircase, 2 story Great room, Spacious LR w/FP and DR w/ butler's pantry, a chef's kitchen w/ seated center island, 2 story conservatory, Office, New CHIC PR,

    Melissa Shiel Keller Williams Village Square Realty - Wyckoff

    Section Image
  • 248 Hidden Pond Path, Franklin Lakes, NJ 07417

    $3,975,000

    • 5 Beds
    • 6 Baths
    • 248 Hidden Pond Path
    • Franklin Lakes, NJ

    Spectacular cul de sac setting for this 5 bedroom,6.2 bath center hall colonial. Inground pool/spa, Baker's Pond views, firepit and multi level terraces. Primary suite with sitting room and large bath are/fireplace, 3 ensuite bedrooms, first floor guest br/bath, large rooms throughout highlighted by a gourmet kitchen/fpl, FDR,Fr/fpl, private office/fireplace and much more. Wine cellar highlights

    Charles Oppler Prominent Properties Sotheby's International Realty-Weehawken

    Section Image
  • 310 Haven Rd, Franklin Lakes, NJ 07417

    $2,999,999

    • 5 Beds
    • 6 Baths
    • 310 Haven Rd
    • Franklin Lakes, NJ

    Charm and class describes this special Franklin Lakes Gem. A welcoming front porch leads you to a dramatic two-story entry foyer with Radiant heat. Banquet size, formal dining room, formal living room opens to the sunroom both have Radiant heat as well. Dramatic great room with floor to ceiling stone fireplace, wet bar, cathedral ceiling with French doors to lush backyard. Spacious kitchen with

    GREGORY EARNSHAW COLDWELL BANKER REALTY WYK

    Section Image
  • 106 Greenfield Hill, Franklin Lakes, NJ 07417

    $3,950,000

    • 6 Beds
    • 8 Baths
    • 106 Greenfield Hill
    • Franklin Lakes, NJ

    Luxury at its Finest!A Custom-built Colonial style estate situated at the end of a gorgeous tree lined Cul de Sac.This spectacular, one-of-a-kind extraordinary home is a masterpiece of luxury and craftsmanship, brimming with exquisite details that showcase unparalleled elegance. The intricate moldings and finishings throughout the home are a testament to the meticulous attention to detail that

    Ellen Horowytz PROMINENT PROPERTIES SIR

    Section Image
  • 745 Colonial Rd, Franklin Lakes, NJ 07417

    $3,195,000

    • 6 Beds
    • 6.5 Baths
    • 745 Colonial Rd
    • Franklin Lakes, NJ

    Timeless elegance greets you the moment you step into this stunning young Center Hall Colonial. Offering an impressive 8,744 square feet across the first and second floors, this home features soaring ceilings, generously sized rooms, and radiant heat throughout. The custom-designed chefa€TMs eat-in kitchen is a true showstopper, complete with a full bara€”perfect for entertaining. Additional

    Tony Nabhan Keller Williams City Views Realty

    Section Image
  • 356 Indian Trail Dr, Franklin Lakes, NJ 07417

    $3,295,000

    • 6 Beds
    • 6.5 Baths
    • 356 Indian Trail Dr
    • Franklin Lakes, NJ

    Step into timeless elegance and refined living with this private,8,200sf all brick colonial located on 1.3 acres backing up to Green Acres Preserves on one of the most prestigious blocks in town.The main living area boasts an effortless flow,perfect for intimate gatherings and large entertaining.Chef's kitchen incl 2 ovens & 2DWs,custom cabinetry and large island.Adjacent to the kitchen is a

    Grazyna Ziarko Christie's International Real Estate Group-Franklin Lakes

    Section Image

Source: Garden State MLS

MLS Number: 3963499

Garden State MLS

APN: 20-02312-0000-00003