stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active Under Contract
[last] => Active
[changed] => 2024-08-29T13:26:00
)
[ml_number] => 2690375
[price] => stdClass Object
(
[amount] => 680000
[original] => 690000
[last_changed_on] => 2024-08-15T10:30:00
)
[listing_flags] => Array
(
[0] => Inspection
[1] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2024-08-10T04:00:00Z
)
[description] => Do you like boating, swimming, golfing, fishing, hiking? Then look no more! Here is the perfect custom-built home for you. This home has a 18x36 in-ground swimming pool w/fountain, access to the golf course. It is minutes to Tims Ford Lake, Twin Creeks Marina and hiking in the Smoky Mts. The house features 3 BR/2BA, Living Rm w/gas fireplace & cathedral ceiling, Kitchen has large island w/seating for guest, a wet bar w/sink between Kitchen & Liv. Room, quartz countertops, SS Appliances, Breakfast Nook w/beautiful, wood trey ceiling. Formal Dining Rm has triple treyed ceiling & is open to Kitchen & Liv. Rm, Flex Rm, Florida room w/wood ceiling, Primary ensuite has triple treyed ceiling, Primary Bath has marble walk-in shower & spa tub. Beautiful woodworking throughout home & crown molding, Screened porch, a covered porch outside the Primary Bedroom, oversized 3 car garage w/stairs going to huge walk-in floored attic, Walk-in storage under house for lawn mower & pool equipment.
[location] => stdClass Object
(
[city] => Winchester
[state] => Tennessee
[postal_code] => 37398
[county] => Franklin County, TN
[subdivision] => Queen S Estate
[street] => stdClass Object
(
[number] => 469
[name] => Pickney Rd
[full] => 469 Pickney Rd
)
[directions] => From Winchester Square turn on College St. Turn right on Shadowbrook Rd. At stop sign turn right on Pickney Rd. Follow Pickney to Queens Estates turn right, House on left.
[coordinates] => stdClass Object
(
[latitude] => 35.169725
[longitude] => -86.087153
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.087153
[1] => 35.169725
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 3147
[source] => Professional Measurement
)
[stories] => 1
[built_in] => 2007
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
[basement] => Array
(
[0] => Crawl Space
)
)
[pool] => Array
(
[0] => In Ground
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Entry Foyer
[2] => Extra Closets
[3] => Pantry
[4] => Storage
[5] => Walk-In Closet(s)
[6] => Wet Bar
)
[appliances] => Array
(
[0] => Dishwasher
[1] => Disposal
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[services] => Array
(
[0] => Golf Course
)
[parking] => Array
(
[0] => Attached - Side
[1] => Concrete
)
[parking_spaces] => 3
[features] => Array
(
[0] => Irrigation System
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 175X157.1
[acres] => 0.64
)
[description] => Array
(
[0] => Corner Lot
)
)
[school] => stdClass Object
(
[elementary] => Clark Memorial School
[junior] => South Middle School
[high] => Franklin Co High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2024-08-29T17:26:00Z
)
[office] => stdClass Object
(
[name] => WEICHERT, REALTORS Joe Orr & Associates
[broker_id] => 2215
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Teresa
[last] => Young
)
[phone] => stdClass Object
(
[preferred] => 9312739808
[mobile] => 9312739808
[fax] => 9314615159
)
[agent_id] => 4970
)
)
[media] => stdClass Object
(
[virtual_tours] => Array
(
[0] => https://properties.615.media/videos/a4790e82-f8a7-4cee-a871-f7afb0e7b58f
)
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Front view of house. The sidewalk goes around the house to large walk-in storage area under the house for your lawn mower and pool equipment.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/0.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => Lots of room on this front porch.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/1.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => View of the foyer with beautiful front door with transom and sidelights.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/2.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => Office/Den is to the right of the Foyer.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/3.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => View of Dining Room from the Kitchen. Notice all the beautiful wood crown molding throughout the room.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/4.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Formal Dining area is to your left as you enter the foyer. Notice the beautiful triple treyed ceiling!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/5.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Kitchen has wet bar and storage cabinet for glasses and liquor.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/6.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => You can sit at the large Island in the Kitchen.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/7.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Kitchen has custom cabinets and quartz countertops.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/8.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => View of Kitchen from the Breakfast Nook.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/9.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Kitchen has gas cooktop, tiled backsplash, and stainless-steel appliances and tile floors.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/10.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => Crown Molding is stained wood.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/11.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Breakfast Nook with bay window overlooking the pool is open to the Kitchen.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/12.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Beautiful treyed tongue & groove-stained wood ceiling in Breakfast Nook.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/13.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Great Room has vaulted ceiling.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/14.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Great Room is open to the Kitchen and Dining Room.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/15.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Great Room has beautiful doors and floor length windows that look out onto the screened porch and pool area.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/16.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => Florida Room with wood ceiling and lots of windows looking into the back yard and pool area.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/17.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => The Flex Room has double treyed ceiling with crown molding of stained wood.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/18.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[description] => Laundry Room has lots of cabinets for storage, sink, countertop for folding clothes and tile floors.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/19.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => Primary Bedroom has triple treyed ceiling, Wood crown molding double door that leads to a covered porch that overlooks the inground pool.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/20.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => Primary Bedroom has a smaller closet plus a huge walk-in closet.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/21.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Primary Bath with jetted spa tub, marble tile shower and double vanity.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/22.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => View of the jetted tub and beautiful windows for lots of natural light in the bathroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/23.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => Another view of the jetted tub.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/24.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => View of the walk-in shower.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/25.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => Walk-in closet in Primary Bedroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/26.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Another view of the walk-in closet.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/27.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[description] => 2nd Guest Bedroom with arched full length window.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/28.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[description] => Another view of the bath between the Guest Bedrooms.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/29.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[description] => Walk-in shower in Jack-N-Jill Bath.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/30.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[description] => Jack-N-Jill Bath between the 2 Guest Bedrooms.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/31.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[description] => Guest Bedroom with jack-in-jill bath.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/32.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[description] => Hall between Guest Bedrooms
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/33.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[description] => Half bath is between the 2 Guest Bedrooms.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/34.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[description] => Screened in porch with tile floors.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/35.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[description] => Ingound salt water pool.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/36.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/36/440x.jpg
)
)
[37] => stdClass Object
(
[position] => 37
[description] => Pool is 18x36 and has a fountain on the side of the pool.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/37.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/37/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/37/440x.jpg
)
)
[38] => stdClass Object
(
[position] => 38
[description] => Back view of home and pool.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/38.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/38/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/38/440x.jpg
)
)
[39] => stdClass Object
(
[position] => 39
[description] => Pool area is completely fenced.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/39.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/39/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/39/440x.jpg
)
)
[40] => stdClass Object
(
[position] => 40
[description] => Covered porch with entrance to the Primary Bedroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/40.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/40/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/40/440x.jpg
)
)
[41] => stdClass Object
(
[position] => 41
[description] => Aerial view of home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/41.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/41/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/41/440x.jpg
)
)
[42] => stdClass Object
(
[position] => 42
[description] => Great neighborhood to live in.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/42.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/42/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/42/440x.jpg
)
)
[43] => stdClass Object
(
[position] => 43
[description] => View of house and pool.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/43.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/43/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/43/440x.jpg
)
)
[44] => stdClass Object
(
[position] => 44
[description] => Home and pool picture from the rear.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/44.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/44/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/44/440x.jpg
)
)
[45] => stdClass Object
(
[position] => 45
[description] => Side view of pool and back of home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/45.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/45/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/45/440x.jpg
)
)
[46] => stdClass Object
(
[position] => 46
[description] => Another view of pool and back of home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/46.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/46/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/46/440x.jpg
)
)
[47] => stdClass Object
(
[position] => 47
[description] => View of area around the home.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/47.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/47/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/47/440x.jpg
)
)
[48] => stdClass Object
(
[position] => 48
[description] => Outline of lot.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2690375/48.jpg
[215x] => https://new.photos.idx.io/rt2/2690375/48/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2690375/48/440x.jpg
)
)
)
)
[key] => rt-2690375
[added_at] => stdClass Object
(
[$date] => 2024-08-10T14:12:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2690375
)
Interior Details
- Bedrooms3
- Bathrooms2
- Half Baths1
- BasementCrawl Space
- FeaturesCeiling Fan(s), Entry Foyer, Extra Closets, Pantry, Storage, Walk-In Closet(s), Wet Bar
- AppliancesDishwasher, Disposal
- HVACArray
- Fireplaces1
Exterior Details
- StyleTraditional
- ConstructionBrick
- Built In2007
- Stories1
- PoolIn Ground
- ParkingAttached - Side, Concrete
- Garage Bays3
- FeaturesIrrigation System
- ServicesGolf Course
- SewerPublic Sewer
- Lot DescriptionCorner Lot
- Lot Dimensions175X157.1
- Acres0.64