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 = 277 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 = 277 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 = 277 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;

48033 Cottonwood Ln
Burlington, CO 80807
Virgil George with Rocking X Land Company, original listing - (719) 346-5420

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,950
Beds: 6
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5038 Square Feet
Agency: Rocking X Land Company
Agency Phone: (719) 346-5420

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Luxurious Countryside Estate on Expansive GroundsWelcome to 48033 Cottonwood Lane, Burlington, CO 80807, a sprawling estate that defines luxury living in a peaceful, rural setting. This magnificent home, set on just shy of 5 acres, boasts over 5,000 square feet of elegantly designed living space, offering six spacious bedrooms and 3.5 baths, perfect for accommodating family living and entertaining friends.Upon entering, the gas fireplace and large Livingroom immediately sets a tone of warmth. The residence is equipped with an advanced climate control system, featuring both forced air and radiant heating, to ensure ultimate comfort throughout Colorado's changing seasons.Culinary enthusiasts will delight in the gourmet kitchen, which seamlessly merges with the dining and living areas, creating an open, inviting space for gatherings. The kitchen's state-of-the-art appliances and spacious design will inspire your inner chef and make hosting a breeze.For fitness enthusiasts, the fully appointed weight room presents a private, convenient space to stay active and healthy without leaving the comfort of home. Post-workout, unwind in the entertainment area, which features a sophisticated wet bar, perfect for hosting friends and family or enjoying a quiet evening in.The estate's outdoor living is just as impressive, with a beautifully constructed pergola offering a serene setting for outdoor dining or relaxation. The centerpiece, a gas fire pit, provides warmth and ambiance, making it an ideal spot for evening gatherings under the stars. Not to be overlooked, the property includes a backup generator, ensuring peace of mind and uninterrupted comfort, regardless of the weather. Located just outside of town, this estate offers the tranquility of countryside living with the convenience of proximity to Burlington's amenities. The nearly 5-acre grounds offer endless possibilities for gardening, leisure, and exploration, all within your private oasis.
MlsNumber: --
ListingId: 1002571


Listing Provided By: Rocking X Land Company, original listing
Phone: (719) 346-5420
Office Phone: (719) 346-5420
Agent Name: Virgil George
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App