Main Photo

76 Photos

Main Photo
Main Photo

5023 W Leona Street Tampa, FL 33629

$4,990,000
Active / MLS# TB8562966 / Residential - Single Family / Tampa
5 Beds
5 Baths
1 Half Bath
6996 SqFt

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.

Read More » Read Less »

Baird & Warner New Client Care Team Agent Cell: 312.847.5702 Email

Mortgage Calculator

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Estimated Payment

$ 14,875.18 per month $12,839.85 Principal & Interest $579.92 Property Tax $1,455.42 Homeowner's Insurance
Get your competitive financing options.

Property Details

Property Type: Residential - Single Family
Cooling: Central Air
Garage: 10 car attached
Heating: Central, Electric, Gas
Lot Size: 0.24 Acres
Roof Type: Metal
Stories: 3.0
Taxes: $6,959
Year Built: 2025

Amenities

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
Balcony
Outdoor Kitchen

Feature Descriptions

Additional Rooms: Bonus Room, Den/Library/Office, Formal Dining Room Separate, Formal Living Room Separate, Loft, Storage Rooms
Appliances: Bar Fridge, Built-In Oven, Convection Oven, Cooktop, Dishwasher, Range Hood, Refrigerator, Tankless Water Heater, Wine Refrigerator
Builder: Modesta Homes LLC
Directions: Heading S on Westshore Blvd, turn right onto W Leona St, property is on the right
Exterior: Block
Fireplace: Living Room
Fireplace Y/N: Yes
Flood Zone Code: AE
Flooring: Carpet, Tile, Wood
Foundation: Slab
Home Warranty Y/N: No
Lot Dimensions: 0.24
Model: Custom
Ownership: Fee Simple
Pool: In Ground, Heated, Lighting, Salt Water
Property Attached Y/N: No
Property Sub-Type: Single Family Residence
Security: Security System, Smart Security System
Sewer: Public Sewer
Showing Instructions: Appointment Only, ShowingTime
Spa: Heated, In Ground
Special Sale Provisions: None
Swimming Pool: Yes
Utilities: Cable Available, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water: None
Water Access Y/N: No
Water View: Bay/Harbor - Partial
Zoning: RS-75

Room Information

Great Room: 21x29
Kitchen: 18x25
Dining Room: 23x18
Media Room: 19x23
Bedroom 2: 12x14
Primary Bedroom: 17x28
Bedroom 3: 16x21
Bedroom 4: 16x16
Bedroom 5: 13x14
Den: 12x14

Schools

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

Disclaimer: The accuracy of all information regardless of source, including but not limited to square footage and lot size, is deemed reliable but not guaranteed nor warranted and should be personally verified through personal inspection by and/or with the appropriate professionals.

Location

See details and scored characteristics about this location.

Listing Office: KELLER WILLIAMS TAMPA CENTRAL



Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial 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. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. 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.


Login to my Baird & Warner account