stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-05-08T15:02:01
        )

    [ml_number] => 2868188
    [price] => stdClass Object
        (
            [amount] => 225000
            [original] => 245000
            [last_changed_on] => 2025-07-07T11:30:01
        )

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

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

    [description] => Lakeside Comfort on 2+ Acres – 1075 Sandys Camp Rd Discover this beautifully updated retreat nestled on 2.07 serene acres just one mile from a public boat ramp and the historic Danville Ferry. With seasonal water views and thoughtful upgrades, this property offers the perfect mix of peace, charm, and convenience.  Major Upgrades Completed New roof (2016), HVAC (2020), and water heater (2023)—enjoy worry-free living with the essentials already done.  Chef-Inspired Kitchen Remodeled in 2020, the kitchen features live-edge black walnut countertops, pull-out shelving, an under-counter mixing stand, double ovens (lower with convection), and a farmhouse-style sink. The eat-in layout makes it a natural gathering space.  Updated Bathroom Relax in the newly remodeled bath with a sleek walk-in shower and built-in bench.  Outdoor Living Highlights Enjoy a 12x32 covered patio for gatherings and an upper deck off the master bedroom with a negotiable hot tub—perfect for soaking in nature or unwinding in the evening.  Workshop & Storage Galore The oversized garage includes cabinets, counters, and even its own toilet and shower with a separate water heater. A large workshop with commercial sink and counters is ideal for hobbies. Additional carports and a lean-to provide space for boats, campers, or extra storage.  Move-In Ready Retreat This lakeside home combines rustic charm with modern features and plenty of space to live, work, and play. Whether you’re looking for a peaceful primary residence or a weekend escape, this property checks every box.  Schedule your tour and come experience all that this lakeside gem has to offer.
    [location] => stdClass Object
        (
            [city] => Big Sandy
            [state] => Tennessee
            [postal_code] => 38221
            [county] => Benton County, TN
            [subdivision] => N/a
            [street] => stdClass Object
                (
                    [number] => 1075
                    [name] => Sandys Camp Rd
                    [full] => 1075 Sandys Camp Rd
                )

            [directions] => TN-147 W, Turn onto Sandys Camp Rd
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.303264
                    [longitude] => -87.976808
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.976808
                                    [1] => 36.303264
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [style] => Array
                (
                    [0] => Contemporary
                )

            [construction] => Array
                (
                    [0] => Aluminum Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1200
                    [source] => Assessor
                )

            [stories] => 1
            [built_in] => 1990
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

                    [baths] => stdClass Object
                        (
                            [full] => 1
                            [half] => 1
                        )

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

                )

            [features] => Array
                (
                    [0] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Range
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Detached
                    [1] => Driveway
                )

            [parking_spaces] => 1
            [features] => Array
                (
                    [0] => Storage Building
                )

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

                )

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

        )

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

    [office] => stdClass Object
        (
            [name] => Grateful Acres Realty
            [broker_id] => 3481
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => MaKenzie
                            [last] => Griffis
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 9313671584
                            [mobile] => 9315516127
                        )

                    [agent_id] => 72346
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2868188
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-08T19:02:01Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms1
  • Half Baths1
  • BasementCrawl Space
  • FeaturesPrimary Bedroom Main Floor
  • AppliancesOven, Range
  • HVACArray

    Exterior Details

  • StyleContemporary
  • ConstructionAluminum Siding
  • Built In1990
  • Stories1
  • ParkingDetached, Driveway
  • Garage Bays1
  • FeaturesStorage Building
  • SewerSeptic Tank
  • Acres2.07

Request Information