
5023 W LEONA STREET, TAMPA, FL, 33629
Active10 days on marketListed Oct 2, 2026MLS #TB8554417
About this home
5023 W LEONA STREET
The last off-water residence available in Madsen Isles, an exclusive eight-home South Tampa enclave with brick-paver streets, underground utilities and a quiet cul-de-sac setting. Developed by Modesta Homes and just completed, this coastal modern residence offers nearly 7,000 square feet of elevated living, open-water views from a private rooftop terrace, a four-stop elevator and an extraordinary eight-car garage. The scale is immediately apparent, with a dramatic 24-foot great room and foyer, 10-foot impact sliding glass doors and wide-plank brushed white oak flooring. A soaring tiled fireplace wall with a 360-degree floating fireplace creates a striking architectural focal point, while Level 5 drywall, 8-foot solid-core doors and custom lighting reflect the quality of finish throughout. The kitchen is distinctly custom, featuring built-to-order Luxor European frameless cabinetry that combines high-gloss finishes and natural walnut, dual islands wrapped in book-matched quartz waterfalls and a complete Sub-Zero and Wolf appliance package. A walnut butler's pantry extends the kitchen and provides additional space for entertaining. Designed for both large-scale entertaining and everyday living, the home includes a three-row theater with a 120-inch 4K screen, a temperature-controlled wine room, a bar and lounge, a private office, and a second-floor loft. The main living spaces open to a covered terrace with an outdoor kitchen overlooking the pool, sun decks, floating spa and fireplace. Above, the private rooftop terrace captures open-water views and creates another exceptional outdoor living space. The approximately 650-square-foot primary suite features a private balcony, nearly 400 square feet of separate closets and a spa-inspired bath with a 71-inch vessel soaking tub and dual rainfall showers. Four additional bedrooms complete the five-bedroom, five-and-one-half-bath layout. Equally considered behind the walls, the home was constructed for Florida living with masonry block on pilings, 8-inch core-filled walls, impact-rated windows and doors, spray-foam insulation and a TPO roof. A certified FEMA elevation certificate places the living floor and A/C equipment at 17.6 feet NAVD, an extra 6.6 feet above base flood elevation. Four-zone HVAC, 350-amp electrical service, tankless recirculating hot water and pre-wired security complete the systems. A rare combination of architectural scale, custom construction and resort-style living within one of South Tampa's most intimate new enclaves. Builder and manufacturer warranties transfer to the buyer at closing.
Facts & features
The home at a glance
5
Bedrooms
5.5
Bathrooms
6,996
Sqft
0.19 ac
Lot size
8
Garage
2025
Year built
Three Or More
Levels
$786
Per sqft
Inside
Outside & construction
Community & fees
Utilities & systems
The numbers
What it really costs
Built from this home's actual numbers — the most recent property-tax bill on record — not generic estimates.
$32,480 /mo · 10% down Conventional, 30-yr fixed at 6%
The assumptions
Above the FHA loan limit for our service areas, so Conventional is the default. VA buyers: switch below — $0 down.
These numbers assume a generic buyer — your credit, down payment and loan program change them. Get the real quote in minutes:

Andrew Acosta
Acosta Home Loans with PRMG · NMLS #1468866
Run your own numbers
FHA isn’t available at this price — the loan would exceed the $541,287 FHA limit for our service areas.
Estimated payment
$32,480/mo
Includes estimated PMI — it drops off once you reach 20% equity. Taxes reflect the most recent bill on record; insurance is a typical-Florida estimate. Your lender’s numbers will differ. CENTURY 21 Edge partners with Florida’s best lenders.
Value check
Is the price right?
The internet’s favorite home-value number comes from a single automated model that has never seen the street, the finishes, or the view — which is why it routinely misses by tens of thousands of dollars. The edgeAI estimate combines multiple independent data sources with our team’s on-the-ground expertise in this exact market.
vs edgeAI estimate
+54.6%
$/sqft vs Tampa actives
$786 vs $283
Days on market
10 vs 64 typical
Where $786/sqft sits among the 400 Tampa actives
The edgeAI estimate is a starting point, not an appraisal or a broker price opinion. It is generated from public records, listing data and market modeling, and is subject to change once a licensed real estate professional personally inspects the property. Condition, floor, view and lot are not fully captured by any model — ask us for a full comparative market analysis.
Where it sits
Inside Sunset Park
Drive times from this address
Estimated driving times, typical traffic. Data © OpenStreetMap contributors.
Get to know Tampa. See the full Tampa guide →
Sunset Park — neighborhood snapshot
Population
3,814
Median age
41
Median income
$170,940
Median home value
$1,159,534
Avg household
3
Households w/ children
479
For the school run
Hillsborough County School District
School assignments and ratings via edgeAI — always verify with the district.
The numbers that matter
The Tampa market
$413K → $430K
Tampa median sold, yr/yr
97.0%
Sale-to-list ratio (12 mo)
225 of 400
Tampa actives have cut their price
Median sold price, Tampa, trailing 36 months (3-month rolling) · live MLS data.
This home is listed 452% above the TAMPA 33629 median. See the full Tampa market guide →
Paper trail
This home's history
Reality check
What actually sold near 5023 W LEONA STREET
Asking prices are opinions — closed sales are facts. The most comparable homes that actually changed hands nearby in the last twelve months.
Sold · May ’26$4,600,000
3915 SNAPPER POINTE DRIVE
6 bd · 5 ba · 5,175 sqft · $889/sqft · 32 DOM
Sold · Jun ’26$2,400,000
3626 S BELCHER DRIVE
5 bd · 4.5 ba · 5,072 sqft · $473/sqft · 203 DOM
Sold · Mar ’26$2,500,000
4814 W EUCLID AVENUE
5 bd · 5.5 ba · 4,746 sqft · $527/sqft · 38 DOM
Closed-sale data from the MLS, last 12 months, selected for similarity in size and location. No two homes are identical — ask us for a full comparative analysis.
Your home team
The pros in your corner
Buying a home is two conversations — the home and the money. Here’s who handles each, side by side, already working together.
Your agent
Seth Cabrera - Rothschild
REALTOR® · CENTURY 21 Edge
Tours, negotiation, and every question about 5023 W LEONA STREET — start here.

Your lender
Andrew Acosta
Acosta Home Loans with PRMG · NMLS #1468866
Pre-approval, rates, and the real monthly number for 5023 W LEONA STREET — before you fall in love.
See it in person
Schedule a tour
Live availability from Seth's calendar — pick a time and it's booked. Confirmation lands in your inbox immediately.
Straight answers
5023 W LEONA STREET FAQs
What would the monthly payment be for 5023 W LEONA STREET?+
With 10% down on a 30-year Conventional loan at 6%, the all-in payment lands around $32,480/mo — principal and interest, the actual property-tax bill and typical Florida insurance. The payment calculator on this page lets you switch loan type (FHA, Conventional, VA) and adjust the down payment, rate and term.
What are the property taxes on 5023 W LEONA STREET?+
The most recent tax bill on record (2025) was $6,959. A new owner's bill can differ once the sale price resets the assessed value — we can walk you through what to expect.
How does the price compare to other homes in Tampa?+
At $5,500,000, this home is listed about 1164% above the Tampa median of $435,000. The market section on this page shows how the area is trending.
Which schools are assigned to 5023 W LEONA STREET?+
Coleman Middle School (middle), Mabry Elementary School (elementary), Plant High School (high), Patricia Sullivan Metropolitan Ministries Partnership School (elementary) — Hillsborough County School District. Always verify school assignments with the district before relying on them.
The brief
Three things that matter here
01Positioned at the premium end
$5,500,000 runs 452% above the TAMPA 33629 median — but at 6,996 sqft it's also nearly 4 times the size of the typical Tampa listing.
02Your own pool
A private pool — the feature Florida buyers ask for first, already in the ground and included in the price.
03Strong assigned schools
Coleman Middle School, Mabry Elementary School, Plant High School, Patricia Sullivan Metropolitan Ministries Partnership School — Coleman Middle School rates 5 of 5. Always verify assignments with the district.
Keep looking
Similar homes nearby
Listing courtesy of SMITH & ASSOCIATES REAL ESTATE · Katherine Glaser. MLS #TB8554417.
IDX information is provided exclusively 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. Data is deemed reliable but is not guaranteed accurate by Stellar MLS.
Never miss a listing
New Tampa homes, in your inbox
Like 5023 W LEONA STREET but not quite? A daily digest of every new listing in Tampa — straight from the MLS, hours after it goes live. Unsubscribe anytime.
Just watching this one home? Ask Seth to ping you on any price or status change →


