stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2024-07-27T01:02:02
        )

    [ml_number] => 2681196
    [price] => stdClass Object
        (
            [amount] => 379900
            [original] => 389000
            [last_changed_on] => 2024-09-06T11:45:00
        )

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

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

    [description] => Welcome to  317 Stonewall Dr, a stunning residence in Columbia, TN, that offers the perfect blend of contemporary comfort and serene living. This home is in impeccable, new condition, ready for you to move in and make it your own. As you step inside, you'll be captivated by the elegant interior featuring quartz countertops in the kitchen, providing both a sophisticated look and durable functionality. The open-concept design seamlessly connects the living, dining, and kitchen areas, creating a perfect space for entertaining and family gatherings. One of the standout features of this property is its private, rear-facing backyard. Whether you enjoy morning coffee on the patio or hosting summer barbecues, this secluded space offers a peaceful retreat from the hustle and bustle of everyday life.The exterior of the home is just as impressive, with ample green space surrounding the property. Schedule a viewing today and experience this exceptional property firsthand!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Morgan Meadows Phase 1
            [street] => stdClass Object
                (
                    [number] => 317
                    [name] => Stonewall Dr
                    [full] => 317 Stonewall Dr
                )

            [directions] => From Downtown Columbia. Head west on W 7th St toward S Garden St (.6mi). Slight left onto TN-243 S/Mt Pleasant Pike/Trotwood Ave (3.7mi). Turn right onto Stonewall Rd (.6mi) Turn right onto Stonewall Dr (.1mi). House on your left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.591105
                    [longitude] => -87.109302
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.109302
                                    [1] => 35.591105
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Fiber Cement
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1348
                    [source] => Professional Measurement
                )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Smart Thermostat
                    [2] => Walk-In Closet(s)
                    [3] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Disposal
                    [2] => Microwave
                )

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

                )

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

        )

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

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

            [parking] => Array
                (
                    [0] => Attached - Front
                    [1] => Concrete
                    [2] => Driveway
                )

            [parking_spaces] => 1
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 78.93 X 120.93 IRR
                            [acres] => 0.24
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => J E Woodard Elementary
                    [junior] => Whitthorne Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-09-06T15:45:00Z
        )

    [office] => stdClass Object
        (
            [name] => Realty One Group Music City
            [broker_id] => 4500
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Christopher
                            [middle] => Chad
                            [last] => Frey
                        )

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

                    [agent_id] => 66147
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2681196
    [added_at] => stdClass Object
        (
            [$date] => 2024-07-19T19:04:01Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • FeaturesCeiling Fan(s), Smart Thermostat, Walk-In Closet(s), High Speed Internet
  • AppliancesDishwasher, Disposal, Microwave
  • HVACArray

    Exterior Details

  • StyleContemporary
  • ConstructionFiber Cement
  • Built In2022
  • Stories2
  • ParkingAttached - Front, Concrete, Driveway
  • Garage Bays1
  • ServicesUnderground Utilities
  • SewerPublic Sewer
  • Lot DescriptionLevel, Private
  • Lot Dimensions78.93 X 120.93 IRR
  • Acres0.24

Listing Brokerage: Realty One Group Music City
Listing Agent: Christopher Frey (615) 429-2279

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 10, 2025 1:55am. 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