stdClass Object
(
    [type] => Land
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-05-22T14:06:01
        )

    [ml_number] => 2888828
    [price] => stdClass Object
        (
            [amount] => 176800
            [original] => 176800
            [last_changed_on] => 2025-05-22T14:06:01
        )

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

    [description] => Red River Lot 2 offers +/- 6 acres of prime Tennessee countryside in Robertson County. Situated just 35 miles from Nashville, this property is surrounded by charming towns like Cedar Hill (3 miles), Adams (4 miles), Springfield (10 miles), and Clarksville (15 miles). The lot features +/- 350 feet of road frontage on Sturgeon Creek Road, making it easily accessible.  The back half of the property is adorned with beautiful hardwoods, creating a picturesque natural setting. Wildlife enthusiasts will appreciate the frequent visits from deer and turkey, adding to the property’s serene charm. City water and electricity are conveniently available at the road, ensuring modern utilities are within easy reach.  The front half of the tract is open, fertile farmland, perfect for creating the rural lifestyle of your aspirations.  Lifestyle and Amenities Red River Lot 2 is ideally located for those who want to enjoy both the peaceful countryside and close proximity to local attractions. The property is just a short distance from the Red River Public Boat Ramp, providing easy access to fishing, kayaking, and other water activities.  Nearby towns offer a welcoming community feel with unique local shops, delicious restaurants, and essential amenities. Whether you’re looking for recreational activities, a quiet retreat, or a connection to small-town charm, this property delivers on all fronts.  Potential Uses The possibilities are endless with Red River Lot 2. The fertile front portion of the land is perfect for a small farm or agricultural use. Alternatively, it’s an ideal site for a custom-built home, where you can create your own private retreat surrounded by the beauty of nature. Whether you’re aspiring for a peaceful family getaway, a hobby farm, or your forever home, this property is for you!
    [location] => stdClass Object
        (
            [city] => Cedar Hill
            [state] => Tennessee
            [postal_code] => 37032
            [county] => Robertson County, TN
            [street] => stdClass Object
                (
                    [number] => 0
                    [name] => Sturgeon Creek Road
                    [full] => 0 Sturgeon Creek Road
                )

            [directions] => From the intersection of Highway 41 and Keysburg Rd in Adams - take Highway 41 east for 1 mile to Johnson Springs Rd - take Johnson Springs Rd North for 1.3 miles to Sturgeon Creek Road - the property is approx 1.8 miles east on Sturgeon Creek Road
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.593358
                    [longitude] => -87.014733
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.014733
                                    [1] => 36.593358
                                )

                        )

                )

        )

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

        )

    [surroundings] => stdClass Object
        (
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 6.86
                        )

                    [description] => Array
                        (
                            [0] => Level
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Jo Byrns Elementary School
                    [junior] => Jo Byrns High School
                    [high] => Jo Byrns High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-05-22T18:06:01Z
        )

    [office] => stdClass Object
        (
            [name] => Compass South, Inc.
            [broker_id] => 5705
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jared
                            [middle] => D
                            [last] => Walker
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 8435386814
                            [mobile] => 8435757788
                        )

                    [agent_id] => 72422
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2888828
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-22T18:06:01Z
        )

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

    Exterior Details

  • Lot DescriptionLevel
  • Acres6.86

Listing Brokerage: Compass South, Inc.
Listing Agent: Jared Walker (843) 538-6814

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of June 6, 2025 9:31pm. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

This property information delivered from various sources that may include, but not be limited to, county records and the multiple listing service. Although the information is believed to be reliable, it is not warranted and you should not rely upon it without independent verification. Property information is subject to errors, omissions, changes, including price, or withdrawal without notice.

For issues regarding this website, please contact Eyesore at 678.692.8512.

Request Information