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

3820 Mckay Creek Drive
Largo, FL 33770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,009
Beds: 5
Baths: 3
Status: Active
SqFt: 2137
Agency: FUTURE HOME REALTY INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1967
Notes: Welcome to this COVETED HARBOR HILLS NEIGHBORHOOD in the A-rated Anona school zone, within minutes of GORGEOUS GULF BEACHES. This is a rare find with a DOUBLE LOT offering lots of possibilities. ENJOY LIVING ON THE INTRACOASTAL WITH ACCESS TO THE GULF, on an elevated/sloped lot that allows you to save money with NO FLOOD INSURANCE REQUIRED (please verify)! You will love this 3 WAY SPLIT FLOOR PLAN, with pocket doors for privacy, offering formal rooms or the opportunity to open the kitchen to a large open floor plan and screened lanai, overlooking a sparkling inground pool with spa, yet still plenty of space for gardening, and room to run and play in this SPACIOUS YARD with tropical landscape. The bonus is the BEAUTIFUL EXTRA LOT to build a new home on, build a guest home, she-shed, or the treehouse of your dreams (subject to county approval). Perfect opportunity for multigenerational living. This home has great bones and is ready for you to update and make it your own paradise. THE BIG-TICKET ITEMS ARE TAKEN CARE OF FOR YOU, BRAND NEW AC system, newer tile roof, energy efficient hurricane impact windows and heavy-duty sliders. This floorplan flows so nicely with 5 bedrooms, 2 and a half baths, and an oversized 2 car garage, allowing plenty of room for family and home offices (one has built in bookshelves for you), with plenty of space to expand if you like. Each lot has 70 foot frontage, with depths of 150 to 130 feet. Other features include well for irrigation, Low HOA fee, 30 feet of space for a future dock. Bring your builders, investors and creativity. The lots may be able to be split and sold separately (subject to county approval).
MlsNumber: T3510026


Listing Provided By: FUTURE HOME REALTY INC, original listing
Name: FUTURE HOME REALTY INC
Phone: (813) 855-4982
Office Name: FUTURE HOME REALTY INC
Office Phone: (813) 855-4982
Agent Name: Tom Lifrieri
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 = 3357 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 Sacha Haywood
Sacha Haywood
ASCIIImpact Realty Tampa Bay
Call Today!: (813) 312-6512

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App