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

2330 Rampart Range Road
Woodland Park, CO 80863

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 5
Baths: 7
Status: Active
SqFt: 11009
Agency: RE/MAX Properties, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2010
Notes: "Mountains are the Beginning and the End of all Natural Scenery" John Ruskin.<br /> <br /> And in this Home, your Natural Scenery goes on Forever.<br /> <br /> Have you ever experienced a home you can actually 'FEEL' when you walk inside? One that is so stunning yet welcoming, warm yet lights a fire in your soul, & offers the most incredible view of Pikes Peak? This home, promises to create memories for a lifetime & truly make you feel as though you are breathing in the sun, the peace, & the mountains in one beautiful breath.<br /> The absolutely awe-inspiring landscape view of Pikes Peak will greet you while 'soaring' proudly outside nearly every window & door. It can't hide & you are grateful. On the main level, you will find a Gourmet Kitchen, which boasts Dual Ovens & Dishwashers along w/ Granite Counters, a large Pantry & more Cabinetry than you can imagine. You can cook, entertain & dance as you prepare your favorite meal. There is also a beautiful Office, Multiple Living Spaces w/ stunning surround views of Pikes Peak, a 3-sided Floating Fireplace, Spacious Dining Areas, 2 Luxurious Master Suites & a Deck w/ access from the Living Areas & both Master Suites.<br /> The Lower Level features equally spacious Living Areas w/ plenty of room for relaxing, visiting & play. Also, a Floating Fireplace, Sunny Atrium, a 3- Room Office Suite, Three Full Bedroom Suites, plus a Bonus Room for an additional Living Space/Theatre Room. Did I forget to mention 2 Wet Bars, a Wine Room/Workout Room & the Sauna? This level offers a walk-out from the Living Space & 2 of the Suites so you can continue to Embrace those beautiful Pikes Peak Views. And last, but certainly not least, the nearly 4 Acres of Land which play host to the awesome mountain views & thousands of Aspen & Evergreen. A Historic Cabin, Bonus Building & a Completely Finished Barn/Workshop, plus loafing sheds & a large lot complete this one of a kind property. There is nothing that compares. Don't you think it is time to call it 'Home?'
MlsNumber: 7554354


Listing Provided By: RE/MAX Properties, Inc., original listing
Name: RE/MAX Properties, Inc.
Phone: (719) 576-5000
Office Name: RE/MAX Properties Inc.
Office Phone: (719) 570-9000
Agent Name: Karen Schaefer
Disclaimer: Copyright © 2024 Pikes Peak Association of REALTORS. 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 = 305 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 Joyce Wik
Joyce Wik
ASCIIBroker's Guild Real Estate
Call Today!: (719) 374-2034

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App