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;

4050 Executive Drive
Palm Harbor, FL 34685

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3744
Agency: Century 21 Executive Team

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1995
Notes: Under contract-accepting backup offers. Prepare to be impressed! Located in the exclusive gated subdivision of Presidents's Landing in Lansbrook, this 4 bed/4bath corner lot is just under 1/2 an acre and situated on a quiet cul-de-sac. As soon as you step through the double-leaded glass front doors, you're immediately greeted by the dining room, formal living area with French doors leading to the lanai and pool area, modern staircase, and engineered hardwood flooring, which runs throughout the house. You quickly start to understand this home is something special. As you make your way to the kitchen, it just keeps getting better. The kitchen has been completely remodeled with Quartz countertops, huge island, stainless steel appliances, and custom slow closing shaker cabinets. It is open to the family room, making it as functional as it is beautiful. The family room itself is something to behold, with a ceiling that extends to the second floor, sliding glass doors overlooking the pool, a wall of picturesque windows, remodeled wood-burning fireplace, and a truly unique art niche. On the other side of the first floor, you'll find the remodeled full pool bath, office, and master suite. The master bedroom features custom dual walk-in closets and sliding glass door access to the lanai and pool. The master bath has also been completely remodeled with dual vanities, water closet, glass-enclosed shower stall, and freestanding tub. Upstairs, you'll find three more bedrooms, two bathrooms, and an enormous 400+ square foot bonus room with endless possibilities. One of the bedrooms has its own en suite bathroom, making it perfect for guests. Plantation shutters throughout the home, upstairs and down. The outdoor area is just as fantastic as the interior. Large covered lanai and heated saltwater pool, all completely screened in. The lush landscaping provides complete privacy, making you feel like you're at your own private resort. Roof is only seven years old. Lansbrook is one of the most desirable communities in Pinellas County, with its world-class golfing, miles of trails, multiple parks, tree-lined sidewalks, pickle ball, tennis, and private access with boat docks to 2500 acre Lake Tarpon, Pinellas County's largest. Incredible location with top-rated schools, shopping, restaurants, and easy access to the Gulf Beaches!
MlsNumber: T3517761


Listing Provided By: Century 21 Executive Team, original listing
Name: Century 21 Executive Team
Phone: (813) 961-8637
Office Name: CENTURY 21 EXECUTIVE TEAM
Office Phone: (813) 961-8637
Agent Name: Mike Bosko
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, 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

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;
Real Estate Expert Photo for Brian Cooper
Brian Cooper
ASCIIRealty Experts
Call Today!: (727) 351-2728

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App