stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active Under Contract
            [last] => Active
            [changed] => 2024-11-05T15:28:00
        )

    [ml_number] => 2693462
    [price] => stdClass Object
        (
            [amount] => 283999
            [original] => 295000
            [last_changed_on] => 2024-10-30T14:10:04
        )

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

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

    [description] => BACK ON THE MARKET!  Location is the key!, this home is 5 minutes to everywhere  Open concept, Kitchen has lots of space and cabinets. Split bedroom layout, 3 bedroom, 2 bath - washer and dryer remain with the home. Home is across the street from the growing The Factory in Columbia where you can enjoy the Nashville Tea Company.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Bel Air Hgts
            [street] => stdClass Object
                (
                    [number] => 100
                    [name] => N James M Campbell Blvd N
                    [full] => 100 N James M Campbell Blvd N
                )

            [directions] => US S 31 towards Columbia, R on N James Campbell Blvd. In .5 Miles turn L onto N James Campbell Blvd., first home on the Right
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.627178
                    [longitude] => -87.039558
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.039558
                                    [1] => 35.627178
                                )

                        )

                )

        )

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

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

            [stories] => 1
            [built_in] => 2018
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

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

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

                )

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

            [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] => 100X274.56 IRR
                            [acres] => 0.54
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Riverside Elementary
                    [junior] => E. A. Cox Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-11-05T20:28:00Z
        )

    [office] => stdClass Object
        (
            [name] => Hodges and Fooshee Realty Inc.
            [broker_id] => 728
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Mayra
                            [last] => Mercado
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159732202
                            [mobile] => 6154305169
                        )

                    [agent_id] => 7725
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2693462
    [added_at] => stdClass Object
        (
            [$date] => 2024-08-19T17:42:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Open Floorplan
  • AppliancesDryer, Refrigerator, Washer
  • HVACArray

    Exterior Details

  • ConstructionVinyl Siding
  • Built In2018
  • Stories1
  • SewerPublic Sewer
  • Lot DescriptionCorner Lot, Private, Views
  • Lot Dimensions100X274.56 IRR
  • Acres0.54

Listing Brokerage: Hodges and Fooshee Realty Inc.
Listing Agent: Mayra Mercado (615) 973-2202

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 6:20pm. 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