Undisclosed Address




































Description
- Listed by Charles Oppler • Prominent Properties Sotheby's International Realty-WeehawkenP: (201)-314-4922 charles.oppler@ppsir.com
Property Details for Undisclosed Address
Property Details for Undisclosed Address
| Status | Active - Active |
|---|---|
| MLS # | 24033849 |
| Days on Market | 465 |
| Taxes | $120,000 / year |
| HOA Fees | - |
| Condo/Co-op Fees | - |
| Compass Type | Single Family |
| MLS Type | Residential / Single Family Residence |
| Year Built | - |
| Lot Size | - |
| County | Bergen County |
Location
Payment Calculator
$119,661 per month
30 year fixed, 6.15% Interest
$109,661
$10,000
$0
Property Information for Undisclosed Address
- 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
- Other Charges: False
- Association: None
- Additional subst: Expanded, Center Stairwell
- Tax: $120,000
- Junior High School: Ramapo Ridge M.S.
- Senior High School: Mahwah H.S.
- Ownership: Private
- 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
- Photo Number: 36
- CourtAppYN: No
- Heatcool: Zoned, Oil, Radiant
- Cooling Type: Central Air
- 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
- 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
- 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
- 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
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| 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 | — |
| Date | Event & Source | Price |
|---|---|---|
| 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
Schools near Undisclosed Address
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
Explore Nearby Homes
- Ramapo College of New Jersey Homes for Sale
- Ramapo Homes for Sale
- Stonegate Homes for Sale
- Tuxedo Homes for Sale
- Bon Aire Homes for Sale
- Montebello Homes for Sale
- Antrim Homes for Sale
- Tallman Homes for Sale
- Viola Homes for Sale
- Pascack Valley Homes for Sale
- Wanaque Reserve Homes for Sale
- Kaser Homes for Sale
- Orangetown Homes for Sale
- Pines Lake Homes for Sale
- Clarkstown Homes for Sale
- Wyckoff Homes for Sale
- Upper Saddle River Homes for Sale
- Ringwood Homes for Sale
- Ramsey Homes for Sale
- Oakland Homes for Sale
- Mahwah Homes for Sale
- Franklin Lakes Homes for Sale
- Allendale Homes for Sale
- Airmont Homes for Sale
- Suffern Homes for Sale
- Hillburn Homes for Sale
- Wanaque Homes for Sale
- Waldwick Homes for Sale
- Warwick Homes for Sale
- Sloatsburg Homes for Sale
- 10974 Homes for Sale
- 07446 Homes for Sale
- 07456 Homes for Sale
- 07458 Homes for Sale
- 07481 Homes for Sale
- 07495 Homes for Sale
- 10901 Homes for Sale
- 10952 Homes for Sale
- 10987 Homes for Sale
- 07401 Homes for Sale
- 07417 Homes for Sale
- 07436 Homes for Sale
- 10931 Homes for Sale
- 07465 Homes for Sale
- 07463 Homes for Sale
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.




































