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

    [ml_number] => 2750580
    [price] => stdClass Object
        (
            [amount] => 345000
            [original] => 345000
            [last_changed_on] => 2024-10-21T21:22:00
        )

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

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

    [description] => Nestled on 2.5 wooded, private acres, this completely renovated 4-bedroom, 2-bathroom home offers modern living in a tranquil setting. The property features a brand new HVAC system, luxury vinyl plank flooring, quartz countertops, satin paint, lighting, and modern tile work throughout. The contemporary bathrooms have been fully updated, and the primary bathroom includes a double vanity, walk in shower, and walk in closet.  The front and back patios are ideal for outdoor relaxation or entertaining. With ample parking, open spaces, and a large storage shed, there’s plenty of space for vehicles and outdoor equipment. Enjoy the freedom of no HOA restrictions, giving you the flexibility to make this property truly your own. Perfect for those seeking both privacy and modern comfort!  This is an owner/agent listing.  Please do not disturb the tenants.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [street] => stdClass Object
                (
                    [number] => 2772
                    [name] => Williamsport Pike
                    [full] => 2772 Williamsport Pike
                )

            [directions] => Directions from Highway 431 (Nashville Highway): Head South on Highway 431. Turn Right onto Williamsport Pike. Continue on Williamsport Pike for 2 miles. 2772 Williamsport Pike will be on your right (driveway immediately past mailbox w/orange reflector).
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.653845
                    [longitude] => -87.168972
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.168972
                                    [1] => 35.653845
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Wood Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1575
                    [source] => Agent Measured
                )

            [stories] => 1
            [built_in] => 1997
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 4
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Open Floorplan
                    [2] => Smart Thermostat
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Microwave
                    [2] => Refrigerator
                    [3] => Stainless Steel Appliance(s)
                )

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

                )

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

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => Septic Tank
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 2.5
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-10-29T05:02:02Z
        )

    [office] => stdClass Object
        (
            [name] => CURB Realty
            [broker_id] => 4405
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Alison
                            [last] => Eschrich
                        )

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

                    [agent_id] => 73648
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2750580
    [added_at] => stdClass Object
        (
            [$date] => 2024-10-22T01:22:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Open Floorplan, Smart Thermostat
  • AppliancesDishwasher, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray

    Exterior Details

  • ConstructionWood Siding
  • Built In1997
  • Stories1
  • SewerSeptic Tank
  • Acres2.5

Listing Brokerage: CURB Realty
Listing Agent: Alison Eschrich (615) 721-2317

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 8:42am. 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