Price - High to Low Price - Low to High Date Listed - New to Old Date Listed - Old to New
stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Coming Soon
[changed] => 2024-10-26T01:02:02
)
[ml_number] => 2751369
[price] => stdClass Object
(
[amount] => 789000
[original] => 789000
[last_changed_on] => 2024-10-23T15:32:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2024-10-26T04:00:00Z
)
[description] => Discover the perfect blend of quiet country living just minutes from town! This stunning property boasts over 2 acres of lush land, a huge detached garage ideal for your camper or boat, and a serene back patio for peaceful evenings. Step inside the luxurious master suite featuring a free-standing tub, walk-in shower, and a grand master closet. Fall in love with the spacious chef's kitchen attached to a formal dining area, this space is perfect for entertaining guests. Upstairs features a spacious bonus room over the 3-car garage and generous bedrooms with custom shelved closets. Plus, don’t miss the 140 sq ft of finished attic space, perfectly soundproofed—ideal for a home office, music studio, or cozy retreat.
[location] => stdClass Object
(
[city] => Clarksville
[state] => Tennessee
[postal_code] => 37043
[county] => Montgomery County, TN
[subdivision] => Paul Krueckeberg Pro
[street] => stdClass Object
(
[number] => 5065
[name] => Pickering Rd
[full] => 5065 Pickering Rd
)
[directions] => Take US-41 ALT S to Mt. Carmel Rd. Turn onto Mt. Caramel and continue to Pickering Rd. Turn right onto Pickering Rd. 5065 Pickering Rd will be on your left hand side.
[coordinates] => stdClass Object
(
[latitude] => 36.469312
[longitude] => -87.147249
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -87.147249
[1] => 36.469312
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Contemporary
)
[construction] => Array
(
[0] => Brick
[1] => Stone
)
[square_feet] => stdClass Object
(
[size] => 3240
[source] => Assessor
)
[stories] => 2
[built_in] => 2016
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 3
)
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Entry Foyer
[2] => Extra Closets
[3] => Smart Camera(s)/Recording
[4] => Storage
[5] => Walk-In Closet(s)
[6] => Primary Bedroom Main Floor
[7] => High Speed Internet
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Septic Tank
)
[parking] => Array
(
[0] => Attached/Detached
[1] => Concrete
[2] => Driveway
)
[parking_spaces] => 5
[features] => Array
(
[0] => Garage Door Opener
[1] => Smart Camera(s)/Recording
[2] => Storage
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[acres] => 2.88
)
[description] => Array
(
[0] => Level
)
)
[school] => stdClass Object
(
[elementary] => Carmel Elementary
[junior] => Rossview Middle
[high] => Rossview High
)
)
[last_updated] => stdClass Object
(
[$date] => 2024-10-30T17:57:00Z
)
[office] => stdClass Object
(
[name] => Byers & Harvey Inc.
[broker_id] => 198
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Gracie
[last] => Seiber
)
[phone] => stdClass Object
(
[preferred] => 9314944978
[mobile] => 9314944978
)
[agent_id] => 73110
)
[1] => stdClass Object
(
[name] => stdClass Object
(
[first] => Raven
[last] => Morrison
)
[phone] => stdClass Object
(
[preferred] => 2107650897
[mobile] => 2107650897
)
[agent_id] => 53270
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Welcome Home!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/0.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/1.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Front Foyer
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/2.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => Formal Dining Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/3.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Formal Dining Attached to Open Foyer
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/4.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Living Room with Fireplace
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/5.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Living Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/6.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => Kitchen
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/7.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Stainless Steal Appliances
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/8.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => Shelving & Counter Space
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/9.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Eat In Kitchen with a View
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/10.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => Open Concept Kitchen
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/11.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Laundry Room
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/12.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Primary Suite Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/13.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Primary Suite Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/14.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Master Bathroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/15.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Free Standing Tub & Walk in Shower
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/16.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => Primary Walk-In Closet
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/17.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => 2nd Bedroom Downstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/18.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[description] => 2nd Bathroom Downstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/19.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => 3rd Bedroom Upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/20.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => 3rd Bathroom Upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/21.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => 3rd Bathroom Upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/22.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => Bathroom Access in 4th Bedroom
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/23.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => 4th Bedroom Upstairs
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/24.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => 140sqft Finished Attic Space
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/25.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => Bonus Room Above Garage
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/26.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Garage Door Entrance
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/27.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[description] => 3-Car Garage/Attached
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/28.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[description] => Attached Garage & Detached Garage
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/29.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[description] => Backyard View of The Patio
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/30.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[description] => Covered Back Patio
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/31.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[description] => 2.88 Acres
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/32.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[description] => Detached Garage
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/33.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[description] => Inside Detached Garage
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2751369/34.jpg
[215x] => https://new.photos.idx.io/rt2/2751369/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2751369/34/440x.jpg
)
)
)
)
[key] => rt-2751369
[added_at] => stdClass Object
(
[$date] => 2024-10-23T19:32:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2751369
)
Interior Details
Bedrooms 4 Bathrooms 3 Features Ceiling Fan(s), Entry Foyer, Extra Closets, Smart Camera(s)/Recording, Storage, Walk-In Closet(s), Primary Bedroom Main Floor, High Speed Internet HVAC Central Air, Electric Fireplaces 1
Exterior Details
Style Contemporary Construction Brick, Stone Built In 2016 Stories 2 Parking Attached/Detached, Concrete, Driveway Garage Bays 5 Features Garage Door Opener, Smart Camera(s)/Recording, Storage Sewer Septic Tank Lot Description Level Acres 2.88