Ohio: 937-907-6777 Florida: 727-300-2111

Property Details

Start of property details

Share this property:
5023 W LEONA STREET
Tampa, FL 33629
7 days ago NEW · Active
$4,990,000
$713 / Sqft
5
Beds
6
Baths
10
Garage
6,996
Sqft
0.24
Acres
MLS# TB8562966
Cumulative Days on Market: 172 · Includes prior listings · Currently listed since 10/30/26 · Data provided by the MLS.

Property Description

Set at the end of a quiet dead-end street in Madsen Isles, this 2025 custom home by Modesta Homes offers nearly 7, 000 sq ft of living space with 5 bedrooms and 5.5 baths. Highlights include a private pool and spa, a rooftop terrace with open-water views, a 4-stop elevator and a 10-car collector’s garage. The 24-foot great room has wide-plank white oak floors, a 360-degree floating fireplace and 10-foot sliders that open to the outdoor living area, with Level 5 drywall and 8-ft solid-core doors throughout. The kitchen features custom Luxor European cabinetry in high-gloss and walnut, dual islands wrapped in book-matched quartz waterfalls, Sub-Zero and Wolf appliances, a hidden pantry and a walnut butler’s pantry. The main level also includes a temperature-controlled wine room, a bar and lounge, a theater with a 120-inch 4K screen, and a guest suite with a full bath. Upstairs, the 650 sq ft primary suite has a private balcony, nearly 400 sq ft of closet space across two walk-ins, and a spa bath with a 71-inch vessel soaking tub and dual rainfall showers. Each of the three additional bedrooms has its own bath, and this floor also includes an office and a laundry room. Outside, a covered terrace with an outdoor kitchen and fireplace overlooks the pool, floating spa and sun decks. The home was built for Florida with masonry block on pilings, 8-inch core-filled walls, impact-rated windows and doors and spray-foam insulation, and a FEMA elevation certificate places the living floor at 17.6 ft NAVD, 6.6 ft above base flood elevation. Four-zone HVAC, 350-amp electrical, tankless recirculating hot water and pre-wired security complete the systems, and builder and manufacturer warranties transfer at closing. The location puts South Tampa’s best within easy reach while keeping the privacy of a tucked-away enclave. It’s minutes from International Plaza, Westshore dining and shopping, and Tampa International Airport, with Hyde Park Village, Bayshore Boulevard and downtown Tampa a short drive away. The home is also zoned for some of the area’s top-rated public schools.

Property Highlights

Property Type
Residential
Property Sub Type
Single Family Residence
Bedrooms
5
Total Bathrooms
6
Living Area
6,996 Sqft
Price / Sqft
$713
Acres
0.24
Year Built
2025
Condition
Completed
Cumulative Days on Market
172

Location

Area
33629 - Tampa / Palma Ceia
City/Township
TAMPA
Direction Faces
South
Water View
Yes
Subdivision
MADSEN ISLES
County
Hillsborough
Zoning
RS-75

Lake/Waterfront Information

Water View
Yes

Property Details

Price
$4,990,000
Condition
Completed
Property Type
Residential
Property Sub Type
Single Family Residence
Flood Zone Code
AE

Building

Levels
Multi/Split
Stories
3
Total Area
12,246 Sqft

Community

Local Schools

Elementary School
Dale Mabry Elementary-HB
Middle School
Coleman-HB
High School
Plant-HB

Interior Features

Bedrooms and Bathrooms

Total Bathrooms
6
Full Bathrooms
5
1/2 Bathrooms
1
Bedrooms
5

Area and Spaces

Living Area
6,996 Sqft

Appliances

Appliances
Bar Fridge, Built-In Oven, Convection Oven, Cooktop, Dishwasher, Range Hood, Refrigerator, Tankless Water Heater, Wine Refrigerator

Interior Features

Interior Features
Built-in Features, Ceiling Fans(s), Coffered Ceiling(s), Eat-in Kitchen, Elevator, High Ceilings, Kitchen/Family Room Combo, Living Room/Dining Room Combo, Open Floorplan, Other, Primary Bedroom Upstairs, Solid Surface Counters, Solid Wood Cabinets, Stone Counters, Thermostat, Tray Ceiling(s), Walk-In Closet(s), Window Treatments
Flooring
Carpet, Tile, Wood
Laundry Features
Laundry Room
Security Features
Security System, Smart Security System
Fireplace Features
Living Room
Furnished
Unfurnished

Heating and Cooling

Heating Features
Central, Electric, Gas
Has Fireplace
Yes

Building Details

Construction

Builders Model
Custom
Builder
Modesta Homes LLC
Year Built
2025
New Construction
Yes
Foundations
Slab

Materials

Construction Materials
Block
Roof
Metal

Terms

Terms

Ownership
Fee Simple
Special Conditions
None
Cumulative Days on Market
172

Taxes

Tax

Tax (Annual)
$6,959.09

Heating, Cooling & Utilities

Cooling Features
Central Air

Utilities

Utilities
Cable Available, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Sewer
Public Sewer
Water Source
None

Lot

Acres
0.24
Lot Size Area Sq Ft
10,454
Lot Dimensions
100x108
Road Surface
Asphalt, Brick

Exterior Features

Exterior Features
Balcony, Outdoor Kitchen

Parking

Garage Capacity
10

Pool Features

Has Private Pool
Yes
Pool Features
In Ground, Heated, Lighting, Salt Water
Spa
Yes
Spa Features
Heated, In Ground
Listed by Keller Williams Tampa Central, 813-865-0700
Listing Data last updated 11/06/2026 10:40 am
Get a Link to this Property: Copy To Clipboard

Phone:
Connect with:

Payment Calculator

per month. fixed. % interest.
$
%
$
%
Principal & Interest
+ Home Insurance
+ Property Tax
+ HOA Fees
per month
Total interest paid over s will be:
All estimates and provided for informational purposes only. Actual amounts may vary. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. Information, rates, programs and loan scenarios shown are for example only as of 6-Nov-2026 and are subject to change without notice. Interest rates provided by the St. Louis Federal Reserve Economic Data (FRED). All products are subject to credit and property approval. Not all products are available in all states or for all loan amounts. Other restrictions and limitations apply. Contact your preferred lender for the pricing associated with your specific transaction. Calculations are generated by Open Source mortgage calculation software tools using common mathematical formulas. All calculations should be independently verified.
Get Walk Score Content

Property History

Today
Property information last updated
7 days ago
Status Active. This is the most recent date the listing was placed on market.
Cumulative Days on Market: 172 days (includes prior listings) · Currently listed since October 30, 2026. Data provided by the MLS.

Similar Properties

Recent Posts