Retreat to your private paradise in this completely renovated lakefront property in beautiful Shadow Lake Estates. A hidden gem offering mesmerizing water views and incomparable sunsets, this sanctuary provides a front seat to nature, with each season ushering in a new wonder to behold. This 5-bedroom, 5-1/2 bath residence sits on over two acres and includes approximately 300 feet of shoreline for easy access to enjoyment on the water. The open floor plan seamlessly merges indoor and outdoor spaces, and includes a chef's kitchen with top of the line appliances, a large great room with soaring ceilings, three fireplaces as well as a music room. A walkout lower level with a rec room and wine cellar, a service kitchen for outdoor entertaining, and a spa bathroom with steam shower and sauna adjacent to the exercise room adds a third level of living. The heated pool with sun shelf adds to the vacation feel of this home. An organic vegetable garden and a terraced herb garden adjacent to the spacious kitchen rounds out this offering. While only 30 min. to Manhattan, you will feel worlds away. This residence is part of Shadow Lake Estates, an enclave of special properties with membership only access to a lakefront clubhouse, tennis and pickleball, boating, fishing and swimming.
Under contract
$3,150,000
240 Green Ridge Rd, Franklin Lakes, NJ 07417
5beds
--sqft
Est.: Get pre-qualified
Single Family Residence
Built in ----
-- sqft lot
$-- Zestimate®
$--/sqft
$-- HOA
What's special
Three fireplacesOver two acresOrganic vegetable gardenIncomparable sunsetsCompletely renovated lakefront propertyMusic roomMesmerizing water views
- 50 days |
- 390 |
- 5 |
Zillow last checked:
Listing updated:
Listed by:
Robert Funabashi 201-245-7334,
Prominent Properties Sotheby's International Realty-Saddle River
Source: NJMLS,MLS#: 26012210
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Heating
- Baseboard, Natural Gas, Forced Air, Zoned
Cooling
- Central Air
Features
- Central Vacuum, One Floor Living
- Flooring: Hardwood
- Basement: Finished,Walk-Out Access
- Number of fireplaces: 3
- Fireplace features: 3 Fireplaces, Gas
Property
Parking
- Total spaces: 7
- Parking features: Garage
- Garage spaces: 2
- Details: Attached
Features
- Patio & porch: Deck / Patio
- Pool features: Gunite, Heated, In Ground
- Has view: Yes
- View description: Sunset
- Waterfront features: Lake Front
Lot
- Features: Regular
Details
- Parcel number: 200260200000900009
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Cement Siding
Community & HOA
Community
- Features: Close/Parks, Close/School, Close/Shopg, Close/Trans, Close/Wrshp, Extended Family
- Security: Security
Location
- Region: Franklin Lakes
Financial & listing details
- Tax assessed value: $1,566,800
- Annual tax amount: $29,800
- Date on market: 4/10/2026
- Listing agreement: Exclusive Right To Sell
- Ownership: Private
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/1/2026 | Pending sale | $3,150,000 |
Source: | ||
| 4/10/2026 | Listed for sale | $3,150,000+85.3% |
Source: | ||
| 7/30/2007 | Sold | $1,700,000 |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $28,140 | $1,566,800 |
| 2024 | $28,140 +3.8% | $1,566,800 |
| 2023 | $27,106 +2.6% | $1,566,800 |
| 2022 | $26,416 +1.4% | $1,566,800 |
| 2021 | $26,040 +1.2% | $1,566,800 |
| 2020 | $25,727 +1% | $1,566,800 |
| 2019 | $25,461 | $1,566,800 |
| 2018 | $25,461 +0.1% | $1,566,800 +1.1% |
| 2017 | $25,436 +2.6% | $1,550,000 |
| 2016 | $24,785 +1.7% | $1,550,000 |
| 2015 | $24,366 +1% | $1,550,000 |
| 2014 | $24,134 -7% | $1,550,000 -8.6% |
| 2013 | $25,955 | $1,696,400 |
| 2012 | $25,955 +18.7% | $1,696,400 |
| 2011 | $21,860 +4.2% | $1,696,400 -3.3% |
| 2010 | $20,983 -11.9% | $1,754,400 |
| 2009 | $23,822 | $1,754,400 -15% |
| 2007 | -- | $2,064,300 +156.8% |
| 2006 | -- | $803,800 |
| 2005 | -- | $803,800 |
| 2004 | -- | $803,800 |
| 2003 | -- | $803,800 |
| 2002 | -- | $803,800 |
| 2001 | -- | $803,800 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 07417
Nearby schools
GreatSchools rating
- 9/10Woodside Avenue Elementary SchoolGrades: K-5Distance: 0.4 mi
- 7/10Franklin Ave Middle SchoolGrades: 6-8Distance: 0.8 mi
- 7/10Ramapo High SchoolGrades: 9-12Distance: 2 mi
Schools provided by the listing agent
- Elementary: Woodside Avenu
- Middle: Franklin Avenue
- High: Ramapo/Indian Hills
Source: NJMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- New Jersey
- Bergen County
- Franklin Lakes
- 07417
- 240 Green Ridge Rd





