stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Pending
[last] => Pending
[changed] => 2025-05-24T15:07:01
)
[ml_number] => 2890682
[price] => stdClass Object
(
[amount] => 2169900
[original] => 2169900
[last_changed_on] => 2025-05-24T15:07:01
)
[listing_flags] => Array
(
[0] => New
)
[description] => WOW! MAJOR Price Reduction! Discover the prestige and amazing views of Calistoga by award-winning Turnberry Homes. This is your rare opportunity to own a masterpiece in such a desirable location. Step into the breathtaking Sunderland II, a stunning 5-bedroom home designed for both stateliness and comfort. From the moment you enter the soaring 2-story foyer, you’ll be captivated by the towering ceilings, intricate moldings, and a sweeping staircase bathed in natural light. Main-Level Luxury & Functionality: Private Home Office for work or study, Expansive Kitchen seamlessly flowing into the Family Room—perfect for gatherings, Butler’s Pantry & Walk-in Pantry for effortless entertaining, Front & Rear Staircases for convenience and elegance, Primary & Guest Suites on the main level for multi-generational living, Spa-Like Primary Bath with separate vanities & walk-in closets. Upper-Level Comfort & Extra Spacious Bonus Room for relaxation or entertainment, Generous Walk-in Storage for easy organization, Three-Car Garage for ample parking & storage, Every detail has been designed with luxury and convenience in mind, from full sod and irrigation to the incredible included features that set this home apart from the rest. Don’t miss your chance to own a piece of Calistoga's finest.
[location] => stdClass Object
(
[city] => Brentwood
[state] => Tennessee
[postal_code] => 37027
[county] => Williamson County, TN
[subdivision] => Calistoga
[street] => stdClass Object
(
[number] => 1900
[name] => Palisades Dr
[full] => 1900 Palisades Dr
)
[directions] => I-65 to East on Moores Lane, Continue left on Moore's Lane at light, Right on Wilson Pk, Left on Split Log Rd, Right at light to continue on Split Log Rd, Right on Sam Donald Rd. New Calistoga neighborhood is on the right. For GPS Use: 9830 Sam Donald Rd
[coordinates] => stdClass Object
(
[latitude] => 36.040176
[longitude] => -86.758545
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.758545
[1] => 36.040176
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 4974
[source] => Professional Measurement
)
[stories] => 2
[built_in] => 2025
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 5
)
[baths] => stdClass Object
(
[full] => 5
[half] => 1
)
[basement] => Array
(
[0] => Crawl Space
)
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Entrance Foyer
[2] => Extra Closets
[3] => Pantry
[4] => Storage
[5] => Walk-In Closet(s)
[6] => Primary Bedroom Main Floor
)
[appliances] => Array
(
[0] => Dishwasher
[1] => Disposal
[2] => Microwave
[3] => Double Oven
[4] => Electric Oven
)
[hvac] => Array
(
[0] => Array
(
[0] => Dual
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 2
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[services] => Array
(
[0] => Underground Utilities
)
[parking] => Array
(
[0] => Garage Door Opener
[1] => Attached
)
[parking_spaces] => 3
[land] => stdClass Object
(
[size] => stdClass Object
(
[acres] => 1.23
)
[description] => Array
(
[0] => Sloped
)
)
[school] => stdClass Object
(
[elementary] => Jordan Elementary School
[junior] => Sunset Middle School
[high] => Nolensville High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-05-24T19:07:01Z
)
[office] => stdClass Object
(
[name] => Onward Real Estate
[broker_id] => 19106
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Susan
[last] => Gregory
)
[phone] => stdClass Object
(
[preferred] => 6152075600
[mobile] => 6152075600
[fax] => 6153708013
)
[agent_id] => 7237
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/0.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/1.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/2.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/3.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/4.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/5.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/6.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/7.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/8.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/9.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/10.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/11.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/12.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/13.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/14.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/15.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/16.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/17.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/18.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/19.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/20.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/21.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/22.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/23.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/24.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/25.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/26.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/27.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[description] => Sunderland II -Photos are of another available Inventory Home in Laguna, Franklin TN priced at $1,999,900, MLS #2890674
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2890682/28.jpg
[215x] => https://new.photos.idx.io/rt2/2890682/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2890682/28/440x.jpg
)
)
)
)
[selling_agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Shannon
[last] => Pope
)
[phone] => stdClass Object
(
[preferred] => 6155334862
[mobile] => 6155334862
)
)
)
[key] => rt-2890682
[added_at] => stdClass Object
(
[$date] => 2025-05-24T19:07:01Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2890682
)
