stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-06-19T01:02:07
        )

    [ml_number] => 2915310
    [price] => stdClass Object
        (
            [amount] => 305000
            [original] => 315000
            [last_changed_on] => 2025-06-25T12:07:00
        )

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

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

    [description] => Motivated seller and NO HOA! This charming 3-bedroom, 2.5-bathroom home offers everything you could want and boasts incredible curb appeal. You won't find another like it, featuring an eat-in kitchen, a formal dining area, and updated bathrooms. Enjoy an oversized deck and large, private backyard with shed for extra storage New roof installed in 2021. Cozy up by the fireplace and settle into your new home, conveniently located right off Exit 1, near movies, dining, and just minutes from Fort Campbell. Schedule a private showing today!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Hazelwood
            [street] => stdClass Object
                (
                    [number] => 1287
                    [name] => Cheryl Ct
                    [full] => 1287 Cheryl Ct
                )

            [directions] => From Hazelwood Rd turn onto Heather Dr, then turn right on Misty Way then right on Cheryl Ct. house is the first on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.615691
                    [longitude] => -87.321121
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.321121
                                    [1] => 36.615691
                                )

                        )

                )

        )

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

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

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

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

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

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

                )

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

            [appliances] => Array
                (
                    [0] => Range
                    [1] => Dishwasher
                    [2] => Microwave
                    [3] => Refrigerator
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Front
                    [2] => Concrete
                    [3] => Driveway
                )

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 100
                            [acres] => 0.37
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-06-25T16:07:00Z
        )

    [office] => stdClass Object
        (
            [name] => Redfin
            [broker_id] => 3525
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jennifer
                            [last] => Bowers
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6156894654
                            [mobile] => 6156894654
                        )

                    [agent_id] => 53813
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2915310
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-19T05:02:07Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Entrance Foyer, Extra Closets, Walk-In Closet(s)
  • AppliancesRange, Dishwasher, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleTraditional
  • ConstructionAluminum Siding, Brick
  • Built In1996
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Front, Concrete, Driveway
  • Garage Bays2
  • FeaturesStorage Building
  • SewerPublic Sewer
  • Lot DescriptionLevel
  • Lot Dimensions100
  • Acres0.37

Listing Brokerage: Redfin
Listing Agent: Jennifer Bowers (615) 689-4654

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 8:09pm. 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