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!
For sale
$1,350,000
8820 S Hickory Ln, Riverview, FL 33578
9beds
5,410sqft
Est.:
Single Family Residence
Built in 1988
1.06 Acres Lot
$-- Zestimate®
$250/sqft
$-- HOA
What's special
Ultimate waterfrontGated entryPrivate poolCovered boat liftFour master suitesOutdoor kitchenTwo-story dock
- 383 days |
- 1,430 |
- 78 |
Zillow last checked:
Listing updated:
Listing Provided by:
Andrew Duncan 813-359-8990,
LPT REALTY LLC 813-359-8990,
Ben Turek 305-495-7806,
LPT REALTY LLC
Source: Stellar MLS,MLS#: TB8365558
Originating MLS: Suncoast Tampa

Tour with a local agent
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,092,018
- Annual tax amount: $20,019
- Date on market: 3/28/2025
- Cumulative days on market: 372 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
Not available
Estimated sales range
Not available
$4,237/mo
Price history
| Date | Event | Price |
|---|---|---|
| 12/10/2025 | Price change | $1,350,000-6.9%$250/sqft |
Source: | ||
| 11/12/2025 | Price change | $1,450,000-6.5%$268/sqft |
Source: | ||
| 9/28/2025 | Price change | $1,550,000-3.1%$287/sqft |
Source: | ||
| 8/28/2025 | Price change | $1,599,000-5.7%$296/sqft |
Source: | ||
| 3/28/2025 | Listed for sale | $1,695,000+106.7%$313/sqft |
Source: | ||
| 11/1/2023 | Listing removed | -- |
Source: | ||
| 8/1/2023 | Sold | $820,000-54.4%$152/sqft |
Source: Public Record Report a problem | ||
| 6/11/2023 | Listed for sale | $1,799,950-10%$333/sqft |
Source: | ||
| 6/2/2023 | Listing removed | -- |
Source: | ||
| 4/13/2023 | Listed for sale | $1,999,990+110.5%$370/sqft |
Source: | ||
| 2/17/2023 | Sold | $950,000-18.7%$176/sqft |
Source: Public Record Report a problem | ||
| 6/29/2021 | Sold | $1,169,000-1.7%$216/sqft |
Source: Stellar MLS #T3276912 Report a problem | ||
| 1/19/2021 | Listing removed | -- |
Source: | ||
| 1/3/2021 | Price change | $1,189,000-0.8%$220/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 12/31/2020 | Price change | $1,199,000-2.5%$222/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 12/16/2020 | Price change | $1,229,900-1.6%$227/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 12/7/2020 | Price change | $1,249,900-7.4%$231/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 12/2/2020 | Price change | $1,349,900-3.6%$250/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 11/18/2020 | Listed for sale | $1,399,900+16.8%$259/sqft |
Source: STAR BAY REALTY CORP. #T3276912 Report a problem | ||
| 4/2/2020 | Listing removed | $1,199,000$222/sqft |
Source: STAR BAY REALTY CORP. #T2937697 Report a problem | ||
| 6/25/2018 | Price change | $1,199,000-7.7%$222/sqft |
Source: STAR BAY REALTY CORP. #T2937697 Report a problem | ||
| 5/23/2018 | Price change | $1,299,000-7.1%$240/sqft |
Source: STAR BAY REALTY CORP. #T2937697 Report a problem | ||
| 4/11/2018 | Listed for sale | $1,399,000+55.6%$259/sqft |
Source: STAR BAY REALTY CORP. #T2937697 Report a problem | ||
| 1/2/2018 | Listing removed | $899,000$166/sqft |
Source: THE K COMPANY REALTY #T2897716 Report a problem | ||
| 10/4/2017 | Price change | $899,000-9.1%$166/sqft |
Source: THE K COMPANY REALTY #T2897716 Report a problem | ||
| 8/8/2017 | Listed for sale | $989,000+106%$183/sqft |
Source: THE K COMPANY REALTY #T2897716 Report a problem | ||
| 7/22/2014 | Sold | $480,000+1.1%$89/sqft |
Source: Stellar MLS #T2578423 Report a problem | ||
| 5/15/2014 | Listed for sale | $475,000+1087.5%$88/sqft |
Source: CENTURY 21 Beggins Enterprises #T2578423 Report a problem | ||
| 5/20/1998 | Sold | $40,000$7/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 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
$8,708/mo
Principal & interest
$6683
Property taxes
$2025
More affordability tools
Climate risks
Neighborhood: 33578
Nearby schools
GreatSchools rating
- 4/10Bing Elementary SchoolGrades: PK-5Distance: 3.6 mi
- 2/10Giunta Middle SchoolGrades: 6-8Distance: 3.6 mi
- 3/10Spoto High SchoolGrades: 9-12Distance: 2.2 mi
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.
A local lender can help you make sure your offer is ready when you are.
- Florida
- Hillsborough County
- Riverview
- 33578
- 8820 S Hickory Ln





