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