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

24420 County Road 39
Akron, CO 80720

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 8
Baths: Full: 1
Status: Active
SqFt: 3618 Square Feet
Agency: Town Square Realty

Map Details Show Map | Show StreetView




House Features

Architectural Style: Ranch
Rooms: Bathroom 1, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5

Neighborhood/Schools

Elementary School/District: Akron/Tippecanoe Valley
Middle/Junior High School/District:
High School/District: Akron
Subvidision Name: N/A

Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential Multi Family-Other
Year Built: 1909
Notes: This exceptional estate features THREE SEPARATE RESIDENCES, a year-round pond, two expansive greenhouses, 14.5 acres, a well-equipped shop, and a history of cultivation potential. Welcome to a lifestyle that combines rural charm with modern amenities. The charming THREE BEDROOM, ONE BATH HOUSE (1069 sq ft) has undergone significant updates, including new electrical, a new roof, and a renovated kitchen. Enjoy modern living in a thoughtfully updated MOBILE HOME featuring THREE BEDROOMS, TWO BATHS (1280 sq ft) and an open concept kitchen and living room area. The perfect blend of comfort and style. The large shop is a versatile space ready for various projects or potential business ventures. Its UPSTAIRS LIVING QUARTERS (1269 sq ft) make it a unique and adaptable area for creative endeavors. Two fully HEATED AND COOLED GREENHOUSES (2160 and 2880 sq ft) equipped with a water heater and sinks provide the perfect environment for year-round cultivation. Included are various growing equipment such as lights, pots, trays, and more, offering endless possibilities for gardening enthusiasts.
MlsNumber: --


Listing Provided By: Town Square Realty, original listing
Phone: (970) 522-2009
Office Phone: (970) 522-2009
Agent Name: Erin Debus
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