stdClass Object
(
    [type] => Rental
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-06-24T14:07:02
        )

    [ml_number] => 2922518
    [price] => stdClass Object
        (
            [amount] => 2350
            [original] => 2350
            [last_changed_on] => 2025-06-24T14:07:02
        )

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

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

    [description] => NEW 2024 Open-Concept 4 Beds and 2.5 Bathroom Home~Features Includes All Stainless Steel Kitchen Appliances~ Quartz Countertops in Kitchen and Baths~Ring Doorbell~Keyless Entry~NEW BACKYARD FENCE~Community Plan for Future Includes Pool and Playground~ Owner approved Pets allowed for additional $45/month fee per pet~$65 NON-REFUNDABLE APPLICATION FEE~HOME IS CURRENTLY OCCUPIED UNTIL 7/23/25 BUT CURRENTLY ACCEPTING SHOWINGS ~PLEASE SCHEDULE SHOWINGS THRU SHOWINGS APP~PLEASE TEXT SHAN AZAR AT 615-972-7962 WITH ANY QUESTIONS.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Drumwright
            [street] => stdClass Object
                (
                    [number] => 3146
                    [name] => Lyman Ridge Rd
                    [full] => 3146 Lyman Ridge Rd
                )

            [directions] => From Nashville~I-65 South~Saturn Parkway~Hwy 31 South towards Columbia~ Drumwright Subdivision is located about 3 miles on the Left past Green Mills Road
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.700316
                    [longitude] => -86.977775
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.977775
                                    [1] => 35.700316
                                )

                        )

                )

        )

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Extra Closets
                    [1] => Pantry
                    [2] => Walk-In Closet(s)
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Disposal
                    [2] => Microwave
                    [3] => Oven
                    [4] => Refrigerator
                    [5] => Range
                )

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

                )

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

        )

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

            [services] => Array
                (
                    [0] => Playground
                    [1] => Pool
                )

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

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-16T18:01:11Z
        )

    [office] => stdClass Object
        (
            [name] => Hodges and Fooshee Realty Inc.
            [broker_id] => 728
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Shan
                            [last] => Azar
                        )

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

                    [agent_id] => 22359
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Brand new home with a private back yard that backs up to a treeline.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/0/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Open kitchen with Luxurious Vinyl flooring and solid surface counter tops.  Stainless appliances and a 5 burner gas stove.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/3/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => Kitchen opens up into breakfast room and living room.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/6/440x.jpg
                                )

                        )

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

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => Half bath off of the Foyer
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Walk in Laundry room
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => 2nd floor master
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/10/440x.jpg
                                )

                        )

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

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => Large shower in master bath
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => Large master walk-in closet
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/13/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => 2nd floor guest bath
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => 2nd full bath
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/19/440x.jpg
                                )

                        )

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

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => Bonus Room/Loft can be used as an upstairs living room or office.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/21/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [description] => Back yard with poured concrete patio.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => View from back patio
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2922518/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2922518/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2922518/26/440x.jpg
                                )

                        )

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

                        )

                )

        )

    [key] => rt-2922518
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-24T18:07:02Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • Half Baths1
  • FeaturesExtra Closets, Pantry, Walk-In Closet(s)
  • AppliancesDishwasher, Disposal, Microwave, Oven, Refrigerator, Range
  • HVACArray

    Exterior Details

  • ConstructionFiber Cement, Brick
  • Built In2024
  • Stories2
  • ParkingGarage Faces Front
  • Garage Bays2
  • ServicesPlayground, Pool
  • SewerPublic Sewer

Listing Brokerage: Hodges and Fooshee Realty Inc.
Listing Agent: Shan Azar (615) 972-7962

Listings courtesy of Realtracs as distributed by MLS GRID

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