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;

9400 Reserve Pointe
Estero, FL 34135
Jane Jenkins with Premiere Plus Realty Co, original listing - (239) 732-7837

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,850,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4295 Square Feet
Agency: Premiere Plus Realty Co
Agency Phone: (239) 206-2777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: We welcome you to visit and enjoy Harbourside Custom Homes Villiano II former model Located in The most prestigious community of Shadow Wood at the Brooks ~GOLF AND COUNTRY CLUB~ a house that is quality outside and inside thus rendering the home timeless. A community that has many various types of non mandatory memberships available to accommodate owners lifestyles. The communities landscape and ongoing first class maintenance is a work of art. The lot where this home is built is just under an acre corner very private on all sides. A lot that is located in an enclave of large lots with different styles of magnificent homes. Towering Royal Palms, older mature oak tress, manicured lawns and green spaces with all landscaping precisely located as works of art!!<br /> <br /> <br /> The two story home of 4,295 SF of light and airy living space has 4 bedrooms plus office/den. The first floor consists of very large master bedroom and bath suite<br /> <br /> includes large his and hers built in closets. The entrance foyer, formal<br /> <br /> Dining and Formal Living room invitingly welcome people to come in! The private Living Room, open concept family room and kitchen all have sliding glass doors that pocket back completely into the wall and the entire back of the home opens up to the pool area.<br /> <br /> There are two very large en suite guest bedrooms rooms. The large laundry room is located near the entrance from the 3 car garage that is very large with extremely tall ceilings. There is plenty of storage in the attic over the garage and in the whole house as well. The upper level of the home is 715 sf of “get away from it all space” Wet Bar, a large movie theater/exercise room and en suite bedroom. An attached balcony shows off the long un obscured view of the two very large lakes, natural Florida trees, landscaping and rolling pasture looking grounds that is nothing less than glorious. The interior finishes of the home are crown moldings, beautiful baseboards, arches, ceiling details that are transitional and will adjust to any type of Interior Design. The owner of the home is a local award winning Interior Designer and within the ownership of the home has lovingly cared for and added window treatments, paint colors, wall coverings, new high end carpets in the bedrooms and numerous other things that one can see is premium quality thru out the entire home. The screened lanai and pool area are approximately 2000 sf. with Travertine deck, panorama view screens, grill area, separate bar serving area, outside gas fireplace, large pool with sun shelf, rock formations, large beautiful waterfall plus many different areas for enjoying meals and conversations makes this a memory making place for friends and families. The view from this lower level area is as I describer from the upper balcony. North East Exposure allows plenty of sun and shade as needed. Lake Views, palm trees, green space that invites birds and other beautiful critters in nature to come visit and stay awhile. You will love it!!!
MlsNumber: --
ListingId: 224046051


Listing Provided By: Premiere Plus Realty Co, original listing
Phone: (239) 980-5008
Office Phone: (239) 732-7837
Agent Name: Jane Jenkins
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App