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;

2295 Mackenzie Court
Clearwater, FL 33765

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,900
Beds: 4
Baths: 5
Status: Pending
SqFt: 5075
Agency: Re/Max Response

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: Under contract-accepting backup offers. Extraordinary! A rare find in exclusive, gated Coachman Hill Preserve. Magnificent executive estate home custom built by Marconi Homes and elegantly designed with style and grace! Experience the ultimate in luxurious living. Nearly 5,600 sq. ft. of stunning sophistication and style on a premium homesite of nearly an acre! Four bedrooms, plus a study, 4.5 baths, 6 car garage with motor court and true custom design with a long list of designer appointments. The enchanting elevation, with stone accents, brings you to a charming front porch beckoning you to relax and count your blessings. Enter and be greeted by soaring ceilings and oversized rooms in this unique home. The formal living and dining areas are heightened by soaring ceilings… beautiful! And the family living area will take your breath away! Stunning cherry wood BEAMS and coordinating built-ins are joined by a stone accent wall and gas fireplace giving this gathering space a character of its own. The room looks out thru French doors to the lanai retreat waiting outside. The kitchen is open to all and boasts spectacular, staggered cherry wood cabinetry, topped with crown molding and a butler’s pantry accented with Italian seeded glass doors for an amazing effect. Granite counters and top of the line stainless appliances are the perfect finish. The kitchen has a center working island as well as a breakfast bar. The ideal layout for family living and grand entertaining. The beautiful architecture continues into the enormous bonus room with the continuation of the cherry wood built-ins and well-situated wet bar. This room is a has a cozy mood and offers endless possibilities. The primary suite offers a sitting area and posh ensuite bath with a double vanity, water closet, soaking tub, walk-in shower and walk-in closet. Secondary bedrooms are massive and boast beautiful accents. Two of the bedrooms have charming window seats and share a jack and jill style bath! The other offers a wonderful ensuite bath of its own. All have walk-in closets and added lighting. The upstairs also offers a loft space and custom cabinet linen center. The entertaining and family space is extended outdoors with a magnificent oasis… a beautiful lanai and large, picturesque pool and spa with a built-in wood burning fireplace offering tranquil ambience. A true outdoor sanctuary! Backyard is fully fenced presenting an ideal play area for children and fur babies! Endless features… 22KW Generac generator, central vacc, 2020 Aqualink pool system, Wolfe poolside grill, custom lighting, 2 Subzero refrigerators, tankless water heater, epoxy garage floor, too many to mention and lavish convenience prevails with a laundry room on each floor! Coachman Hill Preserve is a prestigious community of just 10 custom homes and located within minutes of fine and fun dining, shopping, hiking and biking trails, entertainment including the Phillies baseball complex and the gorgeous white sand beaches of the Gulf Coast! Quick access to airports. Stylish, estate style living. Come discover this one-of-a-kind, remarkable home. Luxurious… ESTATE style living
MlsNumber: U8233864


Listing Provided By: Re/Max Response, original listing
Name: Re/Max Response
Phone: (727) 443-6700
Office Name: RE/MAX REALTEC GROUP INC
Office Phone: (727) 789-5555
Agent Name: Nancy Leslie
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