stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-07-23T21:47:00
        )

    [ml_number] => 2940516
    [price] => stdClass Object
        (
            [amount] => 642500
            [original] => 642500
            [last_changed_on] => 2025-07-23T21:47:00
        )

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

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

    [description] => Take advantage now of the ASSUMABLE VA LOAN @ 3.375%!  Comfort meets convenience in a beautifully updated home! This 4 bedroom home sits proudly on a desirable corner lot in a quiet, friendly neighborhood with easy access to the bypass for effortless commuting.Step inside to a large open living room, perfect for gatherings or cozy nights in. The expansive kitchen is a chef’s dream, featuring abundant cabinetry and all-new appliances (less than a year old!). Entertain with ease on the covered back deck—complete with a mounted TV and a natural gas grill line—ideal for weekend barbecues or relaxing evenings outdoors.
Retreat to generously sized bedrooms, including a luxurious master suite with a double shower head in the updated master bath. Enjoy peace of mind with recent upgrades: roof, windows, deck cover, and master bath have all been refreshed within the past couple of years. The low-maintenance rock flower bed and privacy fence create a serene outdoor oasis, while the garage offers hanging storage for all your needs. Nearby, you’ll find local favorites and the convenience of  shopping. Parks and green spaces are just minutes away for outdoor enjoyment.
Don’t miss your chance to own this move-in-ready gem—schedule your tour today and experience the best of Columbia living!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Hunters Glen Sec 1
            [street] => stdClass Object
                (
                    [number] => 114
                    [name] => Deerview Dr
                    [full] => 114 Deerview Dr
                )

            [directions] => From Columbia take Hwy 243 South, turn left on Sunnyside Lane, right on Old Sunnyside Lane, Left into Hunters Glen, left on Deerview Dr, property will be on right
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.582234
                    [longitude] => -87.096447
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.096447
                                    [1] => 35.582234
                                )

                        )

                )

        )

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

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

            [square_feet] => stdClass Object
                (
                    [size] => 2939
                    [source] => Appraiser
                )

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

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

                    [basement] => Array
                        (
                            [0] => Crawl Space
                        )

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Extra Closets
                    [2] => Pantry
                    [3] => Redecorated
                    [4] => Walk-In Closet(s)
                    [5] => High Speed Internet
                )

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

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Side
                    [2] => Concrete
                    [3] => Driveway
                    [4] => On Street
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 110.69X125.00
                            [acres] => 0.25
                        )

                    [description] => Array
                        (
                            [0] => Corner Lot
                            [1] => Level
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-27T21:42:00Z
        )

    [office] => stdClass Object
        (
            [name] => Epique Realty
            [broker_id] => 48730
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Sybil
                            [last] => McKee Davis
                        )

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

                    [agent_id] => 47316
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2940516
    [added_at] => stdClass Object
        (
            [$date] => 2025-07-18T21:11:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • Half Baths1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Extra Closets, Pantry, Redecorated, Walk-In Closet(s), High Speed Internet
  • AppliancesDouble Oven, Electric Oven, Cooktop, Dishwasher, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray

    Exterior Details

  • StyleTraditional
  • ConstructionBrick, Vinyl Siding
  • Built In1996
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Side, Concrete, Driveway, On Street
  • Garage Bays2
  • SewerPublic Sewer
  • Lot DescriptionCorner Lot, Level
  • Lot Dimensions110.69X125.00
  • Acres0.25

Listing Brokerage: Epique Realty
Listing Agent: Sybil McKee Davis (931) 300-4663

Listings courtesy of Realtracs as distributed by MLS GRID

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