stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-04-19T16:55:00
        )

    [ml_number] => 2820249
    [price] => stdClass Object
        (
            [amount] => 414900
            [original] => 414900
            [last_changed_on] => 2025-04-19T16:55:00
        )

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

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

    [description] => IF YOU WANT A CITY LOCATED , FULL BRICK HOME RENOVATED AND READY FOR NEW OWNERS, YOU HAVE GOT TO SEE THIS ONE. Could be a 4 bedroom, 1700 sq ft renovated brick in one of Columbia's fine neighborhood. Good lot with big nice trees and a good back yard for kids and pets. Location is mere minutes from shopping, churches, hospital, Columbia State. Home is Vacant and ready for new owners. Call LISTING AGENT OR your Realtor and get a look at this one today!. Do not lose this one.It is ready for your family
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Graymere Sec 1
            [street] => stdClass Object
                (
                    [number] => 2719
                    [name] => Gray Circle
                    [full] => 2719 Gray Circle
                )

            [directions] => From Columbia downtown, take W 7th St to Trotwood Ave, then L onto Graymere Manor Rd, then R onto Gray Circle. Home is 0.2 miles on L at 2719. Thanks for showing.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.595134
                    [longitude] => -87.082128
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.082128
                                    [1] => 35.595134
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1720
                    [source] => Owner
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Bookcases
                    [1] => Ceiling Fan(s)
                    [2] => Redecorated
                    [3] => Storage
                    [4] => Walk-In Closet(s)
                    [5] => Primary Bedroom Main Floor
                    [6] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Refrigerator
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Attached
                    [1] => Asphalt
                    [2] => Driveway
                    [3] => Paved
                    [4] => Unassigned
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 100X160
                            [acres] => 0.37
                        )

                    [description] => Array
                        (
                            [0] => Level
                            [1] => Private
                            [2] => Views
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-25T18:03:56Z
        )

    [office] => stdClass Object
        (
            [name] => Crye-Leike, Inc., REALTORS
            [broker_id] => 406
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => JIMMY D.
                            [middle] => D
                            [last] => DUGGER
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6152105027
                            [mobile] => 6152105027
                            [fax] => 6154681600
                        )

                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => http://tour.ShowcasePhotographers.com/index.php?sbo=ca2504181
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2820249
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-19T20:55:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesBookcases, Ceiling Fan(s), Redecorated, Storage, Walk-In Closet(s), Primary Bedroom Main Floor, High Speed Internet
  • AppliancesOven, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleRanch
  • ConstructionBrick
  • Built In1955
  • Stories1
  • ParkingAttached, Asphalt, Driveway, Paved, Unassigned
  • SewerPublic Sewer
  • Lot DescriptionLevel, Private, Views
  • Lot Dimensions100X160
  • Acres0.37

Listing Brokerage: Crye-Leike, Inc., REALTORS
Listing Agent: JIMMY D. DUGGER (615) 210-5027

Listings courtesy of Realtracs as distributed by MLS GRID

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