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 = 375 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 = 375 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 = 375 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;

3810 Executive Drive
Palm Harbor, FL 34685
Linda Alexander with BHHS FLORIDA PROPERTIES GROUP, original listing - (727) 799-2227

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 4
Baths: Full: 4, ½: 3
Status: Active
SqFt: 5901 Square Feet
Agency: BHHS FLORIDA PROPERTIES GROUP
Agency Phone: (727) 799-2227

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: EXCEPTIONAL VIEWS overlooking a private pond and Lake Tarpon! Imagine finding a "Take your breath away location." This one-story brick estate home on 1.09 acres in gated President’s Landing is all about the views, privacy & a resort inspired lifestyle. NOT IN FLOOD ZONE. No flood damage from recent storms. Gated President’s Landing has its own lakefront park, boat ramp, and dock with boat slips for a modest fee upon availability, just a short walk away. 2018 roof. The pavered circle driveway leads to the Porte Cochere and entrance through double beveled glass entry doors into a grand foyer with marble floors. The spacious living room is perfect for entertaining with two seating areas, a propane gas fireplace, ample custom shelving for your most treasured art pieces, high ceilings, and French doors overlooking the massive lanai/pool/spa and water views. Also off the foyer is a stately office w/ fireplace, half bath, rich wood detailing, wainscoting and custom matching desk. The dining room comfortably seats 10-12. A half bath for guests off hall to kitchen. The island kitchen was refurbished with painted white cabinets, hardware, granite countertops, sink, and Jenn-Air stainless refrigerator. Large pantry off of kitchen houses a wall of added cabinets and second refrigerator. Kitchen opens to breakfast room and family room with refurbished bar, gas fireplace, built-ins for television and audio equipment, added projector & drop down theater screen, and wall of sliding glass doors overlooking pool. The master retreat is complete with wet bar, three-sided gas fireplace, sitting area, built-in entertainment center, two large walk-in closets, bath with jetted spa tub, refurbished white wood cabinets, newer hardware & fixtures, and water closet. Two guest bedroom suites with private bath, one has completely updated bath. 4th bedroom ensuite opens to pool and shares access to large pool bath. Exercise room can be 5th bedroom by adding closet. Laundry room with utility sink. The pool was resurfaced in 2017, stone decking added, and the summer kitchen w/ ice machine & mini frig was updated. Air-conditioned & tiled 3 car side load garage with 2 additional work rooms and a half bath. Located within the Lansbrook community with access to multiple parks including playground, sports fields, basketball court, and lakefront park with boat ramp and dock w/day slips. Also enjoy Lansbrook Golf Course and a YMCA. Enjoy beautiful area beaches and access to Tampa International Airport.
MlsNumber: --
ListingId: TB8332899


Listing Provided By: BHHS FLORIDA PROPERTIES GROUP, original listing
Phone: (727) 224-8952
Office Phone: (727) 799-2227
Agent Name: Linda Alexander
Disclaimer: Copyright © 2025 Stellar MLS. 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 = 375 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;
Sandy Castles
ASCIICastles Real estate
Call Today!: (727) 459-7500

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App