Title Page Background
HFQUERY 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 = 568 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 568 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 568 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

16480 Goodson Road
Caldwell, ID 83607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 3
Baths: 5
Status: Active
SqFt: 5528
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2004
Notes: The Goodson Road Estate features a 5,528 SqFt Spanish-style estate on 10+ acres in Caldwell, Idaho. The property features a well appointed home, two casitas, a motocross track, and manicured landscaping including a chlorinated swimming pond with waterfall and panoramic 360-degree views. Pass through the iconic Spanish arches and ascend the tranquil, tree-lined driveway to unveil a breathtaking estate with sweeping panoramic views of Squaw Butte, Bogus Basin, and the Owyhee Mountains. Explore manicured lawns surrounding a serene waterfall and take a refreshing dip in the crystal-clear chlorinated-swimming pond. One can venture out on the adrenaline-pumping motocross track while soaking in the incredible scenery.       Step into luxury with this magnificent Spanish-style estate located in Caldwell, Idaho. Enjoy the manicured lawns and exceptional landscaping, a freshwater pond with waterfall, and 360-degree panoramic views. This spacious custom-built residence spans 5,528 square feet and boasts 78 windows, ensuring ample natural light throughout. Inside, fully insulated interior walls and floors offer comfort and privacy. The home is adorned with exquisite details and upgrades. A grand foyer welcomes guests with a captivating water feature and grand staircase, while the heart of the home showcases custom kitchen cabinetry and a double oven. A well-designed floor plan includes a bar area for entertaining, an office with a private entrance, and a mud room/laundry room featuring abundant storage and a shower. Additionally, a theater room with a kitchenette, capable of fitting 15 people, provides the perfect setting for movie nights. The daylight basement area is designed for automotive enthusiasts, featuring a custom car showroom with finished epoxy flooring, along with a sports bar. The main garage, accommodating three cars, is fully finished and equipped with a central vacuum system. The master bedroom offers luxurious amenities, including a private covered deck, a dual-sided fireplace, a jetted tub, and a walk-in custom steam shower equipped with ten shower heads. For guests, two separate guest casitas with kitchenettes ensure comfortable accommodations, making hospitality a breeze. With its picturesque surroundings and luxurious amenities, this exquisite estate presents an ideal opportunity to transform into a charming bed and breakfast. The property is near the heart of Idaho's wine country within a few miles of the Snake River. Outdoor recreation abounds in the Caldwell area. The Boise River meanders through the north portion of the city while to the south is the beautiful Lake Lowell. Both of these natural water features provide plenty of activities such as boating, fishing, swimming, and hiking. Nearby recreational amenities include: Bitner Vineyards Snake River St. Chappelle Winery Timberstone Golf Course Marsing Island Park Lake Lowell Downtown Caldwell Deer Flat National Wildlife Refuge Jump Creek Falls Givens Hot Springs Wilson Spring Ponds Caldwell, Idaho experiences a semi-arid climate characterized by hot, dry summers and relatively mild winters. The region is part of the Intermountain West, which influences its weather patterns and climate conditions. Caldwell, Idaho, located in Canyon County, has a rich history tied to agriculture and railroads. It's home to the College of Idaho and boasts a diverse economy with a focus on agriculture, manufacturing, and healthcare. The city offers cultural events, including the Caldwell Night Rodeo, and recreational activities in the surrounding Treasure Valley. With a growing population, Caldwell maintains its historic charm while embracing new developments and community initiatives, making it an appealing place to live and visit in southwestern Idaho.
MlsNumber: 11243275


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (970) 674-1990
Office Name: Hayden Outdoors Real Estate
Office Phone: (970) 674-1990
Agent Name: Austin Callison
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY 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 = 568 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for D'Nelia Zapata & Monica Coronado
D'Nelia Zapata & Monica Coronado
ASCIIRE/MAX Executives
D'Nelia: (208) 685-9956
Monica: (208) 890-7179

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App