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 = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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;

37046 Golden Eagle Ct
Severance, CO 80550
Catherine Rogers with C3 Real Estate Solutions, LLC, original listing - (970) 225-5154

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,385,000
Beds: 5
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 5423 Square Feet
Agency: C3 Real Estate Solutions, LLC
Agency Phone: (970) 225-5154

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Perfectly located on one of the best lots that Soaring Eagle Ranch has to offer! Enjoy unrivaled Panoramic Rocky Mountain Views in this timeless Colorado Prairie style (all stone and stucco) main floor primary suite - Crown Jewel from Sapphire Custom Homes on 3.216 acres with 2 tranquil water features! Plenty of privacy + space between neighbors, backs to large private acreage. Garage space? Wow! ...could fit 6 smaller cars in the attached heated + finished garage 34' deep 9ft doors + this amazing property also features a newer insulated shop at 47 X 31 (2 electrical heaters + wood burning stove, 16' RV door.) Soaring Ceilings w/ 2nd story windows, Exquisite mouldings, all maple cabinetry, trim, casing + HW floors, newer plush carpet- freshly painted interior. Looking for the perfect Colorado Sunset? You will find it here - on the massive west facing covered concrete patio or the oversized 2nd level covered balcony! Cozy up to the gas firepit or enjoy the private covered hot tub patio, the Great Outdoors awaits! Newer professionally finished + permitted basement in 2021 complete with an Innovative Theater room, Exercise area (equipment included) + generous wet bar area, designed for the ultimate entertainer, with ample spaces for outdoor enjoyment, lush landscaping (oversized pond) every moment is a retreat! 4,738 finished sqft + 5,423 total (storage!) 5 Spacious Bdrms, 4 Baths + a french door office right off the foyer. Primary Wing features a full 5 piece bathroom suite, walk-in shower and oversized jetted garden tub, spacious dual WICs! HVAC: Dual Zones, H.E. Furnaces, Tankless H2O heater, Stone Gas F/P graces the main level, Spacious Eat-in Commercial style gourmet kitchen features a 48" Gas range, large walk in pantry, loaded w/ cabinetry and granite countertop space. *HOA provides non-potable water in the spring/summer months! All appliances included, convenient utility sink & cabinetry + active radon mitigation system. Extensive Inclusions!
MlsNumber: --
ListingId: 1019018


Listing Provided By: C3 Real Estate Solutions, LLC, original listing
Phone: (970) 225-5154
Office Phone: (970) 225-5154
Agent Name: Catherine Rogers
Disclaimer: Copyright © 2024 Information and Real Estate Services, LLC. 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 = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 Kelly Giddens
Kelly Giddens
ASCIIBerkshire Hathaway HomeServices Rocky Mountain, REALTORS
Call Today!: (503) 866-5962

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App