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;

831 Mandalay Avenue
Clearwater, FL 33767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,695,000
Beds: 6
Baths: 8
Status: Active
SqFt: 3971
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: One or more photo(s) has been virtually staged. ONLY STEPS AWAY FROM THE BEACH -A COURTYARD-STYLE HOME THAT SLEEPS 20 GUESTS AND HAS A RENTAL HISTORY. BEGIN ENTERTAINING THE DAY YOU CLOSE BECAUSE THIS LUXURY HOME COMES FURNISHED. 3971 Sq ft, 6 BEDROOMS W/ ENSUITE BATHROOMS (8 bathrooms, total), AND 4 CAR GARAGE. Your journey begins at an ornate wrought iron door where you are greeted by an outdoor foyer adorned with a water fountain. Walk up the stairs to the second-floor sundeck, with an exquisite, heated pool and spa. This oasis is enveloped by a covered patio, equipped with motorized electric screens for ultimate comfort. A pool bath with a shower awaits your guests, ensuring convenience and enjoyment. Enter the home through French doors into the open kitchen boasting a skylight above the granite island that floods the area with natural light. Abundant storage is provided by endless maple cabinets, while stainless steel appliances, a gas stove, and a pantry cater to your every need. The spacious living/dining room features a magnificent wood plank ceiling and a built-in wall cabinet. After a day of lounging by the pool, your guests can unwind in the expansive media room, equipped with a surround sound speaker system. Tray and coffered ceilings create a soothing ambiance, enhancing the entertainment experience. The Owner's Suite offers a private sanctuary overlooking the pool complete with a custom walk-in closet, his and her vanities featuring three backlit vanity mirrors, and a spacious shower A double master bedroom offers an area for an office or flex room. On the first floor is a dormitory that sleeps 6 guests along with 3 more bedrooms on the 3rd floor. In the evening, the rooftop terrace awaits, offering panoramic views of the Gulf and breathtaking sunsets—a perfect setting for dining and relaxation. This move-in-ready residence has been thoughtfully updated, featuring fresh interior and exterior paint, along with new flooring, including luxury vinyl plank and Berber carpet. The property is equipped with plantation shutters, a central vacuum system, a water softener, a tankless water heater, video surveillance, a security system, and wind-rated windows for your peace of mind. With a four-car tandem garage providing ample space for a golf cart, boat, and guest parking. Put the car away, because this home is a 5-minute golf cart ride to the heart of America's Famous Clearwater Beach and the renowned restaurants, shopping, and Clearwater Beach Pier. Tampa International Airport and St. Pete-Clearwater Airports are only 30 minutes away. Floor plan available, buyer and buyer's agent to verify the square footage.
MlsNumber: U8217051


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 883-8509
Office Name: EXP REALTY LLC
Office Phone: (888) 883-8509
Agent Name: Robin Svoboda
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App