Please stand by!
USDAProperties.com is making sense of this chaotic market...

 

 

 

$699,000
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
964 Blue Bell Rd
Berthoud, CO 80513
4 bed 4 bath 3,643 SqFt ($191/SqFt)
0.26 acre lot. Built 2020
Listed 2024-03-07, HOA $97, Taxes $6,257
USDA Eligible
near Berthoud, CO
 Restrictions may apply
due to home size

Latest Value Estimates: $743,000 from Collateral Analytics on 2024-04-17. $711,813 from Quantarium on 2024-04-24. Forecast Estimate Value:$756,814 in 2025-02-01 by Collateral Analytics. $725,229 in 2025-04-01 by Quantarium.

Gorgeous turnkey home with so many charming touches and stunning views of Longs Peak!!!

* No Longer For Sale *
Your browser will attempt to redirect you to the city level in a few seconds.

Situated on a quiet cul-de-sac, this lovely two-story home faces west and is better than brand new! The open kitchen has a large quartz island, stainless appliances including a 6-burner gas range and French door refrigerator and plenty of counter and cabinet space. There is a pantry and an office nook, as well as a nice spot to set up your own coffee bar. The sunny dining area has vaulted ceilings with attractive custom wood design. Step out onto the lrge, covered patio and enjoy the attractive backyard which includes a firepit and plenty of room to play or garden. The living room has a fireplace with a marble surround. There is a half bath conveniently located near the living room as well as a mudroom inside the 3-car garage. Up the stairs to the second floor, you are greeted by a large, sunny loft. Check out those western views!!!!

The primary bedroom has an ensuite full bath and a stunning professionally upgraded walk-in closet! The laundry room has a utility sink, built-ins galore, drying racks and a storage closet!! The 2nd bedroom has a walk-in closet and theres a third bedroom. The basement is beautifully finished and has a full bathroom, bedroom, living area, built-in electric fireplace and tons of storage. Radon mitigation system in stalled. This gem wont last long!!


Presented by Susan McBride at
Resident Realty North Metro LLC.


Property MLS #1948449 from REcolorado

Bedrooms: 4
Bedrooms On Basement Level: 1
Primary Bedroom Level: Upper
Bedroom 1 Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Basement

Total Bathrooms: 4
Full Bathrooms: 3
1/2 Bathrooms: 1
Bathrooms On Main Level: 1
Bathrooms On Basement Level: 1

Ceiling Fan(s)
Kitchen Island
Pantry
Quartz Counters
Smoke Free
Utility Sink
Vaulted Ceiling(s)
Walk-In Closet(s)
Flooring: Carpet, Laminate, Tile
Window Features: Double Pane Windows

Dishwasher
Dryer
Microwave
Range
Refrigerator
Washer

Primary Bathroom (Full) Level: Upper
Laundry Level: Upper
Bathroom (Full) Level: Upper
Bathroom (Full) 2 Level: Basement
Bathroom (1/2) Level: Main
Living Room 2 Level: Main
Living Room Level: Basement
Loft Level: Upper
Mud Room Level: Main
Basement Description: Finished

Cooling Features: Central Air
Fireplace Features: Basement, Electric, Gas, Living Room
Heating Features: Forced Air
Number of Fireplaces: 2

Dining Room Level: Main
Kitchen Level: Main

Fire Pit
Patio And Porch Features: Covered, Patio
Road Frontage Type: Public Road
Road Surface Type: Paved

Attached Garage: Yes
Garage Spaces: 3
Parking Total: 3

Lot Description: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres: 0.26
Lot Size Square Feet: 11441

Association: Yes
Association Fee: 97
Association Fee Frequency: Monthly
Association Fee Includes: Recycling, Trash
Calculated Total Monthly Association Fees: 97
Association Name: Rose Farms HOA
Association Phone: 3032329200

Elementary School: Ivy Stockwell
Elementary School District: Thompson R2-J
High School: Berthoud
High School District: Thompson R2-J
Middle School: Turner
Middle or Junior School District: Thompson R2-J

Berthoud High School is a public high school located approximately 0.2 miles away.
directions icon Map directions

Ivy Stockwell Elementary School is a public elementary school located approximately 0.6 miles away.
directions icon Map directions

Turner Middle School is a public middle school located approximately 0.8 miles away.
directions icon Map directions

Campion Academy is a private high school located approximately 3.6 miles away.
directions icon Map directions

Annual Tax Amount: 6258.00
Source Listing Status: Closed
County: Larimer
Current Use: Live/Work
Directions: North on I-25 to Exit 250 (CO56 Berthoud) and go west (left). Turn left on 10th St. Ignore GPS if it tells you to turn on Spartan. Instead go through Spartan and then turn left on Blue Bell Rd. Head into the cul-de-sac and home is on your left. When you get out of your car, look west at the spectacular mountain views!
Tax Year: 2022
Source Property Type: Residential
Exclusions: Sellers personal property and staging items excluded. Washer and Dryer negotiable. Chalkboard in office nook excluded. Curtains excluded, blinds will stay. Propane fire pit and benches negotiable, and BBQ grill negotiable. Swing included! Playground items excluded. Projector in basement negotiable.
Source Neighborhood: Rose Farm Acres
Parcel Number: R1659684
Subdivision: Rose Farm Acres
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$28,773 + $8,486
$37,259
$6,257
2021$26,412 + $8,730
$35,142
$5,899
2020$unknown + $19,227
$19,227
$3,228
2019$unknown + $4,675
$4,675
$772
2018$unknown + $67
$67
$11
2017$unknown + $67
$67
$10
2016$unknown + $49
$49
$9

Sold 2024-04-09
$710,000
REcolorado
Listed 2024-03-07
$699,000
REcolorado
Sold 2020-12-30
$490,300
Public Record
Sold 2019-06-27
$4,495,000
Public Record
Sold 2017-08-24
$1,691,250
Public Record
Sold 2017-08-23
$1,353,000
Public Record

Total Square Feet Living: 3561
Year Built: 2020
Above Grade Finished Area: 2481
BelowGradeFinishedArea: 1080
Below Grade Unfinished Area: 82.00
Construction Materials: Concrete, Frame, Wood Siding
Levels: Two
Property Age: 4
Property Condition: Updated/Remodeled
Roof: Composition
Structure Type: House
Architectural Style: Traditional

Sewer: Public Sewer
Cable Available
Electricity Connected
Internet Access (Wired)
Natural Gas Connected
Water Source: Public

Security Features: Video Doorbell

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.