970.222.1020
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Berthoud » 80513 » 871 N County Road 23e, Berthoud, CO, 80513
$2,348,000

871 N County Road 23e, Berthoud, CO, 80513

4 Beds
3 Baths
3,464 Square Feet

Compensation

Buyer's Agency
3.00%
29 Acre Dream Horse Property Home. Fantastic location close to downtown Berthoud. Elegant 3500 sqft Spanish style home sits atop a hill with breathtaking views of the mountains and equestrian facility below. Whether you just want to keep your horses at your own top-notch facility with an established boarding/training business or start a new one, this setup is perfect. There is a gorgeous 14 stall barn, two full-size 20x60m riding arenas indoor-outdoor with Premier Equestrian footing and mirrors. Make this your equestrian oasis! This fabulous property has a profitable boarding/training business since 2009 that generates monthly profit and covers staff expenses to manage daily feeding, cleaning and property maintenance. Buyers have the option to work with the existing business and just enjoy the facility or start a new business if desired. Barn features include:1bed+1bath apartment for onsite barn manager; first class tack room with custom cedar-lined lockers and saddle racks for up to 18 riders; rider's restroom, horse spa wash rack w/ heat lamps and hot/cold water. Additional facility features include: 7 large pastures, longeing/warmup ring; 2 loafing sheds for 4 additional horses (18 horses total); ~1mi. galloping track around the property with rolling hills and beautiful scenery. Conveniently located close to Longmont, Loveland and the new TPC Colorado Country Club and golf course or water recreation at Carter Lake. Perfect for entertaining, this newly remodeled Spanish style home has an open concept floorplan that spans a large kitchen w/ island as well as dining and living area with soaring ceiling and stone face fireplace. Kitchen has large windows and patio/deck overlooking the equestrian facility and valley below. Main Suite has a stunning spa bathroom w/ large curbless shower, jacuzzi tub, large walk-in closet, large heated floor tiles, second fireplace and custom exotic hardwood vanity and cabinets. Walkout finished basement w/ 2 additional bedrooms.
Offered By
DAVID TRUJILLO Dtrujillo@thegroupinc.com,970-222-0340, The Group Inc - Centerra

Property Details

Property Type Residential
Status Active
Bedrooms 4
Bathrooms (Full) 2
Property Sub Type Residential-Detached
Square Feet 3,464
MLS # 9850110
Bathrooms (¾) 1

Market Trends

New Properties On Market
36
16% Increase In New Listings
Average Asking Price
$837,246
$91,387 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$272
$27 Increase In List Price/Sq. Ft.
Average Days On Market
16
27 Day Decrease In Days On Market
Data as of Dec 23, 2024. Remaining statistics above are calculated on activity within the period from Oct 01, 2024 to Nov 30, 2024.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

2638 Southwind Rd, Berthoud, CO 80513 Listing Photo  1
$2,700,000
2638 Southwind Rd
Berthoud, CO
4 Beds
|
5 Baths
|
6,000 Square Feet
Offered By Dominic East RE/MAX Alliance-FTC South
2672 Bluewater Rd, Berthoud, CO 80513 Listing Photo  1
$2,700,000
2672 Bluewater Rd
Berthoud, CO
4 Beds
|
6 Baths
|
7,494 Square Feet
Offered By Brian Terry Bosch Real Estate Group, LLC
524 E County Road 8, Berthoud, CO 80513 Listing Photo  1
$2,400,000
524 E County Road 8
Berthoud, CO
3 Beds
|
3 Baths
|
3,182 Square Feet
Offered By Jo Klimecki HomeSmart Realty
2100 Scottsdale Rd, Berthoud, CO 80513 Listing Photo  1
$2,400,000
2100 Scottsdale Rd
Berthoud, CO
4 Beds
|
6 Baths
|
5,566 Square Feet
Offered By Laura Gippert RE/MAX Alliance-FTC Dwtn
Information deemed reliable but not guaranteed by the MLS. Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2024 IRES. Property data was last updated on 9/5/2024 at 12:00 am