5024 W LEONA STREET
Tampa, FL 33629
$9,650,000
Developed by Modesta Homes, this brand-new modern waterfront residence in Sunset Park offers 8,458 sq ft of air-conditioned living with 6 bedrooms, 6 full baths and a powder room on a canal-front lot with seawall in the heart of South Tampa. Two living levels rise above a 4,334 sq ft ground-level garage and storage area with two 16-foot overhead doors and parking for up to 12 cars, and a private elevator runs from the garage all the way to a rooftop viewing deck with open water views. The main level opens through a foyer and gallery with 11-foot ceilings to a two-story great room anchored by a floating steam fireplace, with floor-to-ceiling glass facing the water. The kitchen and breakfast room feature a large island with quartz counters, a 48-inch Wolf gas rangetop, Wolf double ovens, Sub-Zero panel-ready column refrigerator and freezer and a walk-in butler's pantry. This level also includes a formal dining room, home theater, wine room, a sitting and game room with wet bar and beverage center, two bedrooms each with a full bath (one ideal as an office), a powder room and three balconies, including one with an outdoor kitchen and grill. Upstairs, the primary suite has a private water-facing balcony, a dressing room with a center island and a spa bath with a freestanding soaking tub, curbless rain shower and dual vanities. A second primary suite with its own bath and balcony, two more bedrooms ...
+ Read More
Listing Courtesy of: KELLER WILLIAMS TAMPA CENTRAL
813-865-0700
| Listing Id: | TB8568239 |
|---|---|
| List Price: | $9,650,000 |
| Property Type: | Residential |
| Property Sub Type: | Single Family Residence |
| Status: | Coming Soon |
| Bedrooms Total: | 6 |
| Bathrooms Full: | 6 |
| Bathrooms Half: | 1 |
| Living Area: | 8,458 |
| Tax Annual Amount: | $24,308 |
| Lot Size Square Feet: | 10,854 |
| Lot Size Acres: | 0.25 |
| Architectural Style: | Contemporary |
| Waterfront?: | Yes |
| City: | Tampa |
| County Or Parish: | Hillsborough |
| Subdivision Name: | Madsen Isles |
| Postal Code: | 33629 |
| Year Built: | 2027 |
| Additional Parcels?: | No |
| Appliances: | Bar Fridge, Built-In Oven, Convection Oven, Cooktop, Dishwasher, Freezer, Gas Cooktop, Gas Water Heater, Microwave, Range Hood, Refrigerator, Tankless Water Heater, Wine Refrigerator |
| Builder Name: | MODESTA HOMES |
| Association Fee Frequency: | Annually |
| Attached Garage?: | Yes |
| Bathrooms Total Integer: | 7 |
| Building Area Source: | Builder |
| Building Area Total: | 14723 |
| Building Area Units: | Square Feet |
| Carport?: | No |
| Direction Faces: | North |
| Foundation Details: | Slab, Stilt/On Piling |
| Construction Materials: | Block, Stucco |
| Cooling: | Central Air, Zoned |
| Fireplace Features: | Living Room, Non Wood Burning |
| Directions: | Heading S on Westshore Blvd, turn right onto W Leona St, property is on the left |
| Elementary School: | Dale Mabry Elementary-HB |
| Exterior Features: | Balcony, Lighting, Outdoor Grill, Outdoor Kitchen |
| Flooring: | Tile, Wood |
| Furnished: | Unfurnished |
| Garage Spaces: | 12 |
| Garage?: | Yes |
| Community Features: | None |
| Heating: | Central, Electric, Heat Pump, Zoned |
| High School: | Plant-HB |
| Interior Features: | Built-in Features, Eat-in Kitchen, Elevator, High Ceilings, Open Floorplan, PrimaryBedroom Upstairs, Stone Counters, Walk-In Closet(s), Wet Bar |
| Laundry Features: | Inside, Laundry Room, Sink, Upper Level |
| Levels: | Multi/Split |
| Ownership: | Fee Simple |
| Living Area Source: | Builder |
| Living Area Units: | Square Feet |
| Lot Features: | FloodZone, City Limits, Landscaped, Paved |
| Lot Size Acres: | 0.25 |
| Lot Size Dimensions: | 75x145 |
| Postal Code Plus4: | 7623 |
| Middle Or Junior School: | Coleman-HB |
| MLS Area Major: | 33629 - Tampa / Palma Ceia |
| MLS Area Major: | 33629 - Tampa / Palma Ceia |
| Parcel Number: | A-32-29-18-D04-000000-00006.0 |
| Parking Features: | Driveway, Garage Door Opener, Ground Level, Oversized, Basement |
| Patio And Porch Features: | Covered, Patio |
| Pets Allowed: | Yes |
| Pool Features: | In Ground |
| Property Attached?: | No |
| Stories Total: | 3 |
| Township: | 29 |
| Road Surface Type: | Asphalt |
| Roof: | Membrane |
| Listing Terms: | Cash, Conventional |
| Tax Year: | 2025 |
| Senior Community?: | No |
| Sewer: | Public Sewer |
| Special Listing Conditions: | None |
| State Or Province: | FL |
| Association?: | Yes |
| Builder Model: | Custom |
| Utilities: | Cable Available, Electricity Available, Natural Gas Available, Sewer Available, Water Available |
| View: | Water |
| Water Source: | Public |
| Property Condition: | Completed |
| Public Survey Range: | 18 |
| Public Survey Section: | 32 |
| Zoning: | RS-75 |
| Spa Features: | In Ground |
| Spa?: | Yes |
| Waterfront Features: | Canal - Saltwater |
| Window Features: | Aluminum Frames, Storm Window(s) |
| Home Warranty?: | No |
| Additional Rooms: | Bonus Room, Den/Library/Office, Formal Dining Room Separate, Great Room, Inside Utility, Media Room, Storage Rooms |
| Alternate Key Folio Num: | 1226860222 |
| Association Approval Required Yn: | No |
| Association Fee Requirement: | Required |
| Available For Lease Yn: | Yes |
| Building Area Total Srch Sq M: | 1367.81 |
| Calculated List Price By Calcula: | 1140.93 |
| Cddyn: | No |
| Exist Lse Tenant Yn: | No |
| Flood Zone Code: | AE |
| Green Verification Count: | 0 |
| Homestead Yn: | No |
| Lease Restrictions Yn: | No |
| Listing Exclusion Yn: | No |
| Living Area Meters: | 785.77 |
| Lot Size Square Meters: | 1008 |
| Minimum Lease: | No Minimum |
| Monthly Hoa Amount: | $92 |
| Other Exemptions Yn: | No |
| Permit Number: | BLD-24-0507966 |
| Planned Unit Development Yn: | No |
| Pool Dimensions: | 35x14 |
| Realtor Info: | Floor Plan Available |
| Room Count: | 15 |
| Sdeo yn: | No |
| Total Acreage: | 1/4 to less than 1/2 |
| Total Annual Fees: | $1,100 |
| Total Monthly Fees: | $92 |
| Unit Number Yn: | No |
| Water Access: | Canal - Saltwater |
| Water Access Yn: | Yes |
| Water Extras: | Seawall - Concrete |
| Water Extras Yn: | Yes |
| Water Frontage Feet Canal Salt: | 75 |
| Waterfront Feet Total: | 75 |
| Water View: | Yes |
| Yrs Of Owner Prior To Leasing Re: | 0 |
| Zoning Compatible Yn: | Yes |
| Ag Exemption Yn: | No |
| Road Responsibility: | Public Maintained Road |
| Association Name: | Madsen Isles Homeowners Association, Inc. |
| Association 2 Yn: | 0 |
| Attribution Contact: | 813-865-0700 |
| Originating System Name : | Stellar MLS |
| Association Fee: | $1,100 |
| Community Association Water Features: | Canal Front, Water Access, Waterfront |
| Dock Description: | Dock - Slip Deeded On-Site, Lift |
| Dock Dimensions: | 40' x 41' |
| Dock Lift Capacity: | 20000 |
| Dock Maintenance Fee Frequency: | N/A |
| Dock Yn: | Yes |
| In Law Suite Yn: | No |
| Green Energy Generation Yn: | No |
| Listing Contract Date: | 2026-11-16 |
| 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 November 18, 2026 01:01 AM - ET
Based on information submitted to the MLS GRID as of November 18, 2026 01:01 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: November 18, 2026 01:01 AM - ET
