stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-07-16T14:27:02
        )

    [ml_number] => 2942223
    [price] => stdClass Object
        (
            [amount] => 287000
            [original] => 287000
            [last_changed_on] => 2025-07-16T14:27:02
        )

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

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

    [description] => Immaculate 3-bedroom, 2-bath ranch located in a highly desirable neighborhood! This charming home features vaulted ceilings and a spacious eat-in kitchen with newer white appliances. The living area offers a cozy fireplace and a soft, neutral color palette—perfect as a blank canvas for your personal touch. The generously sized primary suite includes a walk-in closet, while two additional guest rooms provide plenty of space. Major updates include a new roof and HVAC system in 2019, offering peace of mind for years to come. Enjoy the large, level backyard with a brand-new deck and a 6-foot privacy fence—ideal for outdoor living and entertaining. The garage is spotless with fresh paint on the walls and floor, and an oversized bonus room provides the perfect flex space for a family room, office, or hobby area.
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Hazelwood
            [street] => stdClass Object
                (
                    [number] => 3822
                    [name] => McAllister Dr
                    [full] => 3822 McAllister Dr
                )

            [directions] => From i-24 Exit 1/Trenton Rd, head south down Trenton Rd, make a right onto Hazelwood Dr, then turn on a Right onto Man O War, then turn Left onto McAllister, home will be on the Left.
        )

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

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

            [square_feet] => stdClass Object
                (
                    [size] => 1625
                    [source] => Appraiser
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Entrance Foyer
                    [2] => Extra Closets
                    [3] => High Ceilings
                    [4] => Pantry
                    [5] => Walk-In Closet(s)
                    [6] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Freezer
                    [4] => Ice Maker
                    [5] => Microwave
                    [6] => Refrigerator
                )

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

                )

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

        )

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

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

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 0.24
                            [acres] => 0.24
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Pisgah Elementary
                    [junior] => Northeast Middle
                    [high] => Northeast High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-16T18:27:02Z
        )

    [office] => stdClass Object
        (
            [name] => Advantage REALTORS
            [broker_id] => 2648
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Karen
                            [middle] => C
                            [last] => Chiles
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 2708390972
                            [mobile] => 2708390972
                            [fax] => 2708857974
                        )

                    [agent_id] => 5368
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2942223
    [added_at] => stdClass Object
        (
            [$date] => 2025-07-16T18:27:02Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Pantry, Walk-In Closet(s), Primary Bedroom Main Floor
  • AppliancesOven, Electric Range, Dishwasher, Freezer, Ice Maker, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleRanch
  • ConstructionFrame, Vinyl Siding
  • Built In2005
  • Stories2
  • ParkingGarage Faces Front
  • Garage Bays2
  • SewerPublic Sewer
  • Lot DescriptionLevel
  • Lot Dimensions0.24
  • Acres0.24

Listing Brokerage: Advantage REALTORS
Listing Agent: Karen Chiles (270) 839-0972

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of August 7, 2025 10:46pm. 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