stdClass Object
(
    [type] => Rental
    [status] => stdClass Object
        (
            [current] => Pending
            [last] => Active
            [changed] => 2025-04-10T17:17:00
        )

    [ml_number] => 2815350
    [price] => stdClass Object
        (
            [amount] => 2800
            [original] => 2800
            [last_changed_on] => 2025-04-08T18:22:00
        )

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

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

    [description] => (AVAILABLE JUNE 1ST) Beautiful Executive home in Farmington (Kirkwood schools) ~ 4 bed / 3 bath plus bonus room ~ Open floor plan on main level boasts Living room with coffered ceiling and view of tree lined backyard ~ Check out this Kitchen with Farm sink, SS Appliances, white shaker cabinets, granite counters, large Island and custom pantry ~ Dining room that leads out to Screened in patio makes entertaining easy ~ Primary suite on main level offers soaker tub, large tiled shower, walk in closet and double vanities ~ 2 additional bedrooms on main level with custom paint colors and accent walls with full bathroom ~ Laundry on main next to mud room/ drop station off garage ~ All bedroom windows have custom wood shutter style blinds ~ Extra storage everywhere you look ~ Upstairs offers 4th bedroom, full bathroom and bonus room ~ Fenced back yard with stamped concrete patio and storage shed ~ 2 Car garage ~ HOA includes trash service ~ Application & qualifications can be found on our website: www.queencityrealty.us ~ Call to schedule a showing!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37043
            [county] => Montgomery County, TN
            [subdivision] => Farmington
            [street] => stdClass Object
                (
                    [number] => 2693
                    [name] => Remington Trce
                    [full] => 2693 Remington Trce
                )

            [directions] => From Rossview Rd ~ turn Left into Farmington (Pressler Way) ~ turn Right on Fantasia Way ~ turn Left on Remington Trace ~ Home is on the Right
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.575062
                    [longitude] => -87.217076
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.217076
                                    [1] => 36.575062
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Masonite
                    [1] => Stone
                    [2] => Vinyl Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 2448
                )

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

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

                )

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

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Disposal
                    [4] => Microwave
                    [5] => Refrigerator
                    [6] => Stainless Steel Appliance(s)
                )

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

                )

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

        )

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

            [services] => Array
                (
                    [0] => Underground Utilities
                )

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

            [parking_spaces] => 2
            [school] => stdClass Object
                (
                    [elementary] => Kirkwood Elementary
                    [junior] => Kirkwood Middle
                    [high] => Kirkwood High
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-11T18:04:24Z
        )

    [office] => stdClass Object
        (
            [name] => Queen City Realty & Property Management
            [broker_id] => 2572
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Edwin "ED"
                            [middle] => R.
                            [last] => Clapp
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 9312410802
                            [mobile] => 9312410802
                            [fax] => 9315534120
                        )

                )

            [1] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jessica
                            [last] => Clapp
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6157968124
                            [mobile] => 6157968124
                            [fax] => 9315534120
                        )

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [selling_agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Chong
                            [middle] => Hye
                            [last] => Choe
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 9315388712
                            [mobile] => 9315388712
                            [fax] => 9315039000
                        )

                )

        )

    [key] => rt-2815350
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-08T22:22:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • FeaturesCeiling Fan(s), Entrance Foyer, Extra Closets, Pantry, Walk-In Closet(s)
  • AppliancesElectric Oven, Electric Range, Dishwasher, Disposal, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionMasonite, Stone, Vinyl Siding
  • Built In2022
  • Stories2
  • ParkingGarage Faces Front
  • Garage Bays2
  • ServicesUnderground Utilities
  • SewerPublic Sewer

Listing Brokerage: Queen City Realty & Property Management
Listing Agent: Edwin "ED" Clapp (931) 241-0802

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of April 18, 2025 2:03pm. 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