Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (126)
    Mexico Listings (15)
    Advanced Search
Sell Find an Agent
BarrierFreeHome.com BarrierFreeHome.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BarrierFreeHome.com logo
Share
BarrierFreeHome.com logo
Ad #6104349
MLS #TB8554417
Listing photo

The last off-water residence available in Madsen Isles, an

5023 W LEONA St, Tampa, FL 33629
$5,500,000
5Beds
6Baths
6,996Sqft
0.19Acres

About this property

The last off-water residence available in Madsen Isles, an exclusive eight-home South Tampa enclave with brick-paver streets, underground utilities and a quiet cul-de-sac setting. Developed by Modesta Homes and just completed, this coastal modern residence offers nearly 7,000 square feet of elevated living, open-water views from a private rooftop terrace, a four-stop elevator and an extraordinary eight-car garage. The scale is immediately apparent, with a dramatic 24-foot great room and foyer, 10-foot impact sliding glass doors and wide-plank brushed white oak flooring. A soaring tiled fireplace wall with a 360-degree floating fireplace creates a striking architectural focal point, while Level 5 drywall, 8-foot solid-core doors and custom lighting reflect the quality of finish throughout. The kitchen is distinctly custom, featuring built-to-order Luxor European frameless cabinetry that combines high-gloss finishes and natural walnut, dual islands wrapped in book-matched quartz waterfalls and a complete Sub-Zero and Wolf appliance package. A walnut butler's pantry extends the kitchen and provides additional space for entertaining. Designed for both large-scale entertaining and everyday living, the home includes a three-row theater with a 120-inch 4K screen, a temperature-controlled wine room, a bar and lounge, a private office, and a second-floor loft. The main living spaces open to a covered terrace with an outdoor kitchen overlooking the pool, sun decks, floating spa and fireplace. Above, the private rooftop terrace captures open-water views and creates another exceptional outdoor living space. The approximately 650-square-foot primary suite features a private balcony, nearly 400 square feet of separate closets and a spa-inspired bath with a 71-inch vessel soaking tub and dual rainfall showers. Four additional bedrooms complete the five-bedroom, five-and-one-half-bath layout. Equally considered behind the walls, the home was constructed for Florida living with masonry block on pilings, 8-inch core-filled walls, impact-rated windows and doors, spray-foam insulation and a TPO roof. A certified FEMA elevation certificate places the living floor and A/C equipment at 17.6 feet NAVD, an extra 6.6 feet above base flood elevation. Four-zone HVAC, 350-amp electrical service, tankless recirculating hot water and pre-wired security complete the systems. A rare combination of architectural scale, custom construction and resort-style living within one of South Tampa's most intimate new enclaves. Builder and manufacturer warranties transfer to the buyer at closing.

Property Features

5 Beds
6 Baths
6,996 Sqft
Built in 2025
0.19 Acres
3 Stories
View Type: Harbor, Water
Underground/Basement, Driveway, Off Street, On Street, Open
Siding: Block, Stucco
Shingle Roof
Has Swimming Pool
Has Fireplace
Central, Zoned, Heat Pump (Heating)
$6,959 / yr property tax
Hillsborough County
MADSEN ISLES Community

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Katherine Glaser

Smith & Associates Real Estate

813-727-1198

Location

Map
Listing Agent: Katherine Glaser 813-727-1198
Broker: Smith & Associates Real Estate 813-839-3800 Listing Site
Copyright © 2026 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.
BarrierFreeHome.com
Printed Oct 23, 2026

Photo Gallery

The last off-water residence available in Madsen Isles, an - photo 1
The last off-water residence available in Madsen Isles, an - photo 2
The last off-water residence available in Madsen Isles, an - photo 3
The last off-water residence available in Madsen Isles, an - photo 4
The last off-water residence available in Madsen Isles, an - photo 5
The last off-water residence available in Madsen Isles, an - photo 6
The last off-water residence available in Madsen Isles, an - photo 7
The last off-water residence available in Madsen Isles, an - photo 8
The last off-water residence available in Madsen Isles, an - photo 9
The last off-water residence available in Madsen Isles, an - photo 10
The last off-water residence available in Madsen Isles, an - photo 11
The last off-water residence available in Madsen Isles, an - photo 12
The last off-water residence available in Madsen Isles, an - photo 13
The last off-water residence available in Madsen Isles, an - photo 14
The last off-water residence available in Madsen Isles, an - photo 15
The last off-water residence available in Madsen Isles, an - photo 16
The last off-water residence available in Madsen Isles, an - photo 17
The last off-water residence available in Madsen Isles, an - photo 18
The last off-water residence available in Madsen Isles, an - photo 19
The last off-water residence available in Madsen Isles, an - photo 20
The last off-water residence available in Madsen Isles, an - photo 21
The last off-water residence available in Madsen Isles, an - photo 22
The last off-water residence available in Madsen Isles, an - photo 23
The last off-water residence available in Madsen Isles, an - photo 24
The last off-water residence available in Madsen Isles, an - photo 25
The last off-water residence available in Madsen Isles, an - photo 26
The last off-water residence available in Madsen Isles, an - photo 27
The last off-water residence available in Madsen Isles, an - photo 28
The last off-water residence available in Madsen Isles, an - photo 29
The last off-water residence available in Madsen Isles, an - photo 30
The last off-water residence available in Madsen Isles, an - photo 31
The last off-water residence available in Madsen Isles, an - photo 32
The last off-water residence available in Madsen Isles, an - photo 33
The last off-water residence available in Madsen Isles, an - photo 34
The last off-water residence available in Madsen Isles, an - photo 35
The last off-water residence available in Madsen Isles, an - photo 36
The last off-water residence available in Madsen Isles, an - photo 37
The last off-water residence available in Madsen Isles, an - photo 38
The last off-water residence available in Madsen Isles, an - photo 39
The last off-water residence available in Madsen Isles, an - photo 40
The last off-water residence available in Madsen Isles, an - photo 41
The last off-water residence available in Madsen Isles, an - photo 42
The last off-water residence available in Madsen Isles, an - photo 43
The last off-water residence available in Madsen Isles, an - photo 44
The last off-water residence available in Madsen Isles, an - photo 45
The last off-water residence available in Madsen Isles, an - photo 46
The last off-water residence available in Madsen Isles, an - photo 47
The last off-water residence available in Madsen Isles, an - photo 48
The last off-water residence available in Madsen Isles, an - photo 49
The last off-water residence available in Madsen Isles, an - photo 50

$5,500,000

5
Beds
6
Baths
6,996
Sqft

5023 W LEONA St, Tampa, FL 33629

By contacting this agent you agree to these Terms and Conditions.
Home Florida Tampa
The last off-water residence available in Madsen Isles, an - photo 1
The last off-water residence available in Madsen Isles, an - photo 2
The last off-water residence available in Madsen Isles, an - photo 3
The last off-water residence available in Madsen Isles, an - photo 4
The last off-water residence available in Madsen Isles, an - photo 5
MLS# TB8554417
Home For Sale
Open House: Fri Oct 23, 4-6pm
$5,500,000

5023 W LEONA St, Tampa, FL 33629

5
Beds
6
Baths
6,996
Sqft
0.19
Acres
5 Beds
6 Baths
6,996 Sqft
0.19 Acres
Accessibility Features
Accessible Elevator Installed

The last off-water residence available in Madsen Isles, an

The last off-water residence available in Madsen Isles, an exclusive eight-home South Tampa enclave with brick-paver streets, underground utilities and a quiet cul-de-sac setting. Developed by Modesta Homes and just completed, this coastal modern residence offers nearly 7,000 square feet of elevated living, open-water views from a private rooftop terrace, a four-stop elevator and an extraordinary eight-car garage. The scale is immediately apparent, with a dramatic 24-foot great room and foyer, 10-foot impact sliding glass doors and wide-plank brushed white oak flooring. A soaring tiled fireplace wall with a 360-degree floating fireplace creates a striking architectural focal point, while Level 5 drywall, 8-foot solid-core doors and custom lighting reflect the quality of finish throughout. The kitchen is distinctly custom, featuring built-to-order Luxor European frameless cabinetry that combines high-gloss finishes and natural walnut, dual islands wrapped in book-matched quartz waterfalls and a complete Sub-Zero and Wolf appliance package. A walnut butler's pantry extends the kitchen and provides additional space for entertaining. Designed for both large-scale entertaining and everyday living, the home includes a three-row theater with a 120-inch 4K screen, a temperature-controlled wine room, a bar and lounge, a private office, and a second-floor loft. The main living spaces open to a covered terrace with an outdoor kitchen overlooking the pool, sun decks, floating spa and fireplace. Above, the private rooftop terrace captures open-water views and creates another exceptional outdoor living space. The approximately 650-square-foot primary suite features a private balcony, nearly 400 square feet of separate closets and a spa-inspired bath with a 71-inch vessel soaking tub and dual rainfall showers. Four additional bedrooms complete the five-bedroom, five-and-one-half-bath layout. Equally considered behind the walls, the home was constructed for Florida living with masonry block on pilings, 8-inch core-filled walls, impact-rated windows and doors, spray-foam insulation and a TPO roof. A certified FEMA elevation certificate places the living floor and A/C equipment at 17.6 feet NAVD, an extra 6.6 feet above base flood elevation. Four-zone HVAC, 350-amp electrical service, tankless recirculating hot water and pre-wired security complete the systems. A rare combination of architectural scale, custom construction and resort-style living within one of South Tampa's most intimate new enclaves. Builder and manufacturer warranties transfer to the buyer at closing.
20 days
on BarrierFreeHome.com
29
views
0
saves

Property Details

HOME DETAILS

5 Beds
6 Baths
6,996 Sqft
Built in 2025
0.19 Acres
3 Stories

BARRIERFREE ACCESS & VIEW

View Type: Harbor, Water

EXTERIOR

Underground/Basement, Driveway, Off Street, On Street, Open
Siding: Block, Stucco
Shingle Roof
Has Swimming Pool

INTERIOR

Has Fireplace
Central, Zoned, Heat Pump (Heating)

FINANCIAL & COMMUNITY

$6,959 / yr property tax
Hillsborough County
MADSEN ISLES Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
6104349
Viewed
29 times
Listing Status
Active
Added
Oct 02, 2026
Last Refreshed
Oct 22, 2026 05:59:50 PM

Listing Information

Data Source
Stellar MLS
Source Property ID
TB8554417
Listing Agent: Katherine Glaser 813-727-1198
Broker: Smith & Associates Real Estate 813-839-3800 Listing Site
Copyright © 2026 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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BarrierFreeHome.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.10.23
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Tampa

Read more
Sort By:
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Tampa Real Estate Agent Info

About Tampa

Click to activate
Request Information
By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.10.23
Terms & Policy