Sign up to get new listings emailed daily! JOIN SIGN IN
Stacey Olive
REALTOR®
Facebook Icon LinkedIn Icon Instagram Icon TikTok Icon 

5023 W Leona Street, Tampa, FL 33629

$4,990,000
  • 5023 W Leona Street, Tampa, FL 33629 Main Photo

76 Photos

New to the Market Active
BEDS5 BATHS5 full 1 partial SQUARE FEET6,996 MLS#TB8562966
STATUSActive PROPERTY TYPEResidential - Single Family SUBDIVISIONMADSEN ISLES

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.

5023 W Leona Street | MLS# TB8562966

This single family home located at 5023 W Leona Street, Tampa, FL 33629 is currently listed for sale with an asking price of $4,990,000. This property was built in 2025 and has 5 bedrooms and 5 full and 1 partial baths with 6996 sq. ft. W Leona Street is located in the MADSEN ISLES subdivision. Search MADSEN ISLES real estate on www.soldwithstacey.net today.

Property Features

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
Days on Site: 1
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 Sizes

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

Local Schools

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

Listed By / Shown By

Listed By

Agency Name: KELLER WILLIAMS TAMPA CENTRAL
Agency Contact: 813-865-0700

Shown By

Agent Name: Stacey Olive
Agent Phone: Cell: (440) 371-9126
Agency Title: Key Realty

IDX logo

Estimate Your Payment

Estimated Payment

$ 29,947.98 per month $27,912.64 Principal & Interest $579.92 Property Tax $1,455.42 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 10/31/2026. The listing information on this page last changed on 10/31/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Sat 10/31/2026 12:00:00 AM EST) or MichRic (Michigan Regional Information Center) (last updated Fri 10/30/2026 2:36:02 PM EST) or Metrolist - RECOLORADO by MLSGRID (last updated Fri 10/30/2026 11:34:29 PM EST) or MRED MLS (last updated Fri 10/30/2026 11:55:00 PM EST) or NIRA MLS (last updated Fri 10/30/2026 11:05:05 PM EST) or RealComp MLS (last updated Fri 10/30/2026 11:50:36 PM EST) or Dayton MLS (last updated Fri 10/30/2026 11:46:54 PM EST) or NORIS MLS (last updated Fri 10/30/2026 11:15:05 PM EST) or Colorado Real Estate Network IDX (last updated Fri 10/30/2026 7:05:16 PM EST) or CBRMLS (last updated Fri 10/30/2026 11:55:02 PM EST) or Multiple Listing Service of Greater Cincinnati (last updated Fri 10/30/2026 11:53:38 PM EST) or Terrehaute MLS (last updated Fri 10/30/2026 11:56:32 PM EST) or elevate MLS (last updated Fri 10/30/2026 11:44:57 PM EST) or Stellar MLS (last updated Fri 10/30/2026 11:54:56 PM EST) or NKY MLS (last updated Fri 10/30/2026 11:30:51 PM EST) or Wrist MLS (last updated Fri 10/30/2026 11:24:11 PM EST) or Firelands MLS (last updated Fri 10/30/2026 11:14:26 PM EST) or LCAR MLS (last updated Fri 10/30/2026 10:51:13 AM EST) or West Central MLS (last updated Fri 10/30/2026 9:54:36 PM EST) or Fort Myers (last updated Fri 10/30/2026 11:10:13 PM EST) or Aspen/Glenwood Springs MLS (last updated Fri 10/30/2026 9:30:41 PM EST) or Northern Nevada Regional MLS (last updated Fri 10/30/2026 11:56:49 PM EST) or MLS NOW (last updated Fri 10/30/2026 11:57:42 PM EST) or Northern Great Lakes Association of Realtors (last updated Fri 10/30/2026 11:49:18 PM EST) or Mansfield MLS (last updated Fri 10/30/2026 11:47:32 PM EST) or Metropolitan Indianapolis Board of Realtors (last updated Fri 10/30/2026 11:51:36 PM EST) or Grand Junction MLS (last updated Fri 10/30/2026 11:37:14 PM EST) or Knox County MLS (last updated Fri 10/30/2026 11:12:14 PM EST) or IRMLS (last updated Fri 10/30/2026 11:15:46 PM EST) or Upper Peninsula MLS (last updated Fri 10/30/2026 11:13:18 PM EST) or Greater Lansing MLS (last updated Fri 10/30/2026 10:41:09 PM EST) or SEBAR MLS (last updated Fri 10/30/2026 11:39:27 PM EST) or Water Wonderland MLS (last updated Fri 10/30/2026 10:55:34 PM EST) or Eastern Upper Peninsula MLS (last updated Fri 10/30/2026 11:01:59 PM EST) or Scioto Valley MLS (last updated Fri 10/30/2026 10:02:52 PM EST) or Northern Michigan MLS (last updated Fri 10/30/2026 9:40:12 PM EST). Real estate listings held by brokerage firms other than Key Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

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.



Privacy Policy / DMCA Notice / ADA Accessibility

Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598 | Illinois LIC# 481014661 640 S Washington St. Suite 212, Naperville, IL 60540



Agent License Information:  Brokerage/Company License Number: REC.2010002888

Login to My Homefinder