G First Realty G First Realty
  • Home
  • About
    • Experience
    • Testimonials
  • Search
  • Listings
  • Communities
    • Dr Phillips
    • Hunters Creek
    • Kindred
    • Lake Nona
    • Tohquoa
    • Windermere
  • Agents
  • Contact
  • Home Search Workshop
  • Blogs
  • Home
  • About
    • Experience
    • Testimonials
  • Search
  • Listings
  • Communities
    • Dr Phillips
    • Hunters Creek
    • Kindred
    • Lake Nona
    • Tohquoa
    • Windermere
  • Agents
  • Contact
  • Home Search Workshop
  • Blogs

5023 W LEONA STREET, Tampa, FL 33629

$4,990,000

active

single

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.

Bedrooms
5
Bathrooms
6
Square feet
6996
Lot size
0.24
Year built
2025

Listing office: KELLER WILLIAMS TAMPA CENTRAL

Listing agent: Ally Russell

Agent license: 3513062

MLS listing: TB8562966

Source: Stellar MLS

Last updated: 2026-10-30T07:20:24.037Z

Listings courtesy of Stellar MLS as distributed by MLS GRID. 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. The use of the MLS GRID Data may be subject to an end user license agreement prescribed by the applicable MLS if any and as amended from time to timeBased on information submitted to the MLS GRID as of date and time noted. 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. Some IDX listings have been excluded from this website.The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint. Copyright 2026 My Florida Regional Multiple Listing Service DBA Stellar MLS. The real estate listing data marked with this icon comes from the IDX program of the Stellar MLS system. Listings displayed on this website may be subject to prior sale or removal from sale; availability of any listing should always be independently verified. Properties displayed may be listed or sold by various participants in the MLS. Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

Powered by CT IDX Pro+ & RealtyWatch Solutions.

G First Realty
G First Realty

Our real estate agents are committed to providing you with exceptional service. They are dedicated professionals and knowledgeable about the Florida real estate market. With extensive experience and a strong network, our agents work hard to find the perfect gem to call home. Read More

  • 4121 Neptune Rd
    St. Cloud, FL 34769
  • 407-593-0100
  • axel@gfirstrealty.com
Resources
  • Search
  • Listings
  • Communities
  • Agents
  • About
We offer you advice
  • Communities
  • Experience
  • Testimonials
  • MRP Certification
  • Agents
  • Contact

© 2025 G First Realty, All Rights Reserved. Back to top

  • List your Home
  • First Time Buyer Program

Log in

Don't have an account? Sign Up

Lost your password?

Create an account

Already have an account? Log In

I accept the Terms & Conditions

Lost Password?

Enter your email address and we'll send you a link you can use to pick a new password.