stdClass Object ( [type] => Residential [status] => stdClass Object ( [current] => Active [last] => Coming Soon [changed] => 2025-04-04T01:02:06 ) [ml_number] => 2812682 [price] => stdClass Object ( [amount] => 679000 [original] => 679000 [last_changed_on] => 2025-04-02T21:04:00 ) [listing_flags] => Array ( [0] => Existing ) [available_on] => stdClass Object ( [$date] => 2025-04-04T04:00:00Z ) [description] => This beautifully upgraded, open-concept home is located in the highly sought-after Durham Farms community on a quiet street with minimal traffic. The luxurious backyard oasis features a large, flat lot with a covered built-in outdoor kitchen, firepit, and a relaxing jacuzzi, perfect for entertaining or unwinding after a long day. Inside, the home boasts 2 convenient laundry rooms—one in the primary suite and another upstairs, currently being used as a game room. A bonus living area on the second floor provides the ideal space for a family den or playroom. The chef’s kitchen is an entertainer’s dream, featuring a gas range, double ovens, and a large island for ample prep space. The open layout seamlessly flows into the living and dining areas, perfect for hosting guests. The main floor also includes a dedicated office space for work or study, ensuring that all your needs are met. Just a short walk to the clubhouse (which includes a coffee shop inside) and pool, this home offers a peaceful retreat with resort-style amenities. Neighborhood amenities are unparalleled, with a dog park, pool, splash pad, gym, walking trails, and community events like "Food Truck Fridays." With top-rated schools, shopping, dining, and entertainment just minutes away, this home offers the perfect combination of comfort, convenience, and luxury. [location] => stdClass Object ( [city] => Hendersonville [state] => Tennessee [postal_code] => 37075 [county] => Sumner County, TN [subdivision] => Durham Ph2 [street] => stdClass Object ( [number] => 172 [name] => Picasso Cir [full] => 172 Picasso Cir ) [directions] => From I-65N, take Vietnam Veterans BLVD to Exit 7. Turn left on Drakes Creek Rd. Turn Right onto Anderson Rd. Turn left onto Nottingham Ave. Turn left onto Picasso Circle. 172 is on your left. [coordinates] => stdClass Object ( [latitude] => 36.347551 [longitude] => -86.612045 [geo_json] => stdClass Object ( [type] => Point [coordinates] => Array ( [0] => -86.612045 [1] => 36.347551 ) ) ) ) [building] => stdClass Object ( [construction] => Array ( [0] => Masonite [1] => Brick ) [square_feet] => stdClass Object ( [size] => 2805 ) [stories] => 2 [built_in] => 2020 [rooms] => stdClass Object ( [bed] => stdClass Object ( [count] => 4 ) [baths] => stdClass Object ( [full] => 3 [half] => 1 ) [basement] => Array ( [0] => Crawl Space ) ) [features] => Array ( [0] => Ceiling Fan(s) [1] => Hot Tub [2] => Open Floorplan [3] => Pantry [4] => Walk-In Closet(s) [5] => Kitchen Island ) [appliances] => Array ( [0] => Double Oven [1] => Gas Range [2] => Dishwasher [3] => Disposal [4] => Dryer [5] => Freezer [6] => Microwave [7] => Refrigerator [8] => Stainless Steel Appliance(s) [9] => Washer [10] => Smart Appliance(s) ) [hvac] => Array ( [0] => Array ( [0] => Central Air ) ) [fireplaces] => stdClass Object ( [count] => 1 [exists] => 1 ) ) [surroundings] => stdClass Object ( [sewer] => Array ( [0] => Public Sewer ) [services] => Array ( [0] => Clubhouse [1] => Dog Park [2] => Fitness Center [3] => Park [4] => Playground [5] => Pool [6] => Underground Utilities [7] => Trail(s) ) [parking] => Array ( [0] => Garage Door Opener [1] => Attached ) [parking_spaces] => 2 [features] => Array ( [0] => Gas Grill [1] => Smart Lock(s) ) [land] => stdClass Object ( [size] => stdClass Object ( [acres] => 0.15 ) [description] => Array ( [0] => Level ) ) [school] => stdClass Object ( [elementary] => Dr. William Burrus Elementary at Drakes Creek [junior] => Knox Doss Middle School at Drakes Creek [high] => Beech Sr High School ) ) [last_updated] => stdClass Object ( [$date] => 2025-04-15T18:03:05Z ) [office] => stdClass Object ( [name] => WEICHERT, REALTORS - The Andrews Group [broker_id] => 2166 ) [agents] => Array ( [0] => stdClass Object ( [name] => stdClass Object ( [first] => Courtney [last] => Conklin ) [phone] => stdClass Object ( [preferred] => 7578692098 [mobile] => 7578692098 [fax] => 6153833428 ) ) ) [media] => stdClass Object ( [photos] => Array ( [0] => stdClass Object ( [position] => 0 [description] => Welcome to 172 Picasso Circle situated on a quiet circle in Durham Farms [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/0.jpg [215x] => https://new.photos.idx.io/rt2/2812682/0/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/0/440x.jpg ) ) [1] => stdClass Object ( [position] => 1 [description] => Enjoy coffee or cocktails while swinging on your front porch swing [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/1.jpg [215x] => https://new.photos.idx.io/rt2/2812682/1/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/1/440x.jpg ) ) [2] => stdClass Object ( [position] => 2 [description] => Modern kitchen boasts a large island, double ovens, and a gas stove top [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/2.jpg [215x] => https://new.photos.idx.io/rt2/2812682/2/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/2/440x.jpg ) ) [3] => stdClass Object ( [position] => 3 [description] => Island includes a large farmhouse sink [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/3.jpg [215x] => https://new.photos.idx.io/rt2/2812682/3/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/3/440x.jpg ) ) [4] => stdClass Object ( [position] => 4 [description] => Stainless steel appliances add to the functionality of this modern kitchen [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/4.jpg [215x] => https://new.photos.idx.io/rt2/2812682/4/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/4/440x.jpg ) ) [5] => stdClass Object ( [position] => 5 [description] => The open concept floorplan is enhanced with high ceilings in the great room [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/5.jpg [215x] => https://new.photos.idx.io/rt2/2812682/5/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/5/440x.jpg ) ) [6] => stdClass Object ( [position] => 6 [description] => A gas fireplace adds to the coziness of the living space [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/6.jpg [215x] => https://new.photos.idx.io/rt2/2812682/6/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/6/440x.jpg ) ) [7] => stdClass Object ( [position] => 7 [description] => Open concept eating area is perfect for entertaining [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/7.jpg [215x] => https://new.photos.idx.io/rt2/2812682/7/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/7/440x.jpg ) ) [8] => stdClass Object ( [position] => 8 [description] => View of the foyer from the great room [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/8.jpg [215x] => https://new.photos.idx.io/rt2/2812682/8/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/8/440x.jpg ) ) [9] => stdClass Object ( [position] => 9 [description] => Half bath on the main floor [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/9.jpg [215x] => https://new.photos.idx.io/rt2/2812682/9/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/9/440x.jpg ) ) [10] => stdClass Object ( [position] => 10 [description] => Main floor flex space can be used as an office, workout room, playroom, bourbon room...the possibilities are endless! [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/10.jpg [215x] => https://new.photos.idx.io/rt2/2812682/10/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/10/440x.jpg ) ) [11] => stdClass Object ( [position] => 11 [description] => Primary bedroom features backyard views [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/11.jpg [215x] => https://new.photos.idx.io/rt2/2812682/11/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/11/440x.jpg ) ) [12] => stdClass Object ( [position] => 12 [description] => Spacious primary ensuite has a separate shower/tub [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/12.jpg [215x] => https://new.photos.idx.io/rt2/2812682/12/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/12/440x.jpg ) ) [13] => stdClass Object ( [position] => 13 [description] => The spacious primary bathroom features separate vanities [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/13.jpg [215x] => https://new.photos.idx.io/rt2/2812682/13/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/13/440x.jpg ) ) [14] => stdClass Object ( [position] => 14 [description] => Two separate upgraded closets provide loads of storage space [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/14.jpg [215x] => https://new.photos.idx.io/rt2/2812682/14/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/14/440x.jpg ) ) [15] => stdClass Object ( [position] => 15 [description] => Closet #2 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/15.jpg [215x] => https://new.photos.idx.io/rt2/2812682/15/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/15/440x.jpg ) ) [16] => stdClass Object ( [position] => 16 [description] => Laundry room located in the primary suite for ultimate convenience [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/16.jpg [215x] => https://new.photos.idx.io/rt2/2812682/16/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/16/440x.jpg ) ) [17] => stdClass Object ( [position] => 17 [description] => The upstairs flex space is ideal for a second den or kids' space [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/17.jpg [215x] => https://new.photos.idx.io/rt2/2812682/17/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/17/440x.jpg ) ) [18] => stdClass Object ( [position] => 18 [description] => Bedroom #1 features a large closet [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/18.jpg [215x] => https://new.photos.idx.io/rt2/2812682/18/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/18/440x.jpg ) ) [19] => stdClass Object ( [position] => 19 [description] => Bedroom #1 is connected to a jack-and-jill bathroom [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/19.jpg [215x] => https://new.photos.idx.io/rt2/2812682/19/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/19/440x.jpg ) ) [20] => stdClass Object ( [position] => 20 [description] => Jack-and-jill bathroom connects two bedrooms for easy access [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/20.jpg [215x] => https://new.photos.idx.io/rt2/2812682/20/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/20/440x.jpg ) ) [21] => stdClass Object ( [position] => 21 [description] => The jack-and-jill bathroom features two separate vanities for space and privacy [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/21.jpg [215x] => https://new.photos.idx.io/rt2/2812682/21/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/21/440x.jpg ) ) [22] => stdClass Object ( [position] => 22 [description] => Bedroom #2 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/22.jpg [215x] => https://new.photos.idx.io/rt2/2812682/22/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/22/440x.jpg ) ) [23] => stdClass Object ( [position] => 23 [description] => Bedroom #2 has a large closet and connects to the jack-and-jill bathroom [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/23.jpg [215x] => https://new.photos.idx.io/rt2/2812682/23/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/23/440x.jpg ) ) [24] => stdClass Object ( [position] => 24 [description] => Second bathroom upstairs is a shower/tub combo [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/24.jpg [215x] => https://new.photos.idx.io/rt2/2812682/24/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/24/440x.jpg ) ) [25] => stdClass Object ( [position] => 25 [description] => Bedroom #3 is spacious and boasts a large closet [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/25.jpg [215x] => https://new.photos.idx.io/rt2/2812682/25/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/25/440x.jpg ) ) [26] => stdClass Object ( [position] => 26 [description] => The laundry room upstairs is currently being used as a toy room [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/26.jpg [215x] => https://new.photos.idx.io/rt2/2812682/26/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/26/440x.jpg ) ) [27] => stdClass Object ( [position] => 27 [description] => Built-in outdoor kitchen features a gas grill, refrigerator and a peninsula [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/27.jpg [215x] => https://new.photos.idx.io/rt2/2812682/27/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/27/440x.jpg ) ) [28] => stdClass Object ( [position] => 28 [description] => Enjoy your morning coffee or evening cocktails under your covered back deck by the built-in firepit and outdoor tv [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/28.jpg [215x] => https://new.photos.idx.io/rt2/2812682/28/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/28/440x.jpg ) ) [29] => stdClass Object ( [position] => 29 [description] => Unwind and relax in your full-sized jacuzzi [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/29.jpg [215x] => https://new.photos.idx.io/rt2/2812682/29/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/29/440x.jpg ) ) [30] => stdClass Object ( [position] => 30 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/30.jpg [215x] => https://new.photos.idx.io/rt2/2812682/30/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/30/440x.jpg ) ) [31] => stdClass Object ( [position] => 31 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/31.jpg [215x] => https://new.photos.idx.io/rt2/2812682/31/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/31/440x.jpg ) ) [32] => stdClass Object ( [position] => 32 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/32.jpg [215x] => https://new.photos.idx.io/rt2/2812682/32/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/32/440x.jpg ) ) [33] => stdClass Object ( [position] => 33 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/33.jpg [215x] => https://new.photos.idx.io/rt2/2812682/33/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/33/440x.jpg ) ) [34] => stdClass Object ( [position] => 34 [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/34.jpg [215x] => https://new.photos.idx.io/rt2/2812682/34/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/34/440x.jpg ) ) [35] => stdClass Object ( [position] => 35 [description] => Welcome home [urls] => stdClass Object ( [original] => https://new.photos.idx.io/rt2/2812682/35.jpg [215x] => https://new.photos.idx.io/rt2/2812682/35/215x.jpg [440x] => https://new.photos.idx.io/rt2/2812682/35/440x.jpg ) ) ) ) [key] => rt-2812682 [added_at] => stdClass Object ( [$date] => 2025-04-03T01:04:00Z ) [source] => rt [self_link] => https://api.idx.io/listings/rt-2812682 )








































































- Bedrooms4
- Bathrooms3
- Half Baths1
- BasementCrawl Space
- FeaturesCeiling Fan(s), Hot Tub, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
- AppliancesDouble Oven, Gas Range, Dishwasher, Disposal, Dryer, Freezer, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer, Smart Appliance(s)
- HVACArray
- Fireplaces1
Interior Details
- ConstructionMasonite, Brick
- Built In2020
- Stories2
- ParkingGarage Door Opener, Attached
- Garage Bays2
- FeaturesGas Grill, Smart Lock(s)
- ServicesClubhouse, Dog Park, Fitness Center, Park, Playground, Pool, Underground Utilities, Trail(s)
- SewerPublic Sewer
- Lot DescriptionLevel
- Acres0.15