stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Pending
            [last] => Active
            [changed] => 2025-06-14T23:41:00
        )

    [ml_number] => 2898344
    [price] => stdClass Object
        (
            [amount] => 270000
            [original] => 270000
            [last_changed_on] => 2025-06-02T20:33:00
        )

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

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

    [description] => This charming property offers a spacious backyard with a privacy fence—perfect for relaxing or entertaining. Enjoy the extra-large deck, ideal for gatherings, and a pool that can stay or go based on your preference. A brand-new stove is already in place, and a brand-new shed (still in the box) is available to stay or go as well. The window warranty transfers to the new owner for peace of mind. Best of all—NO HOA and your very own mailbox! This home truly has it all. A must-see!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Hazelwood
            [street] => stdClass Object
                (
                    [number] => 3709
                    [name] => Misty Way
                    [full] => 3709 Misty Way
                )

            [directions] => Trenton Rd to Hazelwood Rd. Make a right on Heather Dr and a right on Misty Way. Home will be on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.615649
                    [longitude] => -87.323061
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.323061
                                    [1] => 36.615649
                                )

                        )

                )

        )

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

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

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

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

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

                )

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

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [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 Faces Front
                )

            [parking_spaces] => 1
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 101
                            [acres] => 0.29
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-06-15T03:41:00Z
        )

    [office] => stdClass Object
        (
            [name] => Front Porch Realty & Property Management
            [broker_id] => 5016
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Joann
                            [middle] => L
                            [last] => Garcia
                        )

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

                    [agent_id] => 23838
                )

        )

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

                        )

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

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => Foyer welcomes you in
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Large living room with fireplace and vaulted ceilings
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/3/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => Tiled eat in kitchen with lots of natural lighting
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Brand new stove! The white cabinets really enhance the kitchen area
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/9/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => Huge primary bedroom with lots of natural light and a trey ceiling
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/14/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => Bedroom 2 has lots of space with an accent wall
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/19/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => Bedroom 3 has lots of space and accent wall
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/23/440x.jpg
                                )

                        )

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

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [description] => Beautiful, canopied area on the extended back deck. Perfect for quietly sitting or entertaining.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => Other side of the extended deck. Great for BBQs!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [description] => Large backyard with privacy fence
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/27/440x.jpg
                                )

                        )

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

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [description] => The pool can stay or go. Totally up to the new owner
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2898344/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2898344/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2898344/29/440x.jpg
                                )

                        )

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

                        )

                )

        )

    [selling_agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Ashley
                            [middle] => Nicole
                            [last] => Oppenborn
                        )

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

                )

        )

    [key] => rt-2898344
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-01T05:04:08Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesPrimary Bedroom Main Floor
  • AppliancesElectric Oven, Electric Range, Dishwasher, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionBrick, Vinyl Siding
  • Built In1996
  • Stories1
  • ParkingGarage Faces Front
  • Garage Bays1
  • SewerPublic Sewer
  • Lot Dimensions101
  • Acres0.29

Listing Brokerage: Front Porch Realty & Property Management
Listing Agent: Joann Garcia (931) 220-2557

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of June 19, 2025 8:01am. 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