stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2025-05-18T20:30:00
        )

    [ml_number] => 2867789
    [price] => stdClass Object
        (
            [amount] => 485000
            [original] => 485000
            [last_changed_on] => 2025-05-09T11:59:00
        )

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

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

    [description] => Welcome to 657 Josef Circle, a beautifully maintained one-level home in Columbia’s desirable Greystone subdivision. Built in 2021, this 3-bedroom, 2-bath home offers 1,654 sq ft of thoughtful design, including engineered hardwood floors in the main living areas, tile in the bathrooms and laundry room, and custom cabinetry throughout the kitchen. The open-concept layout features a spacious great room and a gourmet kitchen with granite countertops and stainless steel appliances. The primary suite includes a private en-suite bath and walk-in closet. Unique touches like a custom dog washing station in the laundry room, a backyard pergola with a fire pit, and a storage building built to residential codes make this home truly stand out. Located just minutes from I-65 with quick access to Spring Hill, Franklin, and Nashville, this home also benefits from a welcoming community with sidewalks, street lights, and underground utilities. All appliances in the kitchen and washer & dryer in laundry convey. RainSoft water softener does not convey. Some furniture items are available for purchase outside of home purchase. Please ask listing agent for more details.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Greystone
            [street] => stdClass Object
                (
                    [number] => 657
                    [name] => Josef Cir
                    [full] => 657 Josef Cir
                )

            [directions] => From Downtown Columbia, HWY 31 N, Right on HWY 412 E. Left on Josef Circle. From Nashville, I65 S to Bear Creek Pike, W 4.5 miles to Greystone Subdivision on Right.
            [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
        (
            [style] => Array
                (
                    [0] => Cottage
                )

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

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

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

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

                )

            [appliances] => Array
                (
                    [0] => Electric Range
                    [1] => Dishwasher
                    [2] => Dryer
                    [3] => Microwave
                    [4] => Refrigerator
                    [5] => Washer
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Faces Front
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 62.45 X 149.82 IRR
                            [acres] => 0.3
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Marvin Wright Elementary School
                    [junior] => E. A. Cox Middle School
                    [high] => Spring Hill High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-05-25T23:28:00Z
        )

    [office] => stdClass Object
        (
            [name] => Redfin
            [broker_id] => 3525
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Andrea
                            [last] => Wall
                        )

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

                    [agent_id] => 43355
                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => https://my.matterport.com/show/?m=pfDRWSCWFvC&brand=0&mls=1&
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2867789
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-09T15:59:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • AppliancesElectric Range, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • HVACArray

    Exterior Details

  • StyleCottage
  • ConstructionBrick
  • Built In2021
  • Stories1
  • ParkingGarage Faces Front
  • Garage Bays2
  • SewerPublic Sewer
  • Lot Dimensions62.45 X 149.82 IRR
  • Acres0.3

Listing Brokerage: Redfin
Listing Agent: Andrea Wall (615) 430-9553

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of June 2, 2025 8:35pm. 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