Skip main navigation
Off market
  • $4,006,000

    18902 Lakes Edge Way, Odessa, FL 33556

    5beds
    7,291sqft
    Single Family Residence
    Built in 2001
    3.14 Acres Lot
    $4,006,000 Zestimate®
    $549/sqft
    $7,845 Estimated rent

    Home value

    $4,006,000

    $3.61M - $4.49M

    $7,845/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,845/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,845/mo

    Rent Zestimate®

    Refinance and save

    $27,780/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $27,780/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Welcome to Lake Mound Chateau at Stillwater. Centrally located, this private and secluded community is one of the most prestigious subdivisions in the Tampa Bay area. From the moment you approach this spectacular Estate, you will be captivated by the views of the Lake. The French architecture will transport you to Champagne and awaken memories of Provence. Seamlessly blending into the grand landscaping, the double entrance gates offer an additional layer of exclusive security and privacy. As you enter this move-in ready home, your eyes will be drawn to the warm marble floors and the architectural curved staircase .The coziness of the French country kitchen with distressed cabinetry adds character and charm to this family home. The floor to ceiling Great room windows offer serene views of the resort style saltwater pool and deck, native vegetation and over 600' of lake shore. The year-round natural indirect light makes this inviting floor plan a delight. The dream lake sunsets become a reality that will indulge your spirit daily. One of the many highlights of this home is the magnificent walk-in cellar with its red wood racking system worthy of the most treasured collection. With significant improvements over the years this property provides a balance of family, entertaining and nature, for a practical approach to Florida living. Included: a boat dock with a slip for your ski boat and floating deck for kayaking in addition to an exceptional board walk through the vast backyard. The observation tower allows you to appreciate nature at its best - look closely for the eagle's nest! Home generator. NEW tile roof completed in 2020. Homeowners retreat on the first level with lake views and fireplace. With the Upper Tampa Bay Trail for biking and hiking around the corner you will never be short of adventures. Abundance of Golf courses and proximity to the most pristine beaches in America make this home the ideal Paradise. One of the best values available. Check out the video and the 3D walkthrough to appreciate the layout and details. Make this your dream home.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Originating MLS: Tampa

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 6
    • Full bathrooms: 5
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Electric
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Garbage disposal, Refrigerator, Washer
    • Laundry: Laundry Room
    Features
    • High Ceiling(s), Master Bedroom Downstairs, Stone Counters, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Thermostat, Kitchen/Family Room Combo, Built in Features, Cathedral Ceiling(s), Central Vaccum, Vaulted Ceiling(s), Wet Bar
    • Flooring: Tile, Carpet, Hardwood
    • Windows: Window Treatments
    • Has fireplace: Yes
    • Fireplace features: Wood Burning, Family Room, Gas, Master Bedroom
    Interior area
    • Structure area source: Public Records
    • Total interior livable area: 7,291 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage - Attached
    Features
    • Levels: Two
    • Patio & porch: Deck, Patio, Wrap Around
    • Exterior features: Stucco, Brick
    • Pool features: Auto Cleaner, Gunite, Heated, In Ground, Salt Water, Lighting
    • Has spa: Yes
    • Spa features: In Ground
    • Fencing: Other, Masonry
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Lake
    • Body of water: MOUND LAKE
    Lot
    • Size: 3.14 Acres
    • Features: Cul-de-sac, Conservation Area
    • Residential vegetation: Mature Landscaping, Wooded
    Details
    • Additional structures: Boathouse, Gazebo, Cabana
    • Parcel number: 17271100J000000000020U
    • Zoning: PD
    • Other equipment: Generator

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    • Property subtype: Single Family Residence
    Materials
    • masonry
    • Roof: Tile
    Condition
    • Year built: 2001

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public, Well
    • Utilities for property: Sewer Connected, Cable Connected, Sprinkler Meter, Water Connected
    Green energy
    • Energy efficient items: Thermostat, Water Heater, Insulation, Windows, HVAC, Lighting
    • Indoor air quality: Non Toxic Pest Control
    • Water conservation: Whole House Water Purification, Drip Irrigation, Irrig. System-Drip/Microheads

    Community & neighborhood

    Security
    • Security features: Security System, Gated Community
    Community
    • Community features: On Site Laundry Available
    Location
    • Region: Odessa
    • Subdivision: STILLWATER PH 01

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $499 monthly
    • Amenities included: Playground, Clubhouse, Pool, Security, Gated, Tennis Court(s), Recreation Facilities
    • Services included: Community Pool, Security, Maintenance Exterior, 24-Hour Guard

    Other

    Other facts
    • Additional Parcels YN: 0
    • Appliances: Dishwasher, Disposal, Refrigerator, Built-In Oven, Convection Oven, Cooktop, Exhaust Fan, Microwave, Bar Fridge, Range Hood, Freezer, Water Softener, Water Filtration System
    • Association Amenities: Playground, Clubhouse, Pool, Security, Gated, Tennis Court(s), Recreation Facilities
    • Association Fee Requirement: Required
    • Attached Garage YN: 1
    • Available For Lease YN: 1
    • Additional Rooms: Formal Dining Room Separate, Media Room, Interior In-Law Suite
    • Community Features: Deed Restrictions, Playground, Gated Community, Fishing, Water Access
    • Construction Materials: Stucco, Brick
    • Cooling: Central Air
    • Country: US
    • Building Area Source: Public Records
    • Disclosures: Seller Property Disclosure, HOA/PUD/Condo Disclosure
    • Exist Lse Tenant YN: 0
    • Flooring: Carpet, Wood, Marble, Brick/Stone
    • Foundation Details: Slab
    • Garage YN: 1
    • Heating: Central
    • DPRYN: 0
    • Exterior Features: Irrigation System, Fenced, Rain Gutters, Sliding Doors, Outdoor Kitchen
    • Homestead YN: 1
    • Fireplace Features: Wood Burning, Family Room, Gas, Master Bedroom
    • Fireplace YN: 1
    • Interior Features: High Ceiling(s), Master Bedroom Downstairs, Stone Counters, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Thermostat, Kitchen/Family Room Combo, Built in Features, Cathedral Ceiling(s), Central Vaccum, Vaulted Ceiling(s), Wet Bar
    • Levels: Two
    • Listing Service: Full Service
    • Listing Terms: Cash, Conventional, VA Loan
    • Major Change Type: Pending
    • Mls Status: Pending
    • New Construction YN: 0
    • Ownership: Fee Simple
    • Parking Features: Garage Door Opener, On Street, Garage Faces Side, Guest, Circular Driveway, Golf Cart Garage
    • Patio And Porch Features: Deck, Patio, Wrap Around
    • Stories Total: 2
    • Pets Allowed: Yes
    • Previous Status: Active
    • Property Sub Type: Single Family Residence
    • Property Type: Residential
    • Utilities: Sewer Connected, Cable Connected, Sprinkler Meter, Water Connected
    • Vegetation: Mature Landscaping, Wooded
    • Sewer: Public Sewer
    • Syndicate To: Homes.com, HomeSnap, Realtor.com, International MLS
    • Water Source: Public, Well
    • Association Fee Frequency: Quarterly
    • Laundry Features: Laundry Room
    • Lease Restrictions YN: 1
    • Association Approval Required YN: 1
    • Association Fee Includes: Community Pool, Security, Maintenance Exterior, 24-Hour Guard
    • Pool Features: Auto Cleaner, Gunite, Heated, In Ground, Salt Water, Lighting
    • Pool Private YN: 1
    • Public Survey Section: 11
    • Room Count: 9
    • Security Features: Security System, Gated Community
    • Roof: Tile
    • View: Water, Greenbelt
    • Water View: Lake
    • Water View YN: 1
    • Zoning: PD
    • Spa Features: In Ground
    • Water Access YN: 1
    • Water Extras YN: 1
    • Waterfront YN: 1
    • County Or Parish: Hillsborough
    • Flood Zone Date: 2008-08-28
    • List Agent AOR: Tampa
    • List AOR: Tampa
    • Building Elevator YN: 0
    • Green Energy Efficient: Thermostat, Water Heater, Insulation, Windows, HVAC, Lighting
    • Minimum Lease: 8-12 Months
    • Window Features: Window Treatments
    • Num Of Own Years Prior To Lse: 1
    • Public Survey Range: 17
    • Water Access: Lake
    • Year Built: 2001
    • Disaster Mitigation: Above Flood Plain, Lightning Protection System
    • Lot Features: Cul-de-sac, Conservation Area
    • Waterfront Features: Lake
    • Direction Faces: Northeast
    • Water Extras: Lift, Boathouse, Dock - Wood, Assigned Boat Slip
    • Green Landscaping: Fl. Friendly/Native Landscape, Non Toxic Fertilizer/Pesticides
    • Other Structures: Boathouse, Gazebo, Cabana
    • Green Water Conservation: Whole House Water Purification, Drip Irrigation, Irrig. System-Drip/Microheads
    • Pet Restrictions: Verify with HOA
    • MLS Area Major: 33556 - Odessa
    • Additional Lease Restrictions: Verify with HOA
    • Approval Process: verify with HOA
    • Green Indoor Air Quality: Non Toxic Pest Control
    • Architectural Style: French Provincial
    • Other Equipment: Generator
    • Association Fee: 1499.00
    • Flood Zone Code: X/AE
    • Water Body Name: MOUND LAKE
    • Subdivision Name: STILLWATER PH 01
    • Waterfront Feet Total: 616
    • Fencing: Other, Masonry
    • Association Name: JAYNE ABSON
    • Tax Year: 2020
    • Total Acreage: 2 to less than 5
    • Building Area Total: 10784.00
    • Living Area: 7291.00
    • Tax Annual Amount: 31295.00
    • Virtual Tour URL Unbranded 2: https://my.matterport.com/show/?m=rFoHNtSca7v&mls=1
    • Water Frontage Feet Lake: 616
    • Listing terms: Cash, Conventional, VA Loan
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    1/25/2023Sold$3,500,000+0%$480/sqft
    Source: Public Record Report a problem
    1/13/2023Pending sale$3,499,900$480/sqft
    Source: Stellar MLS #T3422405 Report a problem
    1/12/2023Listed for sale$3,499,900+21.1%$480/sqft
    Source: Stellar MLS #T3422405 Report a problem
    5/7/2021Sold$2,889,800$396/sqft
    Source: Stellar MLS #T3286246 Report a problem
    4/13/2021Pending sale$2,889,800$396/sqft
    Source: Berkshire Hathaway HomeServices Florida Properties Group #T3286246 Report a problem
    4/10/2021Listed for sale$2,889,800$396/sqft
    Source: Stellar MLS #T3286246 Report a problem
    3/5/2021Pending sale$2,889,800$396/sqft
    Source: Stellar MLS #T3286246 Report a problem
    1/22/2021Listed for sale$2,889,800+3.2%$396/sqft
    Source: Stellar MLS #T3286246 Report a problem
    12/31/2020Listing removed--
    Source: Stellar MLS Report a problem
    6/30/2020Listed for sale$2,799,000-3.4%$384/sqft
    Source: FLORIDA EXECUTIVE REALTY #T3250955 Report a problem
    11/15/2019Listing removed$2,899,000$398/sqft
    Source: FLORIDA EXECUTIVE REALTY #T3167468 Report a problem
    4/8/2019Listed for sale$2,899,000-3.3%$398/sqft
    Source: FLORIDA EXECUTIVE REALTY #T3167468 Report a problem
    11/1/2018Listing removed$2,999,000$411/sqft
    Source: FLORIDA EXECUTIVE REALTY #T2913219 Report a problem
    8/13/2018Price change$2,999,000-6.3%$411/sqft
    Source: FLORIDA EXECUTIVE REALTY #T2913219 Report a problem
    4/16/2018Price change$3,199,000-8.6%$439/sqft
    Source: FLORIDA EXECUTIVE REALTY #T2913219 Report a problem
    11/10/2017Listed for sale$3,500,000+75%$480/sqft
    Source: FLORIDA EXECUTIVE REALTY #T2913219 Report a problem
    4/22/2002Sold$2,000,000$274/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$54,012 +3.8%$2,965,884 +0%
    2024$52,010 +11.1%$2,964,833 +9.7%
    2023$46,827 +2.5%$2,702,187 +3%
    2022$45,666 +44.7%$2,623,483 +47.5%
    2021$31,562 +0.9%$1,778,360 +1.4%
    2020$31,295 +1.5%$1,753,807 +2.3%
    2019$30,834 $1,714,376 +1.9%
    2018$30,834 +0.5%$1,682,410 -3.8%
    2017$30,685 +1%$1,749,479 +8.4%
    2016$30,386 +0.3%$1,613,914 +0.7%
    2015$30,285 -1%$1,602,695 +0.8%
    2014$30,595 $1,589,975 +1.5%
    2013$30,595 +0.1%$1,566,478 +1.7%
    2012$30,561 -1.7%$1,540,293 -1.4%
    2011$31,074 -11.6%$1,562,445 -12%
    2010$35,144 -11.1%$1,775,443 -10.5%
    2009$39,552 -5.7%$1,982,779 -5.2%
    2008$41,925 +3.6%$2,091,598 +3%
    2007$40,475 -6.5%$2,030,678 +2.5%
    2006$43,288 -0.4%$1,981,149 +3%
    2005$43,443 $1,923,446 +3%
    2004-- $1,867,423 +6.2%
    2003-- $1,758,492 -5.5%
    2002-- $1,860,021 +369.9%
    2001-- $395,840
    2000$9,528 $395,840

    Find assessor info on the county website

    Neighborhood: 33556

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Hammond Elementary School
    • Middle: Martinez-Hb
    • High: Steinbrenner High School

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $4,006,000
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $4,006,000