stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-04-29T14:52:01
        )

    [ml_number] => 2824166
    [price] => stdClass Object
        (
            [amount] => 499988
            [original] => 499988
            [last_changed_on] => 2025-04-29T14:52:01
        )

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

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

    [description] => PRICE IMPROVEMENT OF $15,185!  ALL appliances and blinds (except washer and dryer) INCLUDED!   **Now offering ULTRA-competitive, below-market interest rates. This exclusive financing opportunity can enhance your purchasing power and secure you the most favorable monthly payment. Contact us today to learn more!**  Corner lot and GUEST bedroom on main level!  Special financing available (Call for details). Spacious and accommodating, the two-story "Moonstone" features an open-concept main floor and four charming bedrooms upstairs. This home is built with an extra bedroom and full bath on main level. Toward the back of the home, a great room flows into an inviting kitchen with a center island, walk-in pantry and adjacent dining room. Upstairs, a sprawling primary suite includes an attached bath and walk-in closet. The second floor also includes a spacious loft at the top of the landing!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => The Ridge at Carter's Station
            [street] => stdClass Object
                (
                    [number] => 3054
                    [name] => Fernwood LN
                    [full] => 3054 Fernwood LN
                )

            [directions] => GPS "The Ridge at Carter's Station by Richmond American Homes" to arrive at our model 2903 Windstone Trail Columbia, TN.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.717231
                    [longitude] => -86.982418
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.982418
                                    [1] => 35.717231
                                )

                        )

                )

        )

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

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Smart Camera(s)/Recording
                    [1] => Storage
                    [2] => Walk-In Closet(s)
                    [3] => Kitchen Island
                )

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

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Electric
                        )

                )

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

        )

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

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

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Front
                    [2] => Driveway
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => .21
                            [acres] => 0.21
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-05-01T14:21:00Z
        )

    [office] => stdClass Object
        (
            [name] => Richmond American Homes of Tennessee Inc
            [broker_id] => 5274
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jonathan
                            [middle] => Tyler
                            [last] => Holt
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2824166
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-29T18:52:01Z
        )

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

    Interior Details

  • Bedrooms5
  • Bathrooms3
  • FeaturesSmart Camera(s)/Recording, Storage, Walk-In Closet(s), Kitchen Island
  • AppliancesElectric Oven, Electric Range, Disposal, Freezer, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray

    Exterior Details

  • StyleColonial
  • ConstructionBrick, Stone, Vinyl Siding
  • Built In2024
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Front, Driveway
  • Garage Bays2
  • ServicesSidewalks, Underground Utilities, Trail(s)
  • SewerPublic Sewer
  • Lot DescriptionLevel
  • Lot Dimensions.21
  • Acres0.21

Listing Brokerage: Richmond American Homes of Tennessee Inc
Listing Agent: Jonathan Holt (629) 366-0400

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 4:43pm. 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