Skip main navigation
For sale
  • $1,350,000

    8820 S Hickory Ln, Riverview, FL 33578

    9beds
    5,410sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1988
    1.06 Acres Lot
    $1,257,000 Zestimate®
    $250/sqft
    $-- HOA

    What's special

    Ultimate waterfrontGated entryPrivate poolCovered boat liftFour master suitesOutdoor kitchenTwo-story dock
    Fully Renovated Ultimate Waterfront Investment Opportunity on the Alafia River! An unparalleled investment opportunity awaits on the stunning Alafia River! This income-producing, turn-key property features three separate buildings on over an acre of prime waterfront land, offering a total of 9 bedrooms, 7.5 bathrooms, and over 5,000 square feet of heated space. Whether you're seeking a lucrative Airbnb, a multi-generational compound, or an event-friendly retreat, this property is designed to impress. This exceptional property includes three distinct residences. The main home boasts spacious living areas with stunning river views, high-end finishes, and an entertainer's dream layout. The guest house is a private 3-bedroom, 2.5-bathroom residence complete with its own kitchen and laundry room. Additionally, there is a 1-bedroom studio apartment (not currently in the rental program) with potential for $1,000/month in additional income. Outdoor amenities set this property apart. A 175-ft, two-story dock features an upstairs sun deck, covered boat lift, fish cleaning station, shower, refrigerator, city water, and electricity. The property also includes three boat slips, available to rent for additional passive income ($1,000+/month potential). A private pool, outdoor kitchen, two 67-ft lanais with breathtaking river views, and multiple outdoor dining areas equipped with gas grills make this a true waterfront paradise. Plus, with no HOA or CDD, you have complete freedom over your investment. Luxury and entertainment abound throughout the home. Enjoy four master suites, each with en-suite bathrooms and walk-in showers. Additional features include an indoor hot tub, dry sauna, built-in HD projector, pool table, and fitness room. The property is also equipped with three fully furnished kitchens, three laundry rooms, and elegant touches such as stained glass accents. A 5-car garage, including a roundabout garage with dual doors, provides ample covered parking. A gated entry with an elegant fountain and expanded driveway ensures privacy and grandeur upon arrival. This property is a proven income producer with over $225,000 in gross annual revenue, even with a low occupancy rate. Future bookings already total $100,000, and $75,000 in furnishings are included. With the addition of a dedicated website, projections indicate an additional $100,000+ in yearly revenue. Its size and amenities make it a perfect venue for large family groups, weddings, and special events. Location is another key advantage. This home is minutes from Tampa Bay by boat, making it one of the closest riverfront properties to open water. It is also just 15 minutes from Busch Gardens, 20 minutes from Downtown Tampa, and offers easy access to I-75. Whether you are a boater, angler, or water sports enthusiast, the brackish waters of the Alafia River provide the ideal setting for fishing and kayaking. This is more than just a home—it's an unmatched investment and lifestyle opportunity. Whether you're looking to generate multiple income streams or secure a one-of-a-kind waterfront retreat, this property delivers on all fronts. Schedule your showing today and see firsthand why this Alafia River gem is a true Airbnb powerhouse!
    473 days
    |
    979
    |
    55
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Andrew Duncan 813-359-8990,

    LPT REALTY LLC 813-359-8990,

    Ben Turek 305-495-7806,

    LPT REALTY LLC

    Source: Stellar MLS,MLS#: TB8365558MLS LogoOriginating MLS: Suncoast Tampa

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 9
      • Bathrooms: 8
      • Full bathrooms: 7
      • 1/2 bathrooms: 1
      Rooms
      • Room types: Dining Room, Storage Rooms
      Primary bedroom
      • Features: Ceiling Fan(s), Walk-In Closet(s)
      • Level: Second
      • Area: 306 Square Feet
      • Dimensions: 18x17
      Kitchen
      • Features: Built-In Shelving, Granite Counters, Kitchen Island
      • Level: First
      • Area: 126 Square Feet
      • Dimensions: 14x9
      Living room
      • Features: Ceiling Fan(s)
      • Level: First
      • Area: 598 Square Feet
      • Dimensions: 26x23
      Heating
      • Central
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Electric Water Heater, Ice Maker, Microwave, Range, Refrigerator
      • Laundry: Laundry Closet, Laundry Room
      Features
      • Attic Fan, Ceiling Fan(s), Other, Solid Wood Cabinets, Stone Counters, Thermostat, Vaulted Ceiling(s), Walk-In Closet(s)
      • Flooring: Laminate, Marble, Tile
      • Doors: Outdoor Grill, Sliding Doors
      • Windows: Window Treatments
      • Has fireplace: No
      Interior area
      • Total structure area: 9,088
      • Total interior livable area: 5,410 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 6
      • Parking features: Covered, Driveway, Garage Door Opener, Guest, Off Street
      • Garage spaces: 2
      • Carport spaces: 4
      • Covered spaces: 6
      • Has uncovered spaces: Yes
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Deck, Rear Porch
      • Exterior features: Balcony, Outdoor Grill
      • Has private pool: Yes
      • Pool features: Above Ground
      • Fencing: Fenced
      • Has view: Yes
      • View description: Pool, Water
      • Water view: Water
      Lot
      • Size: 1.06 Acres
      • Dimensions: 169 x 182.27
      • Features: Flood Insurance Required
      • Residential vegetation: Fruit Trees, Trees/Landscaped
      Details
      • Additional structures: Residence, Guest House
      • Parcel number: U2330191R100000000008.5
      • Zoning: RSC-6
      • Special conditions: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Block, Stucco, Wood Frame
      • Foundation: Slab
      • Roof: Shingle
      Condition
      • New construction: No
      • Year built: 1988

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Public
      • Utilities for property: Cable Available, Electricity Connected, Fire Hydrant

      Community & HOA

      Community
      • Security: Closed Circuit Camera(s), Fire Alarm, Smoke Detector(s)
      • Pet fee: $0 monthly
      • Subdivision: SUBDIVISION OF THE E 2804 FT O
      HOA
      • Has HOA: No
      Location
      • Region: Riverview

      Financial & listing details

      • Price per square foot: $250/sqft
      • Tax assessed value: $1,091,928
      • Annual tax amount: $20,019
      • Date on market: 3/28/2025
      • Cumulative days on market: 462 days
      • Listing terms: Cash,Conventional,VA Loan
      • Ownership: Fee Simple
      • Total actual rent: 0
      • Electric utility on property: Yes
      • Road surface type: Other

        Estimated market value

        $1,257,000

        $1.19M - $1.32M

        $4,237/mo

        Price history

        DateEventPrice
        12/10/2025Price change$1,350,000-6.9%$250/sqft
        Source: Stellar MLS #TB8365558 Report a problem
        11/12/2025Price change$1,450,000-6.5%$268/sqft
        Source: Stellar MLS #TB8365558 Report a problem
        9/28/2025Price change$1,550,000-3.1%$287/sqft
        Source: Stellar MLS #TB8365558 Report a problem
        8/28/2025Price change$1,599,000-5.7%$296/sqft
        Source: Stellar MLS #TB8365558 Report a problem
        3/28/2025Listed for sale$1,695,000+106.7%$313/sqft
        Source: Stellar MLS #TB8365558 Report a problem
        11/1/2023Listing removed--
        Source: Stellar MLS #T3439112 Report a problem
        8/1/2023Sold$820,000-54.4%$152/sqft
        Source: Public Record Report a problem
        6/11/2023Listed for sale$1,799,950-10%$333/sqft
        Source: Stellar MLS #T3439112 Report a problem
        6/2/2023Listing removed--
        Source: Stellar MLS #T3439112 Report a problem
        4/13/2023Listed for sale$1,999,990+110.5%$370/sqft
        Source: Stellar MLS #T3439112 Report a problem
        2/17/2023Sold$950,000-18.7%$176/sqft
        Source: Public Record Report a problem
        6/29/2021Sold$1,169,000-1.7%$216/sqft
        Source: Stellar MLS #T3276912 Report a problem
        1/19/2021Listing removed--
        Source: Stellar MLS Report a problem
        1/3/2021Price change$1,189,000-0.8%$220/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        12/31/2020Price change$1,199,000-2.5%$222/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        12/16/2020Price change$1,229,900-1.6%$227/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        12/7/2020Price change$1,249,900-7.4%$231/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        12/2/2020Price change$1,349,900-3.6%$250/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        11/18/2020Listed for sale$1,399,900+16.8%$259/sqft
        Source: STAR BAY REALTY CORP. #T3276912 Report a problem
        4/2/2020Listing removed$1,199,000$222/sqft
        Source: STAR BAY REALTY CORP. #T2937697 Report a problem
        6/25/2018Price change$1,199,000-7.7%$222/sqft
        Source: STAR BAY REALTY CORP. #T2937697 Report a problem
        5/23/2018Price change$1,299,000-7.1%$240/sqft
        Source: STAR BAY REALTY CORP. #T2937697 Report a problem
        4/11/2018Listed for sale$1,399,000+55.6%$259/sqft
        Source: STAR BAY REALTY CORP. #T2937697 Report a problem
        1/2/2018Listing removed$899,000$166/sqft
        Source: THE K COMPANY REALTY #T2897716 Report a problem
        10/4/2017Price change$899,000-9.1%$166/sqft
        Source: THE K COMPANY REALTY #T2897716 Report a problem
        8/8/2017Listed for sale$989,000+106%$183/sqft
        Source: THE K COMPANY REALTY #T2897716 Report a problem
        7/22/2014Sold$480,000+1.1%$89/sqft
        Source: Stellar MLS #T2578423 Report a problem
        5/15/2014Listed for sale$475,000+1087.5%$88/sqft
        Source: CENTURY 21 Beggins Enterprises #T2578423 Report a problem
        5/20/1998Sold$40,000$7/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$21,083 +5.3%$1,091,928 0%
        2024$20,020 +1.5%$1,092,018 +1.5%
        2023$19,721 -4.4%$1,076,125 -4.9%
        2022$20,634 +53.3%$1,131,255 +61.8%
        2021$13,463 +10.7%$699,234 +10%
        2020$12,164 +1.6%$635,667 +1.7%
        2019$11,975 $625,016 +4.3%
        2018$11,975 +3.2%$599,360 +11.5%
        2017$11,608 +34.9%$537,778 +15.9%
        2016$8,604 +0.6%$464,063 +0.9%
        2015$8,554 +5.7%$459,761 +14.7%
        2014$8,090 $400,855 +4.5%
        2013$8,090 +110.2%$383,462 +75.4%
        2012$3,849 +3.2%$218,680 +3%
        2011$3,728 +2.6%$212,311 +1.5%
        2010$3,633 +2.8%$209,173 +2.7%
        2009$3,533 +3.8%$203,674 +0.1%
        2008$3,404 -3.9%$203,565 +6.3%
        2007$3,543 -5.3%$191,419 +2.5%
        2006$3,742 +5.9%$186,750 +8.4%
        2005$3,534 $172,273 +3%
        2004-- $167,255 +1.9%
        2003-- $164,136 +2.4%
        2002-- $160,289 +1.6%
        2001-- $157,765 -20.7%
        2000$3,255 $198,879
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 33578

        Getting around

        13 / 100
        Car-Dependent
        43 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Bing-HB
        • Middle: Giunta Middle-HB
        • High: Spoto High-HB

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

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes