Title Page Background
HFQUERY 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 = 3234 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3234 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3234 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

20180 Riverbrooke Run
Estero, FL 33928
Pamela D Olsen with Royal Shell Real Estate, Inc., original listing - (239) 261-9101

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,999,999
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5399 Square Feet
Agency: Royal Shell Real Estate, Inc.
Agency Phone: (239) 261-9101

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Architecturally beautiful custom home by Robert D' Angeleo on a very tranquil lot with serene nature and Western sunsets views. This is a one-of-a kind enclosed lanai that adds more living space year-round to cozy up to the gas fireplace or pull up a chair to the summer kitchen bar & do some grilling. It's surrounded by glass or you can open to be a screened lanai. The Chef's kitchen is a dream with an immense island surrounded by high-end appliances and walk-in pantry with double counters. The custom millwork is exquisite, the Travertine beveled edge tile throughout the living areas is prestigious along with plank wood flooring and the stunning ceilings are everywhere! 4 guest bedrooms are ensuite baths with walk-in closets. The lush private pool/spa area can be enjoyed by watching the big screen TV events or relaxing with the surround sound mode of the day. <br /> <br /> Come see this luxurious 5 bedroom, 5 and one half bath home with a private paneled study, plank wood flooring and a bonus secret closet. The lavish Primary Suite is its own wing with Bose surround sound system, glass french doors leading into the private retreat area, jetted tub, walk-in shower, walk-in closets, and custom vanities. Natural gas home has 2 tankless water heater and Pool & Spa Heat Pump & Heater. New Roof 2023, Interior Painting 2023, 3 Car Garage with Direct Auto LIft, Kinetico Reverse Osmosis Water System, Whole House Water Softener System, Cantera Iron & Glass Double Entry Doors, Private well for irrigation and 3 HVAC units with warranty & service agreements to new owner.<br /> <br /> This house was built for large scale entertaining.<br /> <br /> This is luxurious living that's simply unmatched with the abundant amenities that West Bay Club offer it's residence. You enjoy the private Beach Club on the Gulf of Mexico, as the lastest in dining options, along with the Aqua Cafe overlooking the Jr. Olympic community pool, hot tub, and fitness center. There is a River Park on the Estero River with kayaking and boat launching, Dog Parks, Tennis Centers, bocce, pickleball Park. There are optional memberhips to play the Pete & P.B. Dye designed golf course and associated dining options.
MlsNumber: --
ListingId: 224059241


Listing Provided By: Royal Shell Real Estate, Inc., original listing
Phone: (239) 464-6873
Office Phone: (239) 261-9101
Agent Name: Pamela D Olsen
Disclaimer: Copyright © 2024 Bonita Springs-Estero REALTORS. 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

HFQUERY 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 = 3234 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Jordan Smith
Jordan Smith
ASCIIPrecision Realty Group
Call Today!: (239) 788-1979

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App