stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Pending
            [last] => Active
            [changed] => 2021-11-09T09:22:03
        )

    [ml_number] => 2252516
    [price] => stdClass Object
        (
            [amount] => 625000
            [original] => 850000
            [last_changed_on] => 2021-11-04T14:32:16
        )

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

    [available_on] => stdClass Object
        (
            [$date] => 2021-05-22T04:00:00Z
        )

    [description] => Amazing home in Downtown Columbia. Corner lot with private parking out back plus a two car garage. quartz and granite countertops throughout. Walnut hardwood downstairs with engineered hardwood upstairs. tile showers and bathrooms, heated master bath floor, gas appliances, built in wine cooler, tankless water heater. Screened in patio for entertaining. Manicured landscaping. A short walk to downtown, close to shopping, and live entertainment. Just too much to mention with this home. 
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Subvision
            [street] => stdClass Object
                (
                    [number] => 817
                    [name] => Hastings St
                    [full] => 817 Hastings St
                )

            [directions] => From Downtown Columbia, travel west on W. 7th. Turn right on Hastings St. Home is on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.623997
                    [longitude] => -87.00404
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.00404
                                    [1] => 35.623997
                                )

                        )

                )

        )

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

            [square_feet] => stdClass Object
                (
                    [size] => 2947
                    [source] => Assessor
                )

            [stories] => 2
            [built_in] => 2019
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [description] => Array
                                (
                                    [0] => Extra Large Closet
                                )

                            [count] => 4
                        )

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

                    [kitchen] => Array
                        (
                            [0] => Pantry
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Walk-In Closet(s)
                )

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

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

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

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Public Sewer
            [parking] => Array
                (
                    [0] => Attached
                    [1] => Assigned
                )

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Garage Door Opener
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 68 X 116.01 IRR
                            [acres] => 0.19
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2021-11-09T14:22:03Z
        )

    [office] => stdClass Object
        (
            [name] => Keller Williams Realty
            [broker_id] => 857
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => James
                            [last] => Shannon
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 9313840122
                            [mobile] => 9313840122
                            [fax] => 6153024243
                        )

                    [agent_id] => 53989
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [selling_agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Tyreshias
                            [middle] => Lea
                            [last] => Guarnotta
                        )

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

                    [agent_id] => 64001
                )

        )

    [key] => rt-2252516
    [added_at] => stdClass Object
        (
            [$date] => 2021-05-21T21:43:03Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms4
  • Half Baths1
  • Bedroom DescriptionExtra Large Closet
  • RoomsCombination
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Walk-In Closet(s)
  • KitchenPantry
  • AppliancesDishwasher, Disposal, Microwave, Refrigerator
  • HVACElectric,Central Air, Natural Gas,Central
  • Fireplaces1

    Exterior Details

  • ConstructionHardboard Siding
  • Built In2019
  • Stories2
  • ParkingAttached, Assigned
  • Garage Bays2
  • FeaturesGarage Door Opener
  • SewerPublic Sewer
  • Lot DescriptionLevel
  • Lot Dimensions68 X 116.01 IRR
  • Acres0.19

Listing Brokerage: Keller Williams Realty
Listing Agent: James Shannon (931) 384-0122

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 14, 2025 3:16pm. 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