Undisclosed Address

Sq. Ft.
/ Sq. Ft.
Sq. Ft.
per Sq. Ft.

Description

  1. Listed by Charles Oppler • Prominent Properties Sotheby's International Realty-Weehawken
    P: (201)-314-4922 charles.oppler@ppsir.com

Property Details for Undisclosed Address

Style
Single Family Residence
Sub style
Other
Waterfront
River Front
Garage
Attached, Gar Opener
LISTING UPDATED: 10/31/2025 01:05 PM

Property Details for Undisclosed Address

StatusActive - Active
MLS #24033849
Days on Market465
Taxes$120,000 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built-
Lot Size-
CountyBergen County

Location

Listing Courtesy of Prominent Properties Sotheby's International Realty-Weehawken, Charles Oppler
Add your commute

Payment Calculator

$119,661 per month

30 year fixed, 6.15% Interest

Principal and Interest

$109,661

Property Taxes

$10,000

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for Undisclosed Address

Summary
Location and General Information
  • Area name: Mahwah
  • Flood plain: Lender May Require Ins
  • Street Name: Stabled
  • County Name: BERGEN
  • Status: Active
  • Street Number Numeric: 200
  • Street Direction: East, Mountain(s), River
  • Zip Code: 07430
Taxes and HOA Information
  • Other Charges: False
  • Association: None
  • Additional subst: Expanded, Center Stairwell
  • Tax: $120,000
School Information
  • Junior High School: Ramapo Ridge M.S.
  • Senior High School: Mahwah H.S.
Owner
  • Ownership: Private
Property
Lot Information
  • Lot description: Cul-De-Sac
  • Year Built: 2000's
  • Views exposure: East, Mountain(s), River
  • Miscellaneous: Deck / Patio, Hdwd As In, Intercom, Security, Skylight(s), Sprinklers, Well, WW/Carpet As In
Property and Assessments
  • Photo Number: 36
  • CourtAppYN: No
Utilities
  • Heatcool: Zoned, Oil, Radiant
  • Cooling Type: Central Air
Interior and Exterior Features
Interior Features
  • Bedrooms: 10
  • Baths full: 10
  • Baths partial: 4
  • Basement: Finished, Full, Grd Lv Acces
  • Basement Description: Ground Level
  • Number of rooms: 24
  • Lifestyle: 1st Flr Mbdrm, Close/Shopg, Extended Family
  • Full Baths Total: 14
  • Num of Baths: 10.4
Exterior Features
  • Fireplace: 5+
  • Exterior: Stone
  • Miscellaneous: Deck / Patio, Hdwd As In, Intercom, Security, Skylight(s), Sprinklers, Well, WW/Carpet As In
  • Pool: True
  • Pool Type: Gunite, Heated, Indoor, In Ground, Outdoor Pool
Agent
Sale and Listing Information
  • Management Phone: (201) 314-4922
  • Search Class: RES, Residential
  • List Price: $22,500,000.00
  • Listing Date: 10-19-2024
  • Status Date: 10-18-2024
Showing Information
  • Internet Remarks: Gated Magnificent 43+ acres of incredible property on the Ramapo River. Perfect equestrian estate with trails, 20 stall barn, paddocks and indoor riding area. Spectacular entertaining with with wet bar/English pub, theater, wine cellar, indoor/outdoor pools, spa, theater, more. Sports courts, football field and open areas. fabulous home with 1st floor primary, soaring ceilings, fireplaces, privacy and so much more. Carriage house with 2/3BR and open space. appx 3400sf. Amazing one of a kind opportunity. Brochure available.

Property History for Undisclosed Address

DateEvent & SourcePriceAppreciation
Oct 18, 2024

Listed (Active)

NJMLS #24033849

$22,500,000
Oct 11, 2023

Temporarily Off Market

NJMLS #23031435

Oct 11, 2023

Listed (Active)

NJMLS #23031435

$22,500,000
Jan 23, 2020

Temporarily Off Market

NJMLS #20003118

Jan 23, 2020

Listed (Active)

NJMLS #20003118

$18,900,000
DateEvent & SourcePrice
10/18/2024

Listed (Active)

NJMLS #24033849

$22,500,000
10/11/2023

Temporarily Off Market

NJMLS #23031435

10/11/2023

Listed (Active)

NJMLS #23031435

$22,500,000
01/23/2020

Temporarily Off Market

NJMLS #20003118

01/23/2020

Listed (Active)

NJMLS #20003118

$18,900,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for Undisclosed Address

Taxable ValueLand$32,400Additions-Total$32,400
Tax Record2024$669 ($56 / month)
Home Facts
Lot Size1,410,908 SqFtStyleFarmsCountyBERGENAPN33 00024-0000-00001-0000-QFARM

Schools near Undisclosed Address

This home is within Mahwah Township Public School District.
Rating
School
Type
Grades
Distance
Public - K to 3
Public - 6 to 8
Public - 9 to 12
Public - PK to 3
Rating
School
Distance
George Washington Elementary School
PublicK to 3

Ramapo Ridge Middle School
Public6 to 8

Mahwah High School
Public9 to 12

Lenape Meadows School
PublicPK to 3

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Undisclosed Address is a single family home for sale in Mahwah, NJ 07430. This property was listed for sale on October 19, 2024 by Prominent Properties Sotheby's International Realty-Weehawken, it's currently listed at $22,500,000. This listing's school district is Mahwah Township Public School District. Nearby schools include George Washington Elementary School, Ramapo Ridge Middle School and Mahwah High School. Undisclosed Address is a 10-bed, 14-bath, single family home.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass makes no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Prominent Properties Sotheby's International Realty-Weehawken, Charles Oppler

The data relating to the real estate for sale on this website comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than (insert office name) aremarked 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: 01/27/2026 12:50 PM. Source: New Jersey Multiple Listing Service, Inc. © 2026 New Jersey Multiple Listing Service, Inc. All rights. The data relating to the real estate for sale and sold listing information on this website comes from the New Jersey Multiple Listing Service, Inc. Virtual Office Website (VOW) program. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. Sold listings may have been listed and/or sold by a real estate brokerage other than (insert office name). All information deemed reliable but not guaranteed. NLMLS makes no representation or warranty regarding the accuracy of the data. This data and information is protected under federal copyright laws which prohibit the unauthorized copying or alternation of all or any part of copyrighted materials, including certain compilations of data and information. Copyright violators may be subject to severe fines and penalties under federal law. Source: New Jersey Multiple Listing Service Inc. Last date updated: 01/27/2026 12:50 PM © 2026 New Jersey Multiple Listing Service Inc. All rights reserved.