Title Page Background
DEBUG FN args: Array ( [0] => 3470 [1] => [2] => [3] => agent ) BEFORE: Site: 3470 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3470 Igate: njhud LocID: 3470 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3470 AND i.igate IN ('njhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3470 [1] => [2] => [3] => lender ) BEFORE: Site: 3470 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3470 Igate: njhud LocID: 3470 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3470 AND i.igate IN ('njhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3470 [1] => [2] => [3] => other ) BEFORE: Site: 3470 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3470 Igate: njhud LocID: 3470 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3470 AND i.igate IN ('njhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

154 E Saddle River Road
Saddle River, NJ 07458
Jenny Lindberg with Keller Williams Village Square Realty, original listing - (201) 445-4300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: --
Agency: Keller Williams Village Square Realty
Agency Phone: (201) 445-4300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Other
Year Built: --
Notes: This is the one! This spectacular and secluded 5BR Estate is set on 2 acres with 9ft+ Ceilings in bucolic Saddle River with TREMENDOUS SURROUNDING VALUE. Not to be missed is the amazing, just renovated Gourmet Kitchen with inset cabinetry featuring newly updated 12ft quartz island, new SubZero Fridge, new Wine Fridge, new Lighting and newer 48in Thermador Range and Bosch D/W, as well as many other updates. The Kitchen also features spacious Breakfast Room with French Doors to the Patio while the adjacent DR will easily accommodate large gatherings. Of course the focal point of this stunning residence is the 2-story, sun-drenched Great Rm featuring a Wall of Windows, FPL + French Doors to the Paver Patio...ideal for indoor/outdoor entertaining! Rounding out the main level is the 2-story Foyer, FLR, Game Rm (w/FPL), Office, Guest BR w/FBA & Laundry. On the upper level, we proceed to the OVERSIZED MBR Suite w/FPL + Tray Ceiling, 2-WIC + Lux MBA w/Jacuzzi & Steam Shower. This level also feat. 3 addl BRs (PLUS XL BONUS RM/Gym) + 2 addl FBAs. Hwd Floors thru-out. Central Vacuum. Half home repainted. Updated mechanicals. New ADT Alarm. BBQ gas line. Prof Landscaped w/ Lighting & Sprinklers. Addl feat. incl. Whole House Generator & 3-car Garage. 2.5mi to NYC Train. Paradise Awaits!
MlsNumber: --
ListingId: 25017236


Listing Provided By: Keller Williams Village Square Realty, original listing
Phone: (201) 390-7900
Office Phone: (201) 445-4300
Agent Name: Jenny Lindberg
Disclaimer: Copyright © 2025 New Jersey MLS Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => bergen-west [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: bergen-west State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: bergen-west State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3470 AND i.igate IN ('njhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Dee Canikligil
ASCIICorcoran Infinity Properties
Call Today!: (917) 544-9554

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => bergen-west [3] => NJ [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: bergen-west State: NJ Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: bergen-west State: NJ Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3470 AND i.igate IN ('njhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Lanie Conklin NMLS#106499
Lanie Conklin NMLS#106499
ASCIITotal Mortgage
Call Today!: (917) 532-4416

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App