stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-07-27T18:02:05
        )

    [ml_number] => 2942533
    [price] => stdClass Object
        (
            [amount] => 453830
            [original] => 453730
            [last_changed_on] => 2025-08-02T17:12:00
        )

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

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

    [description] => The Harrington at Hampshire Hills by Smith Douglas Homes. Based on our top-selling plan, the Harrington delights with its massive second-floor owner’s suite privately tucked away on the same level as its three additional bedrooms. The first-floor impresses with an open concept family room, breakfast book, and large center island, plus a dining room that can be a loving room, study or a 5th bedroom/bedroom. Explore your choices for the Harrington kitchen, using our Interactive Kitchen Designer Tool as well. Estimated completion date September 2025.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Hampshire Hills
            [street] => stdClass Object
                (
                    [number] => 572
                    [name] => Nightengale Ridge Dr
                    [full] => 572 Nightengale Ridge Dr
                )

            [directions] => From I-65 S, take Exit 53 for TN-396. Follow 4.5 mi, then exit to US-31 S. Go 8.9 mi, turn right on US-43 S. After 2.9 mi, exit to Industrial Park Rd. Left on Industrial, right on James Campbell, right on Hampshire Pike, right on Iberia, left on Avalon.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.622824
                    [longitude] => -87.078863
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.078863
                                    [1] => 35.622824
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Fiber Cement
                    [1] => Stone
                )

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

            [stories] => 2
            [built_in] => 2025
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 5
                        )

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

                )

            [features] => Array
                (
                    [0] => Entrance Foyer
                    [1] => Extra Closets
                    [2] => High Ceilings
                    [3] => Open Floorplan
                    [4] => Pantry
                    [5] => Walk-In Closet(s)
                    [6] => Kitchen Island
                )

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

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

                )

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

        )

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

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

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

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.23
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-08-14T22:01:02Z
        )

    [office] => stdClass Object
        (
            [name] => SDH Nashville, LLC
            [broker_id] => 4180
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Emily
                            [last] => Street
                        )

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

                    [agent_id] => 68909
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => *This is only a rendering. Colors may appear slightly different in person.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/0/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/19/440x.jpg
                                )

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/20/440x.jpg
                                )

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/23/440x.jpg
                                )

                        )

                    [24] => stdClass Object
                        (
                            [position] => 24
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/24.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/24/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/24/440x.jpg
                                )

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/27/440x.jpg
                                )

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/28/440x.jpg
                                )

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [description] => *This is a marketing photo. Colors/options may be different.*
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2942533/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2942533/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2942533/29/440x.jpg
                                )

                        )

                )

        )

    [open_houses] => Array
        (
            [0] => stdClass Object
                (
                    [starts_at] => stdClass Object
                        (
                            [$date] => 2025-08-20T18:00:00Z
                        )

                    [ends_at] => stdClass Object
                        (
                            [$date] => 2025-08-20T22:00:00Z
                        )

                    [status] => Active
                )

            [1] => stdClass Object
                (
                    [starts_at] => stdClass Object
                        (
                            [$date] => 2025-08-21T15:00:00Z
                        )

                    [ends_at] => stdClass Object
                        (
                            [$date] => 2025-08-21T22:00:00Z
                        )

                    [status] => Active
                )

            [2] => stdClass Object
                (
                    [starts_at] => stdClass Object
                        (
                            [$date] => 2025-08-27T17:00:00Z
                        )

                    [ends_at] => stdClass Object
                        (
                            [$date] => 2025-08-27T19:00:00Z
                        )

                    [status] => Active
                )

        )

    [key] => rt-2942533
    [added_at] => stdClass Object
        (
            [$date] => 2025-07-20T22:02:06Z
        )

    [source] => rt
    [self_link] => https://api.idx.io/listings/rt-2942533
)
  • Open House - Wednesday, August 20 - 1:00 - 5:00
  • Open House - Thursday, August 21 - 10:00 - 5:00
  • Open House - Wednesday, August 27 - 12:00 - 2:00

    Interior Details

  • Bedrooms5
  • Bathrooms3
  • FeaturesEntrance Foyer, Extra Closets, High Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
  • AppliancesGas Oven, Gas Range, Dishwasher, Disposal, Microwave, Stainless Steel Appliance(s)
  • HVACArray

    Exterior Details

  • ConstructionFiber Cement, Stone
  • Built In2025
  • Stories2
  • ParkingGarage Faces Front
  • Garage Bays2
  • ServicesSidewalks, Underground Utilities
  • SewerPublic Sewer
  • Acres0.23

Listing Brokerage: SDH Nashville, LLC
Listing Agent: Emily Street (931) 626-0264

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of August 20, 2025 5:08am. 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