Title Page Background
DEBUG FN args: Array ( [0] => 279 [1] => [2] => [3] => agent ) BEFORE: Site: 279 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 279 Igate: njhud LocID: 279 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 = 279 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 279 [1] => [2] => [3] => lender ) BEFORE: Site: 279 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 279 Igate: njhud LocID: 279 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 = 279 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 279 [1] => [2] => [3] => other ) BEFORE: Site: 279 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 279 Igate: njhud LocID: 279 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 = 279 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

445 Mt. Hope
Twin Lakes, CO 81251

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $195,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Worth Clark Realty

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Window Features

Parking Features: Garage, Carport
View: Lake, Mountain
Waterfront Features: Lake

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Pan Ark

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Land-Unimproved Land
Year Built: --
Notes: Escape to the pristine beauty of Twin Lakes, Colorado with this stunning .46-acre parcel of land. Nestled in the heart of the Rockies, this plot offers the perfect canvas for your mountain retreat dreams. Boasting a picturesque view of one of Colorado's most breathtaking mountain lakes, this property is a rare gem awaiting your vision.<br /> <br /> With nearly half an acre of space, you'll have ample room to design your dream getaway or permanent residence, surrounded by the tranquility of nature. This parcel features a great building site, providing an ideal foundation for your future home.<br /> <br /> Located adjacent to the renowned Colorado Trail, outdoor enthusiasts will delight in the endless recreation opportunities right at their doorstep. Spend your days fishing for trout, paddleboarding across the crystal-clear waters, or exploring the lake by boat. For those who prefer to stay on land, the surrounding area offers exceptional hiking and biking trails, allowing you to immerse yourself in the stunning beauty of the Rocky Mountains.<br /> <br /> Seize this opportunity to own a slice of Colorado paradise, where serene lake views and majestic mountain vistas await. Don't miss your chance to make Twin Lakes your home. Inquire now!
MlsNumber: --


Listing Provided By: Worth Clark Realty, original listing
Phone: (719) 966-9588
Office Phone: (800) 991-6092
Agent Name: Coby Vidakovich
Disclaimer: Copyright © 2024 ROCC/REcolorado. 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