Price - High to Low Price - Low to High Date Listed - New to Old Date Listed - Old to New
stdClass Object
(
[type] => Multi-Family
[status] => stdClass Object
(
[current] => Active Under Contract
[last] => Active
[changed] => 2025-04-26T20:55:00
)
[ml_number] => 2820105
[price] => stdClass Object
(
[amount] => 419900
[original] => 419900
[last_changed_on] => 2025-04-19T10:52:00
)
[listing_flags] => Array
(
[0] => Inspection
[1] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-04-18T04:00:00Z
)
[description] => LOCATION, LOCATION, LOCATION* This turnkey duplex went through a remarkable upscale renovation in 2023, is located right off of Hwy 31 in North Columbia, and boasts over an acre lot! The property has amazing tenants at top of the market rates. This great investment property also includes 2 new HVACs (2023) which have 10 year transferable labor warranties, and a newer metal roof so this should help lower your expenses over the next few years! This property is currently managed by Freedom Property Management and they are willing to continue managing the property.
[location] => stdClass Object
(
[city] => Columbia
[state] => Tennessee
[postal_code] => 38401
[county] => Maury County, TN
[subdivision] => Hardie Arces
[street] => stdClass Object
(
[number] => 407
[name] => N Laurel Cir
[full] => 407 N Laurel Cir
)
[directions] => From Spring Hill take Hwy 31 South to R on N Laurel Cir, home is on the right. From downtown Columbia take Nashville Hwy (Hwy 31) North to L on N Laurel Cir.
[coordinates] => stdClass Object
(
[latitude] => 35.64559
[longitude] => -87.015068
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -87.015068
[1] => 35.64559
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 1679
[source] => Assessor
)
[stories] => 1
[built_in] => 1970
[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] => 115X420
)
)
[school] => stdClass Object
(
[elementary] => E. A. Cox Middle School
[junior] => E. A. Cox Middle School
[high] => Columbia Central High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-27T00:55:00Z
)
[office] => stdClass Object
(
[name] => Capstone Realty
[broker_id] => 4785
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Todd
[last] => Hicks
)
[phone] => stdClass Object
(
[preferred] => 9316754390
[mobile] => 9316754390
)
)
)
[media] => stdClass Object
(
[virtual_tours] => Array
(
[0] => https://www.youtube.com/embed/vJsH-qyHiwE
)
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/0.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/1.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/2.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/3.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/4.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/5.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/6.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/7.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/8.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/9.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/10.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/11.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/12.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/13.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/14.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/15.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/16.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/17.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/18.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/19.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/20.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/21.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/22.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/23.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/24.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/25.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/26.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/27.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/28.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/29.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/30.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/31.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/32.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/33.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/34.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/35.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2820105/36.jpg
[215x] => https://new.photos.idx.io/rt2/2820105/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2820105/36/440x.jpg
)
)
)
)
[key] => rt-2820105
[added_at] => stdClass Object
(
[$date] => 2025-04-19T14:52:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2820105
)
Exterior Details
Construction Brick Built In 1970 Stories 1 Sewer Public Sewer Lot Dimensions 115X420