5023 W LEONA STREET
Tampa, FL 33629
$4,990,000
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 ...
+ Read More
Listing Courtesy of: KELLER WILLIAMS TAMPA CENTRAL
813-865-0700
| Listing Id: | TB8562966 |
|---|---|
| List Price: | $4,990,000 |
| Property Type: | Residential |
| Property Sub Type: | Single Family Residence |
| Status: | Active |
| Bedrooms Total: | 5 |
| Bathrooms Full: | 5 |
| Bathrooms Half: | 1 |
| Living Area: | 6,996 |
| Tax Annual Amount: | $6,959 |
| Lot Size Square Feet: | 10,454 |
| Lot Size Acres: | 0.24 |
| Waterfront?: | No |
| City: | Tampa |
| County Or Parish: | Hillsborough |
| Subdivision Name: | Madsen Isles |
| Postal Code: | 33629 |
| Year Built: | 2025 |
| Additional Parcels?: | No |
| Appliances: | Bar Fridge, Built-In Oven, Convection Oven, Cooktop, Dishwasher, Range Hood, Refrigerator, Tankless Water Heater, Wine Refrigerator |
| Builder Name: | Modesta Homes LLC |
| Attached Garage?: | Yes |
| Bathrooms Total Integer: | 6 |
| Building Area Source: | Builder |
| Building Area Total: | 12246 |
| Building Area Units: | Square Feet |
| Carport?: | No |
| Direction Faces: | South |
| Foundation Details: | Slab |
| Construction Materials: | Block |
| Cooling: | Central Air |
| Fireplace Features: | Living Room |
| Directions: | Heading S on Westshore Blvd, turn right onto W Leona St, property is on the right |
| Elementary School: | Dale Mabry Elementary-HB |
| Exterior Features: | Balcony, Outdoor Kitchen |
| Flooring: | Carpet, Tile, Wood |
| Furnished: | Unfurnished |
| Garage Spaces: | 10 |
| Garage?: | Yes |
| Heating: | Central, Electric, Gas |
| High School: | Plant-HB |
| 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, PrimaryBedroom Upstairs, Solid Surface Counters, Solid Wood Cabinets, Stone Counters, Thermostat, Tray Ceiling(s), Walk-In Closet(s), Window Treatments |
| Laundry Features: | Laundry Room |
| Levels: | Multi/Split |
| Ownership: | Fee Simple |
| Living Area Source: | Builder |
| Living Area Units: | Square Feet |
| Lot Size Acres: | 0.24 |
| Lot Size Dimensions: | 100x108 |
| Postal Code Plus4: | 7622 |
| Middle Or Junior School: | Coleman-HB |
| MLS Area Major: | 33629 - Tampa / Palma Ceia |
| MLS Area Major: | 33629 - Tampa / Palma Ceia |
| Original List Price: | $4,990,000 |
| Parcel Number: | A-32-29-18-D04-000000-00002.0 |
| Pool Features: | In Ground, Heated, Lighting, Salt Water |
| Stories Total: | 3 |
| Township: | 29 |
| Road Surface Type: | Asphalt, Brick |
| Roof: | Metal |
| Tax Year: | 2025 |
| Security Features: | Security System, Smart Security System |
| Senior Community?: | No |
| Sewer: | Public Sewer |
| Special Listing Conditions: | None |
| State Or Province: | FL |
| Association?: | No |
| Builder Model: | Custom |
| Utilities: | Cable Available, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected |
| Water Source: | None |
| Property Condition: | Completed |
| Public Survey Range: | 18 |
| Public Survey Section: | 32 |
| Zoning: | RS-75 |
| Spa Features: | Heated, In Ground |
| Spa?: | Yes |
| Additional Rooms: | Bonus Room, Den/Library/Office, Formal Dining Room Separate, Formal Living Room Separate, Loft, Storage Rooms |
| Alternate Key Folio Num: | 1226860214 |
| Available For Lease Yn: | No |
| Building Area Total Srch Sq M: | 1137.69 |
| Calculated List Price By Calcula: | 713.26 |
| Cddyn: | No |
| Exist Lse Tenant Yn: | No |
| Flood Zone Code: | AE |
| Green Verification Count: | 0 |
| Homestead Yn: | No |
| Listing Exclusion Yn: | No |
| Living Area Meters: | 649.95 |
| Lot Size Square Meters: | 971 |
| Permit Number: | BLD-24-0507615 |
| Room Count: | 10 |
| Sdeo yn: | No |
| Total Acreage: | 0 to less than 1/4 |
| Unit Number Yn: | No |
| Water Access Yn: | No |
| Water Extras Yn: | No |
| Water View: | Yes |
| Association 2 Yn: | 0 |
| Attribution Contact: | 813-865-0700 |
| Originating System Name : | Stellar MLS |
| In Law Suite Yn: | No |
| Green Energy Generation Yn: | No |
| Listing Contract Date: | 2026-10-29 |
| Fireplace?: | Yes |
| Pool Private?: | Yes |
| New Construction?: | Yes |
Mortgage Calculator
Copyright 2026 My Florida Regional MLS DBA Stellar MLS. All rights reserved. Information deemed reliable but is not guaranteed. The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of My Florida Regional MLS DBA Stellar MLS. Real estate listings held by brokerage firms other than the owner of this page include the name of the listing broker. Information provided is for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This site will be monitored for 'scraping' and any use of search facilities of data on the site other than by a consumer looking to purchase real estate is prohibited. Listing broker has attempted to offer accurate data, but buyers are advised to confirm all items. Information last updated on October 30, 2026 04:06 AM - ET
Based on information submitted to the MLS GRID as of October 30, 2026 04:06 AM - ET. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. Some listings have been excluded from this website.
IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time.
Property Last Updated: October 30, 2026 04:06 AM - ET











































































