1 year on rocket

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

$2,348,000

Home List Price

$10,000*

Closing Credit

4 Bedrooms
2 Full Baths, 1 Partial
3,351 SqFt
$701/SqFt
House

Location

Image provided by Mapbox

Get An Agent. Get A Mortgage.

Save BIG.

Rocket Homes logo

871 N County Road 23e, Berthoud$2,348,000

Buyer Closing Credits

$10,000*

1.25% Loan Amount

Rocket Homes logo

Still Have Questions? Contact Us.

Contact Us Phone Number1 (855) 200-2001

Property Highlights

Home TypeSingle Family Residence
Attached Garage2 spaces
Year Built1995
HeatingBaseboard, Radiant
CoolingOther
BasementYes
FireplaceGas, Living Room
ViewMountain(s)
MLS #9850110
Lot Size29.00 Acres
StatusActive

About 871 N County Road 23e

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.

Property Details

Property Features

Property Information:

  • Year Built: 1995
  • Living Area: 3,351 SqFt

Listing Office:

  • Office Name: The Group Inc - Centerra
  • Office Phone: (970) 222-0340
  • Listing Agent: DAVID TRUJILLO

Interior Features

Interior Information:

  • Appliances: Dishwasher, Oven, Range
  • Basement: Yes
  • Flooring Type: Bamboo, Laminate, Vinyl
  • Interior: Eat-in Kitchen, Five Piece Bath, Kitchen Island, Pantry, Vaulted Ceiling(s)
  • Fireplace: Gas, Living Room

Bedroom and Bathroom Information:

  • Partial Bathrooms: 1
  • Full Bathrooms: 2
  • Total Bedroom Count: 4

Exterior Features

Exterior Information:

  • View: Mountain(s)

Parking Information:

  • Garage Space: 2 spaces
  • Attached Garage: Yes

Lot Features

Lot Information:

  • Lot: Level, Sloped
  • Lot Size: 29.00 Acres

Utilities

Utilities Information:

  • Heating: Baseboard, Radiant
  • Cooling: Other

Other

Directions Information:

  • Directions: From Berthoud head west on Hwy 56/CR 8 which curves to the north and becomes CR 23, Go north approx. ½ mile to CR 8E, Go west and go approx. ½ mile to CR 23E the go south to this property.

Price Information

Listing Price Info

Price Summary:

  • List Price: $2,348,000
  • Price Per SqFt: $701/SqFt
House and calculator

What can I afford?

Understand what home price range makes sense for your budget.

Housing Market Comparison

See how this home compares to others in Berthoud, CO.

Med. Sold Price

$599.9K

Med. Price/SqFt

$305

Avg. Days On Market

68

# of Sold Homes

31

871 N County Road 23e vs Berthoud

501 DAYS ON ROCKET

+433 Days

$2,348,000

+$1.7M More

$701/SqFt

+$395 More

KEY TAKEAWAY

This property is $1.7M more than the Median Sold Price and $395/SqFt more than other homes in Berthoud, CO.

Based on homes sold in the last 12 months

MLS Details

MLS Information:

  • MLS Name: RECOLORADO
  • MLS Number: #9850110

Listing Office:

  • Office Name: The Group Inc - Centerra
  • Office Phone: (970) 222-0340
  • Listing Agent: DAVID TRUJILLO

IDX Listings courtesy of REColorado as distributed by MLS GRID.

All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

IDX ©2024 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved.

Presented by Rocket Homes Real Estate, LLC
Licensed in Colorado Brokerage License # EC. 100073419

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Rocket Homes Real Estate, LLC are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.

The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.

All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.

METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.

Equal Housing

© 2024 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 300
Greenwood Village, CO 80111 USA

ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 12/22/2024, 11:12:51 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Property Sales & Tax

We're sorry, we currently don't have sales or tax history data for this listing.

Payment Calculator

$11.7K

Per Month

Recommended Financing

30-Year Fixed

Rate/APR

7.5% / 6.68%

Total Monthly Payment

$7,106

Schools

Schools Nearby

The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.

Nearby Schools

school-card-donut-956755
7
/10
  • Ivy Stockwell Elementary School

  • 175 5th St

  • 4.33 miles

  • Public District Grades KG-5

school-card-donut-956756
6
/10
  • Berthoud Elementary School

  • 560 Bunyan Ave

  • 4.33 miles

  • Public District Grades PK-5

school-card-donut-956757
7
/10
  • Carrie Martin Elementary School

  • 4129 Joni Ln

  • 4.43 miles

  • Public District Grades PK-5

Neighborhood

What Are The Neighbors Like?

The neighbors living near this home have an average income of $106,069. The most common annual income of people living in Berthoud, CO is between $100k-200k. Most families are married, no kids. The majority of residents in this area have post secondary degree education.

All data provided by Home Junction and Claritas

Frequently Asked Questions About 871 N County Road 23e

What is the listing price of this property?

The listing price of 871 N County Road 23e property is $2,348,000.

What type of property is this?

The property 871 N County Road 23e is a house located in Berthoud, Colorado, 80513.

Is this property for sale now?

Active Listing: 871 N County Road 23e is For Sale (Active/New) which means the seller is accepting offers.

How many bedrooms and bathrooms does this property have?

The property at 871 N County Road 23e has 4 bedrooms and 2 full and 1 half bathrooms.

What is the square footage of this property?

The property 871 N County Road 23e is 3,351 SqFt (source: MLS/tax record).

Which year was this property built?

The year of construction for 871 N County Road 23e is 1995.

Rocket HomesColoradoLarimer CountyBerthoud80513871 N County Road 23e

This home is located at 871 N County Road 23e in Berthoud, CO and zip code 80513. This 3,351 square foot home, which was built in 1995, sits on a 29.00 acre lot. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since August 08, 2023 and is currently priced at $2,348,000.

While more than 3 listings in Berthoud, CO in November 2024 were sold above asking price, there were more than 16 listings sold at asking price, and more than 12 were sold below. The number of homes for sale in Berthoud, CO increased by 1.5% between October 2024 and November 2024. While the average time on the market in November 2024 was 68 days, the median list price was $599,960.

From Rocket Homes Real Estate and based on county public records data.

More Resources