stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active Under Contract
            [last] => Active
            [changed] => 2024-08-09T17:42:00
        )

    [ml_number] => 2664646
    [price] => stdClass Object
        (
            [amount] => 349900
            [original] => 389900
            [last_changed_on] => 2024-07-15T16:14:00
        )

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

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

    [description] => Prime opportunity to own a beautifully renovated home located in the heart of Columbia convenient to downtown.  Quartz counters in kitchens and bathrooms. Stainless appliances in kitchen with tile backsplash.  Hardwoods throughout entire home. Zoned Residential Commercial, so this home has endless possibilities. Unfinished basement and rear barn for storage. See list of renovations in the document section.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Columbia
            [street] => stdClass Object
                (
                    [number] => 1620
                    [name] => S Main St
                    [full] => 1620 S Main St
                )

            [directions] => South on Carmack to right on 17th then house on corner of S Main and 17th
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.601382
                    [longitude] => -87.03878
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.03878
                                    [1] => 35.601382
                                )

                        )

                )

        )

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

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

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

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

                    [basement] => Array
                        (
                            [0] => Unfinished
                        )

                )

            [appliances] => Array
                (
                    [0] => Dryer
                    [1] => Refrigerator
                    [2] => Washer
                )

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

                )

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

        )

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 126X135 IRR
                            [acres] => 0.37
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Highland Park Elementary
                    [junior] => Whitthorne Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-08-13T18:02:22Z
        )

    [office] => stdClass Object
        (
            [name] => Compass RE
            [broker_id] => 4607
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => David
                            [middle] => Franklin
                            [last] => Henry
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159550486
                            [mobile] => 6159550486
                            [fax] => 6152212135
                        )

                    [agent_id] => 34011
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2664646
    [added_at] => stdClass Object
        (
            [$date] => 2024-06-29T17:32:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • BasementUnfinished
  • AppliancesDryer, Refrigerator, Washer
  • HVACArray

    Exterior Details

  • ConstructionVinyl Siding
  • Built In1936
  • Stories2
  • SewerPublic Sewer
  • Lot Dimensions126X135 IRR
  • Acres0.37

Listing Brokerage: Compass RE
Listing Agent: David Henry (615) 955-0486

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of April 25, 2025 8: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