Skip main navigation
Off market
  • $2,904,100

    18915 Lakes Edge Way, Odessa, FL 33556

    5beds
    5,835sqft
    SingleFamily
    Built in 1989
    1.2 Acres Lot
    $2,904,100 Zestimate®
    $498/sqft
    $7,951 Estimated rent

    Home value

    $2,904,100

    $2.64M - $3.19M

    $7,951/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,951/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,951/mo

    Rent Zestimate®

    Refinance and save

    $20,455/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

    $20,455/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

    This breath taking, newly built custom executive home is located in one of the most prestigious neighborhoods in the Tampa Bay area. Stillwater features only 48 homesites with over 114 acres of conservation and lakes with 24-hour guard gated access. Every detail of this custom home has up to date trends with so much attention to detail in all the custom molding, custom built-ins and amazing open layout. At over 5,800+ sq ft. this home features five bedrooms each with their own ensuite, an office, wine cellar, an upstairs and downstairs laundry room, a secret/safe room, a bonus work station, mudroom with custom lockers and a drop station, soaring two story living room all with stunning views of conservation. The completely custom kitchen features an oversized island, all Viking appliances, built in ice maker, floating shelves and a walk-in custom pantry. The master bedroom features a wall of windows that open to the outside lanai, all marble bathroom with cast-iron free-standing tub, a designer closet with island and laundry room. Custom built-ins throughout the home and including a custom oversized porch swing overlooking the pool and the oversized 1 acre+ yard. No expense was spared with all the designer light fixtures throughout from some of the best designers such as Restoration Hardware & Serena & Lily! Almost 3,000 sq ft of covered outdoor living space with a dedicated outdoor living room with fire place and an outdoor kitchen with an oversied island, built in grill, beer fridge and sink with an adjacent dedicated pool bath. The oversized pool (22x38) and spa also feature a sun shelf to enjoy all year! The home has both a water filtration system and reverse osmosis in the pantry. There is plenty of extra storage space in the oversized four car garages. The Upper Tampa Bay Trail for biking and hiking offers endless adventures and is within walking distance, new Greenwise Market, Chipotle and Panera all within 5 minute drive! All of this is located in the top rated Steinbrenner/Martinez/McKittrick school zones! Agent/Owner

    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.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 5
    • 1/2 bathrooms: 2
    Heating
    • Forced air, Electric
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Microwave, Refrigerator
    • Laundry: Inside, Laundry Room
    Features
    • High Ceiling(s), Master Bedroom Downstairs, Crown Molding, Walk-In Closet(s), In Wall Pest System, Thermostat, Pest Guard System
    • Flooring: Tile, Carpet, Hardwood
    • Basement: None
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 5,835 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Garage - Attached
    Features
    • Levels: Two
    • Patio & porch: Front Porch, Rear Porch
    • Exterior features: Cement / Concrete
    • Pool features: In Ground
    • Has spa: Yes
    • Has view: Yes
    • View description: Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 1.20 Acres
    • Dimensions: 152x337
    • Features: Cul-de-sac, Level/Flat
    • Residential vegetation: Mature Landscaping, Oak Trees
    Details
    • Parcel number: 17271100K000000000460U
    • Zoning: PD

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    Materials
    • masonry
    • Roof: Metal
    Condition
    • Pre-Construction
    • New construction: No
    • Year built: 1989

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Available, Public, Electricity Connected, Street Lights, Underground Utilities, Sprinkler Meter, Sewer Connected, Propane
    Green energy
    • Energy efficient items: Appliances, Thermostat, Windows, Water Heater, Lighting
    • Indoor air quality: Air Filters MERV 10+
    • Water conservation: Drip Irrigation, Low-Flow Fixtures, Irrig. System-Drip/Microheads

    Community & neighborhood

    Security
    • Security features: Gated Community, Security System
    Community
    • Community features: Doorman
    Location
    • Region: Odessa
    • Subdivision: STILLWATER PH 2

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $500 monthly
    • Amenities included: Fence Restrictions, Gated, Playground, Recreation Facilities, Tennis Court(s), Security, Park, Vehicle Restrictions, Cable, Clubhouse, Pool
    • Services included: Private Road, Recreational Facilities, Security, Community Pool, Common Area Taxes, 24-Hour Guard

    Other

    Other facts
    • Appliances: Dishwasher, Refrigerator, Cooktop, Microwave, Range Hood, Built-In Oven, Convection Oven, Exhaust Fan, Gas Water Heater, Tankless Water Heater
    • Architectural Style: Spanish/Mediterranean
    • Association Amenities: Fence Restrictions, Gated, Playground, Recreation Facilities, Tennis Court(s), Security, Park, Vehicle Restrictions, Cable, Clubhouse, Pool
    • Association Fee Includes: Private Road, Recreational Facilities, Security, Community Pool, Common Area Taxes, 24-Hour Guard
    • Association Fee Requirement: Required
    • Community Features: Association Recreation - Owned, Deed Restrictions, Gated Community, Playground, Tennis Courts, Park, Pool
    • Construction Materials: Stucco, Concrete
    • Cooling: Central Air, Zoned
    • Direction Faces: West
    • Exterior Features: Irrigation System, French Doors, Rain Gutters, Lighting, Sprinkler Metered
    • Flooring: Carpet, Ceramic Tile, Wood, Marble, Porcelain Tile
    • Foundation Details: Slab
    • Interior Features: High Ceiling(s), Master Bedroom Downstairs, Crown Molding, Walk-In Closet(s), In Wall Pest System, Thermostat, Pest Guard System
    • Heating: Zoned, Central
    • Levels: Two
    • Laundry Features: Inside, Laundry Room
    • Total Acreage: One + to Two Acres
    • Vegetation: Mature Landscaping, Oak Trees
    • Association Fee Frequency: Annually
    • Lot Features: Cul-de-sac, Level/Flat
    • Parking Features: Garage Door Opener
    • Utilities: Cable Available, Public, Electricity Connected, Street Lights, Underground Utilities, Sprinkler Meter, Sewer Connected, Propane
    • Property Type: Residential
    • Roof: Tile, Concrete
    • Security Features: Gated Community, Security System
    • Pets Allowed: Breed Restrictions
    • Disaster Mitigation: Hurricane Shutters/Windows, Above Flood Plain, Fire/Smoke Detection Integration
    • Green Energy Efficient: Appliances, Thermostat, Windows, Water Heater, Lighting
    • Green Water Conservation: Drip Irrigation, Low-Flow Fixtures, Irrig. System-Drip/Microheads
    • Minimum Lease: No Minimum
    • Property Condition: Pre-Construction
    • Other Fees Term: Annual
    • Pool Features: In Ground
    • Additional Parcels YN: 0
    • Available For Lease YN: 1
    • Flood Zone Code: X
    • Water Access YN: 0
    • Water Extras YN: 0
    • Waterfront Feet Total: 0
    • Waterfront YN: 0
    • Water View YN: 0
    • Fireplace YN: 1
    • Pool Private YN: 1
    • Association Approval Required YN: 1
    • Public Survey Range: 17
    • Zoning: PD
    • Room Count: 12
    • Public Survey Section: 11
    • Additional Lease Restrictions: Verify with HOA
    • Approval Process: verify with HOA
    • Pet Restrictions: Verify with HOA
    • Tax Year: 2018
    • Year Built: 2019
    • Flood Zone Panel: 12057C0039H
    • Garage Dimensions: 30x20
    • Other Fees Amount: 535
    • Garage Spaces: 3
    • New Construction YN: 1
    • Attached Garage YN: 1
    • Garage YN: 1
    • Association Fee: 1499.00
    • Living Area: 5002.00
    • DPRYN: 0
    • Patio And Porch Features: Front Porch, Rear Porch
    • Green Indoor Air Quality: Air Filters MERV 10+
    • Water Source: Public
    • Sewer: Public Sewer
    • Homestead YN: 0
    • Lease Restrictions YN: 1
    • Subdivision Name: STILLWATER PH 2
    • Association Name: Afroditi Rodriguez
    • Flood Zone Date: 2008-08-28
    • Tax Annual Amount: 3600.00
    • Lot Size Dimensions: 152x337

    Price history

    DateEventPrice
    12/31/2024Listing removed$2,500,000-5.7%$428/sqft
    Source: Stellar MLS #T3344537 Report a problem
    12/31/2023Listing removed--
    Source: Stellar MLS #T3344537 Report a problem
    3/25/2022Sold$2,650,000$454/sqft
    Source: Public Record Report a problem
    12/30/2021Sold$2,650,000+6%$454/sqft
    Source: Agent Provided Report a problem
    12/9/2021Pending sale$2,500,000$428/sqft
    Source: Stellar MLS #T3344537 Report a problem
    12/8/2021Listed for sale$2,500,000+696.7%$428/sqft
    Source: Stellar MLS #T3344537 Report a problem
    4/3/2020Sold$313,800-83.4%$54/sqft
    Source: Public Record Report a problem
    4/1/2020Price change$1,887,000+464.1%$323/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3205168 Report a problem
    2/13/2020Pending sale$334,500$57/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3225768 Report a problem
    2/13/2020Listed for sale$334,500-82.3%$57/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3225768 Report a problem
    1/2/2020Listing removed$1,887,000$323/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3205168 Report a problem
    12/28/2019Price change$1,887,000+722.9%$323/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3205168 Report a problem
    10/24/2019Price change$229,300-87.8%$39/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3121498 Report a problem
    10/17/2019Listed for sale$1,887,000+1261.5%$323/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3205168 Report a problem
    8/8/2018Sold$138,600-39.6%$24/sqft
    Source: Public Record Report a problem
    7/31/2018Listed for sale$229,300+11.3%$39/sqft
    Source: SMITH & ASSOCIATES REAL ESTATE #T3121498 Report a problem
    3/2/2018Listing removed$206,000$35/sqft
    Source: Premier Sotheby's International Realty #U7769332 Report a problem
    3/3/2017Price change$206,000-10%$35/sqft
    Source: Premier Sotheby's International Realty #U7769332 Report a problem
    3/5/2016Listed for sale$229,000+27.9%$39/sqft
    Source: PREMIER SOTHEBY'S INT'L REALTY #U7769332 Report a problem
    2/26/2015Listing removed$179,000$31/sqft
    Source: STILLWATER REALTY LLC (662500) #T2627156 Report a problem
    5/1/2014Listed for sale$179,000+258%$31/sqft
    Source: STILLWATER REALTY LLC #T2627156 Report a problem
    12/23/2013Sold$50,000-70.6%$9/sqft
    Source: Public Record Report a problem
    5/24/2013Price change$170,000+13.3%$29/sqft
    Source: STILLWATER REALTY LLC #T2514712 Report a problem
    4/21/2012Listed for sale$150,000-49%$26/sqft
    Source: STILLWATER REALTY LLC #T2514712 Report a problem
    10/20/2005Sold$294,200$50/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$42,173 +7.3%$2,317,235 +1.9%
    2024$39,297 -6.6%$2,273,728 -6.4%
    2023$42,079 +12.7%$2,429,185 +15.3%
    2022$37,353 +839.5%$2,106,458 +999.9%
    2021$3,976 +0.1%$191,517 -13%
    2020$3,972 -1%$220,136
    2019$4,012 $220,136 +13.3%
    2018$4,012 +11.4%$194,238
    2017$3,600 -1.1%$194,238 +5.7%
    2016$3,642 +1.7%$183,744 +10%
    2015$3,581 +9.4%$167,040
    2014$3,273 $167,040
    2013$3,273 -3%$167,040
    2012$3,376 -0.2%$167,040
    2011$3,383 +0.7%$167,040
    2010$3,360 -18.7%$167,040 -18.2%
    2009$4,133 -0.4%$204,160
    2008$4,151 -7.2%$204,160 -8.3%
    2007$4,472 -8.9%$222,720
    2006$4,908 +15.6%$222,720 +19.6%
    2005$4,245 $186,296
    2004-- $186,296 +20.8%
    2003-- $154,203
    2002-- $154,203 +9.1%
    2001-- $141,353
    2000$3,403 $141,353

    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
    $2,904,100
    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
    $2,904,100