stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-02-14T13:13:02
        )

    [ml_number] => 2791708
    [price] => stdClass Object
        (
            [amount] => 419900
            [original] => 419900
            [last_changed_on] => 2025-02-14T13:13:02
        )

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

    [available_on] => stdClass Object
        (
            [$date] => 2025-02-14T05:00:00Z
        )

    [description] => *****This home qualifies for our Derby Deals promo! Up to $13k toward buyer incentives. Ask us how!*****  As with all Singletary homes, UPGRADES include Smart Home Technology, ceiling fans, crown molding, fenced in backyard and includes a one year builder's warranty. Welcome to the Hillsboro plan! This stunning home features a bright, open great room with a cozy fireplace. The generous dining area flows seamlessly into the country kitchen, which is equipped with granite countertops, an island, a pantry, and ample cabinet space. Upstairs, you'll find four spacious bedrooms, including a luxurious primary suite featuring two walk-in closets and a spa-inspired bathroom with a separate tub, a floor-to-ceiling tiled shower, and a double vanity. Additional highlights include a separate laundry room and a three-car garage, making this layout truly exceptional!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Charleston Oaks
            [street] => stdClass Object
                (
                    [number] => 2582
                    [name] => Rafiki Dr
                    [full] => 2582 Rafiki Dr
                )

            [directions] => From I24 take exit 1, left on Trenton Road, right onto Tiny Town Road, left onto Rafiki into neighborhood.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.624415
                    [longitude] => -87.391611
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.391611
                                    [1] => 36.624415
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Vinyl Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 2292
                    [source] => Builder
                )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Extra Closets
                    [2] => Walk-In Closet(s)
                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Disposal
                    [4] => Microwave
                )

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

                )

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

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => Public Sewer
                )

            [services] => Array
                (
                    [0] => Trail(s)
                )

            [parking] => Array
                (
                    [0] => Garage Faces Front
                )

            [parking_spaces] => 3
            [school] => stdClass Object
                (
                    [elementary] => Barkers Mill Elementary
                    [junior] => West Creek Middle
                    [high] => West Creek High
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-30T18:01:54Z
        )

    [office] => stdClass Object
        (
            [name] => Center Point Real Estate
            [broker_id] => 52468
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Chris
                            [last] => Holderman
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 2709916399
                            [mobile] => 2709916399
                            [fax] => 9316488551
                        )

                    [agent_id] => 57323
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Progress photo 3/29/25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2791708/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2791708/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2791708/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => Progress photo 3/29/25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2791708/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2791708/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2791708/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => Progress photo 3/29/25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2791708/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2791708/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2791708/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Progress photo 3/29/25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2791708/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2791708/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2791708/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => Progress photo 3/29/25
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2791708/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2791708/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2791708/4/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2791708
    [added_at] => stdClass Object
        (
            [$date] => 2025-02-14T18:13:02Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • Half Baths1
  • FeaturesCeiling Fan(s), Extra Closets, Walk-In Closet(s)
  • AppliancesElectric Oven, Electric Range, Dishwasher, Disposal, Microwave
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleContemporary
  • ConstructionBrick, Vinyl Siding
  • Built In2025
  • Stories2
  • ParkingGarage Faces Front
  • Garage Bays3
  • ServicesTrail(s)
  • SewerPublic Sewer

Listing Brokerage: Center Point Real Estate
Listing Agent: Chris Holderman (270) 991-6399

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 14, 2025 9:07pm. 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