stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-05-09T14:48:01
        )

    [ml_number] => 2866560
    [price] => stdClass Object
        (
            [amount] => 399900
            [original] => 419900
            [last_changed_on] => 2025-07-17T11:01:00
        )

    [listing_flags] => Array
        (
            [0] => Existing
        )

    [available_on] => stdClass Object
        (
            [$date] => 2025-05-08T04:00:00Z
        )

    [description] => Jawdropping WATERFRONT views of the Tennessee River & Kentucky Lake on this fabulous well built home!! Currently being used as a 3-bedroom, making this the perfect FULLY FURNISHED turnkey Airbnb or short term rental (NOOSTR eligible), vacation, or permanent home! Wake up to the most stunning sunrises right from your deck, and enjoy the incredible views including Rockport Island, Duck River, New Johnsonville and beyond. This hidden gem sits on 1.43 acres in an adorable private, gated community with no HOA! Walking distance to put in a kayak or canoe down McCauleys Bluff Rd, only 2 miles from Birdsong Marina and public boat launch, and just 10-15 minutes from I-40. Improvements include new paint, living room furniture, new water heater, hvac serviced in March, new smart thermostat, new driveway, and a new well pump. Water bill is only $25 month from the community well, already paid in full for 2025.
    [location] => stdClass Object
        (
            [city] => Holladay
            [state] => Tennessee
            [postal_code] => 38341
            [county] => Benton County, TN
            [subdivision] => Riverbend Estates
            [street] => stdClass Object
                (
                    [number] => 270
                    [name] => Rockport Lndg
                    [full] => 270 Rockport Lndg
                )

            [directions] => From I40 @ EXIT 126 go North on Hwy 641. Go 1.7 mile turn right on Mcllwain Rd Go 0.3 mile turn left on Rockport Mcllwain Rd.Go 6.5 mile turn left on TN 191 N for 2.3 mile. Turn right on McCauleys Bluff Rd for 1.1 miles. Take right into Riverbend Estate
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.951684
                    [longitude] => -88.019838
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -88.019838
                                    [1] => 35.951684
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Vinyl Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1332
                )

            [stories] => 2
            [built_in] => 2014
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 2
                        )

                    [baths] => stdClass Object
                        (
                            [full] => 2
                        )

                    [basement] => Array
                        (
                            [0] => Crawl Space
                        )

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Open Floorplan
                    [2] => Smart Thermostat
                    [3] => Storage
                    [4] => Walk-In Closet(s)
                    [5] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Disposal
                    [2] => Dryer
                    [3] => Microwave
                    [4] => Refrigerator
                    [5] => Washer
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Central Air
                            [1] => Electric
                        )

                )

            [fireplaces] => stdClass Object
                (
                    [exists] => 
                )

        )

    [surroundings] => stdClass Object
        (
            [water] => Waterfront
            [sewer] => Array
                (
                    [0] => Septic Tank
                )

            [services] => Array
                (
                    [0] => Gated
                )

            [parking] => Array
                (
                    [0] => Attached
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 1.43
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Camden Elementary
                    [junior] => Camden Jr High School
                    [high] => Camden Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-17T15:01:00Z
        )

    [office] => stdClass Object
        (
            [name] => The Ashton Real Estate Group of RE/MAX Advantage
            [broker_id] => 3726
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Gary
                            [last] => Ashton
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6153011650
                        )

                    [agent_id] => 9616
                )

            [1] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jennifer
                            [last] => Roman
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159390086
                            [mobile] => 6159390086
                            [fax] => 8888036505
                        )

                    [agent_id] => 47516
                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => https://listings.real3dspace.com/videos/0196adb3-a222-739a-b9d4-d780d2661400
                )

            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/19/440x.jpg
                                )

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/20/440x.jpg
                                )

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/23/440x.jpg
                                )

                        )

                    [24] => stdClass Object
                        (
                            [position] => 24
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/24.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/24/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/24/440x.jpg
                                )

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/27/440x.jpg
                                )

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => Great locked storage area located just off the front porch!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/28/440x.jpg
                                )

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/29/440x.jpg
                                )

                        )

                    [30] => stdClass Object
                        (
                            [position] => 30
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2866560/30.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2866560/30/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2866560/30/440x.jpg
                                )

                        )

                )

        )

    [key] => rt-2866560
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-09T18:48:01Z
        )

    [source] => rt
    [self_link] => https://api.idx.io/listings/rt-2866560
)
			

    Interior Details

  • Bedrooms2
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Open Floorplan, Smart Thermostat, Storage, Walk-In Closet(s), High Speed Internet
  • AppliancesOven, Disposal, Dryer, Microwave, Refrigerator, Washer
  • HVACArray

    Exterior Details

  • ConstructionVinyl Siding
  • Built In2014
  • Stories2
  • ParkingAttached
  • ServicesGated
  • SewerSeptic Tank
  • Acres1.43

Request Information