stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-06-10T10:46:00
        )

    [ml_number] => 2905624
    [price] => stdClass Object
        (
            [amount] => 325000
            [original] => 325000
            [last_changed_on] => 2025-06-10T10:46:00
        )

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

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

    [description] => If only you had A SWIMMING POOL for the summertime.. And a covered back deck to enjoy!! This 4 bedroom 3 bath split level home has plenty of room and 2 separate family rooms. Two car garage and mature trees. Come take a look and see what this home has to offer. NEW HVAC on 7/17/25 with 10 year warrranty.
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Summerhaven
            [street] => stdClass Object
                (
                    [number] => 3402
                    [name] => Queensbury Rd
                    [full] => 3402 Queensbury Rd
                )

            [directions] => Peachers Mill Rd to Tiny Town Rd - turn Left onto Tiny Town Rd - turn Right onto Allen Rd - turn Left onto Barbee Dr - Turn Right onto Queensbury Rd - House will be on the Left
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.636701
                    [longitude] => -87.388424
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.388424
                                    [1] => 36.636701
                                )

                        )

                )

        )

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

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

            [square_feet] => stdClass Object
                (
                    [size] => 1983
                    [source] => Owner
                )

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

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

                    [basement] => Array
                        (
                            [0] => Finished
                        )

                )

            [pool] => Array
                (
                    [0] => Above Ground
                )

            [appliances] => Array
                (
                    [0] => Range
                    [1] => Dishwasher
                    [2] => Disposal
                    [3] => Microwave
                    [4] => 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
            [features] => Array
                (
                    [0] => Storage Building
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.25
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-22T15:17:00Z
        )

    [office] => stdClass Object
        (
            [name] => Keller Williams Realty
            [broker_id] => 851
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Marshall
                            [last] => Stevenson
                        )

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

                    [agent_id] => 23220
                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => https://listings.cultivatedpropertytours.com/sites/3402-queensbury-rd-clarksville-tn-37042-16834286/branded
                )

            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => How about a swimming pool for the summer??
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2905624/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2905624/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2905624/0/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2905624
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-10T14:46:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • BasementFinished
  • AppliancesRange, Dishwasher, Disposal, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleRaised Ranch
  • ConstructionBrick, Vinyl Siding
  • Built In2006
  • Stories2
  • PoolAbove Ground
  • ParkingGarage Faces Front
  • Garage Bays2
  • FeaturesStorage Building
  • SewerPublic Sewer
  • Lot DescriptionHilly
  • Acres0.25

Listing Brokerage: Keller Williams Realty
Listing Agent: Marshall Stevenson (931) 206-1927

Listings courtesy of Realtracs as distributed by MLS GRID

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