Stand by
USDAProperties.com is recovering from the party last night...

 

 

 

$585,000
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
548 Wagon Bend Rd
Berthoud, CO 80513
3 bed 3 bath 3,222 SqFt ($181/SqFt)
6,300SqFt lot. Built 2018
Listed 2024-03-22, Taxes $4,602
USDA Eligible
near Berthoud, CO
 Restrictions may apply
due to home size

Latest Value Estimates: $587,266 from Quantarium on 2024-04-24. $550,000 from Collateral Analytics on 2024-04-17. Forecast Estimate Value:$598,335 in 2025-04-01 by Quantarium. $560,226 in 2025-02-01 by Collateral Analytics.

Well situated home abuts HOA walking trail and space and quiet end of street.

* Has Contingent Offer *

Light and bright open floorplan flows easily. Kitchen features a large island for gathering, gas range and oven, side coffee bar/desk area and large pantry. Spacious island flows into living room for family and friend gatherins. Sperated dining area. Venture upstairs to the sizeable loft for work or play with views of the mountains. Primary bedroom offers abundant space with pe aceful luxury primary bath for soaking or a quick shower.

Laundry upstairs next to all 3 bedrooms. Basement ready for your storage or finishing and 4 car tandem garage. Back patio ready for summer BBQs with a fully privacy fenced level yard. Prairie Star boasts many park amenities, basketball and pickle ball courts, community garden spots, 2 dog parks, community pool and workout($120/year) and many community events during the year. Truly enjoy Colorado living with views from your home daily and convenient location. Close to TPC golf, Brthoud Reservoir, Carter Lake and new Berthoud Recreation Center.


Presented by Christine Torres at
RE/MAX Alliance Loveland Office.
Listing Agent Photo

Property MLS #1005599 from IRES

Bedrooms: 3
Primary Bedroom Dimensions: 18 x 14
Bedroom 2 Dimensions: 10 x 10
Bedroom 3 Dimensions: 10 x 10
Primary Bedroom Sqft: 252
Bedroom 2 Sqft: 100
Bedroom 3 Sqft: 100
Primary Bedroom Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 2 Features: Carpet
Bedroom 3 Features: Carpet

Total Bathrooms: 3
Full Bathrooms: 2
1/2 Bathrooms: 1
Bathrooms On Main Level: 1
Primary Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath

Eat-in Kitchen
Open Floorplan
Pantry
Walk-In Closet(s)
Loft
Kitchen Island
Interior Amenities: Eat-in Kitchen, Open Floor Plan, Pantry, Walk-in Closet, Loft, Fire Alarm, Washer/Dryer Hookups, Kitchen Island

Gas Range/Oven
Self Cleaning Oven
Double Oven
Dishwasher
Refrigerator
Washer
Dryer
Microwave
Disposal
Laundry Features: Washer/Dryer Hookups, Upper Level

Cooling Features: Central Air
Heating Features: Forced Air
Heating: Yes

Dining Room Dimensions: 11 x 13
Dining Room Level: Main
Dining Room Sqft: 143
Kitchen Dimensions: 18 x 11
Kitchen Level: Main
Kitchen Sqft: 198

Great Room Dimensions: 18 x 16
Great Room Level: Main
Basement Description: Unfinished, Rough-in for Radon, Sump Pump
Exercise Room: Yes

Attached Garage: Yes
Covered Spaces: 4
Garage Spaces: 4
Garage Description: Attached
Parking Features: Tandem

Fencing: Fenced, Wood
Patio And Porch Features: Patio

Lot Description: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System
Lot Size Acres: 0.1446281
Lot Size Square Feet: 6300

View: Mountain(s)
Green Energy Efficient: Southern Exposure
Security Features: Smoke Detector(s), Fire Alarm

Association: No
Calculated Total Monthly Association Fees: 0

Elementary School: Carrie Martin
Elementary School District: Thompson R2-J
High School: Thompson Valley
High School District: Thompson R2-J
Middle School: Bill Reed
Middle or Junior School District: Thompson R2-J

Carrie Martin Elementary School is a public elementary school located approximately 1.1 miles away.
directions icon Map directions

Thompson Valley High School is a public high school located approximately 3.4 miles away.
directions icon Map directions

Bill Reed Middle School is a public middle school located approximately 3.7 miles away.
directions icon Map directions

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

Community Features: Clubhouse, Pool, Playground, Fitness Center, Park, Hiking/Biking Trails

Annual Tax Amount: 4063
Source Listing Status: Active-Backup
County: Larimer
Tax Year: 2022
Source Property Type: Residential
Possible Use: Single Family
Inclusions: Gas Range/Oven, Self-Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Clothes Washer, Clothes Dryer, Microwave, Disposal, Smoke Alarm(s)
Source Neighborhood: Prairie Star
Subdivision: Prairie Star
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$24,624 + $6,616
$31,240
$4,602
2021$25,332 + $6,807
$32,139
$4,690
2020$23,338 + $7,200
$30,538
$4,457
2019$13,492 + $7,200
$20,692
$2,963
2018$unknown + $16,530
$16,530
$2,446
2017$unknown + $10
$10
$6
2016$unknown + $10
$10
$6

Listed 2024-03-22
$585,000
IRES
Listing removed 2019-04-25
$0
REcolorado
Sold 2019-04-25
$451,809
IRES
Price Changed 2019-01-03
$451,809
REcolorado
Price Changed 2019-01-03
$451,809
IRES
Price Changed 2019-01-02
$451,714
REcolorado
Price Changed 2019-01-02
$451,714
IRES
Listed 2018-12-21
$449,309
REcolorado
Listed 2018-12-21
$449,309
IRES
Sold 2018-07-23
$556,240
Public Record
Sold 2018-01-11
$2,380,000
Public Record

Total Square Feet Living: 3222
Year Built: 2018
BelowGradeFinishedArea: 930
Construction Materials: Wood/Frame, Stone
Direction Faces: Southwest
Levels: Two
Property Age: 6
Property Condition: Not New, Previously Owned
Roof: Composition

Electric: Electric, PVREA
Gas: Natural Gas, Xcel
Sewer: City Sewer
Natural Gas Available
Electricity Available
Water Source: City Water, Berthoud

Accessibility Features: Level Lot, Level Drive
Click Thumbnail Images To View Full Size
garageunknownunknownliving_roomliving_room
living_roomkitchenkitchenkitchendining_room
laundry_roombedroombedroombathroombathroom
bedroombedroomliving_roomliving_roombathroom
bathroomunknownunknownlaundry_roomhouse_view
porchhouse_viewunknownunknown

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.