Title Page Background
DEBUG FN args: Array ( [0] => 3113 [1] => [2] => [3] => agent ) BEFORE: Site: 3113 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3113 Igate: njhud LocID: 3113 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3113 AND i.igate IN ('wahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3113 [1] => [2] => [3] => lender ) BEFORE: Site: 3113 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3113 Igate: njhud LocID: 3113 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3113 AND i.igate IN ('wahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3113 [1] => [2] => [3] => other ) BEFORE: Site: 3113 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3113 Igate: njhud LocID: 3113 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3113 AND i.igate IN ('wahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1987 N Spirit Dance Road
Jackson, WY 83001
DeNesha Anderson with Century 21 Jackson Hole, original listing - (307) 732-8181

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $9,995,000
Beds: 4
Baths: Full: 3, ½: 1, ¾: 1
Status: Active
SqFt: 4995 Square Feet
Agency: Century 21 Jackson Hole
Agency Phone: (307) 732-8181

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Stroll down the winding tree-lined driveway to your privately situated Midcentury Modern/Western jewel affectionately called the 'Trout House'. Designed by its original owners-an avid angler and pilot-this home was meticulously crafted by local acclaimed architects Ward + Blake to blend the passions of the homeowners into their perfect Jackson home. The goal was to evoke a great room inspired by an airport hangar's vaulted, curved interior while adding whimsical trout touches throughout including the stained glass window pane displaying a multi-colored trout in the Master Bedroom and multiple concrete trouts embedded in the steps leading up to the front door. -See More Tab- Elements of a thoughtfully designed living space are evident throughout the virtually 5000 square feet home. The architecturally enhanced custom cabinetry throughout the home creates definition in each room while providing functional storage in large compartments hidden behind accessible walls. An awe-inspiring fireplace on the main floor will complement any occasion from a formal dinner or a quiet evening. Enjoying a game of pool in the lower level begins by descending the sweeping ever-widening staircase. The lower second living area combined with a large recreation room and office nook complete the ground level entertaining space. However, there is no better place to relax and enjoy the unparalleled views of the Tetons and ranchlands below, than from the recently upgraded balcony and lower deck. The Ipe Brazilian hardwood decking offers year-round access and easy maintenance. Wildlife is abundant at Spring Creek Ranch and this property boasts frequent moose, elk, and wild turkey sightings. <br /> <br /> The bedrooms are not just a place to sleep but separate sanctuaries themselves. An indulgent Master Suite, as detailed in the Big Sky Journal, is accessed from a lighted glass bridge to a private wing complete with new carpet, floor to ceiling windows that frame the Teton range, a sumptuous bathroom and custom walk-in closet. The 3 ensuite guest bedrooms, each with tub, towel-warmer, patio access and Teton views will wow any guest.<br /> There is an oversized 3-car garage with numerous storage lockers for all the Jackson hole toys and gear. The house provides air conditioning, humidification, radiant and forced-air heating, softened water, integrated television and stereo audio system, electronically-operated shades and black-out coverings. The upgrade list is extensive including most systems: gas boiler, water heater, recirculation pump, water softener, crawl-space copper piping, new expansion tanks, new check valves in the recirculation system, new whole-house pressure valve, and burglar/fire/carbon monoxide alarm. Additionally, there were extensive landscaping upgrades made throughout the past five years including full-grown trees, bushes, flower beds, and stone paths. Enjoy all the amenities of Spring Creek Ranch including pool, hot tubs, tennis courts, locker rooms, spa services, and shuttles to town, airport, and ski slopes. Zoned for short-term rentals and boasts a lucrative annual rental income.
MlsNumber: --
ListingId: 24-2235


Listing Provided By: Century 21 Jackson Hole, original listing
Phone: (307) 690-6723
Office Phone: (307) 732-8181
Agent Name: DeNesha Anderson
Disclaimer: Copyright © 2024 Teton Board of REALTORS&#174;. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App