2504 S Brehm Rd

2,245 Sq. Ft.
$174 / Sq. Ft.
2,245
Sq. Ft.
$174
per Sq. Ft.

Description

Remodeled ranch with HUGE master 5pc bath, oak & tile floors, mtn views, quite country lane 10 min Longmont/Berthoud. Well is also on property but use to be verified by buyer as house is connected to Little Thompson. Here's your chance! Priced to sell and a great opportunity.Remodeled ranch with HUGE master 5pc bath, oak & tile floors, mtn views, quite country lane 10 min Longmont/Berthoud. Well is also on property but use to be verified by buyer as house is connected to Little Thompson. Here's your chance! Priced to sell and a great opportunity.
  1. Listed by Steven Hayes • Executive Choice RE, LLC
    P: (970)-690-0541 C: (970)-690-0541 shayes@c3-re.com
  2. Listed by Michele Brashers • Executive Choice RE, LLC
    P: (970)-412-8657 C: (970)-412-8657 michelebrashers1@gmail.com

Property Details for 2504 South Brehm Road

Locale
Berthoud
LISTING CLOSED: 06/02/2008 12:00 AM

Property Details for 2504 South Brehm Road

StatusSold
MLS #556441
Days on Compass140
Taxes$1,812 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeMixed Use
MLS TypeResidential / Mixed Use
Year Built1972
Lot Size10.00 AC / 435,600 SF
CountyLarimer County

Location

Listing Courtesy of Executive Choice RE, LLC, Steven Hayes; Executive Choice RE, LLC, Michele Brashers

Sold By RE/MAX Traditions, Inc, Rick Corbin

Add your commute

Building Information for 2504 South Brehm Road

Stories-Residences-Year Built1972Lot Size10.00 AC / 435,600 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$2,133 per month

30 year fixed, 6.55% Interest

Principal and Interest

$1,982

Property Taxes

$151

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 2504 South Brehm Road

Summary
Location and General Information
  • Latitude: 40.26
  • Longitude: -105.07
Parking
  • Garage SqFt: 504
  • Total Parking: 2.00
  • Parking Features: RV Access/Parking
Taxes and HOA Information
  • HOA Fee: $.00
  • Legal Description: Long
  • HOA2 Fee Amount: $0
  • Tax Year: 2006
  • HOA Transfer Fee: No
  • Has Association Fee: No
  • Has Association Reserve: No
  • Tax Annual Amount: $1,812
  • Parcel Number: R0489204
Property
Lot Information
  • Lot Improvements: Native Grass
  • Horse Property: Horse(s) Allowed, Zoning Appropriate for 4+ Horses, Barn, Corral(s), Pasture, Tack Room, Hay Storage
  • Lot Size Area: 435,600.00
  • Has Irrigation Water Rights: No
  • Has Improvements: No
Property and Assessments
  • Total Finished Area Source: Assessor
  • Living SqFt: 2245
  • Above Grade Finished Area Source: 2245
  • Total Finished Area: 2245
  • Property Attached YN: No
  • Are Ditches Active: No
  • New Construction YN: No
  • Levels: One
Utilities
  • Has Solar Photovoltaic: 0
  • Electric: REA
  • Well Permit Number: 54642
Interior and Exterior Features
Exterior Features
  • Construction Materials: Frame, Metal Siding
  • Green Building Verification Type: 0
  • Exterior Features: >8' Garage Door
  • Flooring: Wood
Interior Features
  • Interior Features: Eat-in Kitchen, Pantry, Bay or Bow Window, Natural Woodwork, Walk-In Closet(s), Washer/Dryer Hookup, Luxury Features Primary Bath, 5 Piece Primary Bath
  • Laundry Features: No Inclusions
  • Fireplaces 1: Insert, Two or More, Bedroom
  • All Bedrooms Conform: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 0
  • Rough-in Bathrooms: 0
  • Three Quarters Bathrooms: 0
  • Baths Full Additional: 0
  • Baths Full Basement: 0
  • Baths Full Upper: 0
  • Baths Full Main: 2
  • Baths Full Lower: 0
  • Baths Half Additional: 0
  • Baths Half Basement: 0
  • Baths Half Upper: 0
  • Baths Half Main: 0
  • Baths Half Lower: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 0
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0
  • Baths Three Quarters Main: 0
Room Information
Room 1
  • RoomDescription: Carpet
  • RoomLength: 10.0
  • RoomLevel: Main
  • RoomType: Bedroom 2
  • RoomWidth: 10.0
Room 2
  • RoomDescription: Carpet
  • RoomLength: 10.0
  • RoomLevel: Main
  • RoomType: Bedroom 3
  • RoomWidth: 9.0
Room 3
  • RoomDescription: Carpet
  • RoomLength: 13.0
  • RoomLevel: Main
  • RoomType: Family Room
  • RoomWidth: 19.0
Room 4
  • RoomDescription: Tile
  • RoomLength: 19.0
  • RoomLevel: Main
  • RoomType: Kitchen
  • RoomWidth: 10.0
Room 5
  • RoomDescription: Vinyl
  • RoomLength: 9.0
  • RoomLevel: Main
  • RoomType: Laundry
  • RoomWidth: 7.0
Room 6
  • RoomDescription: Carpet
  • RoomLength: 13.0
  • RoomLevel: Main
  • RoomType: Living Room
  • RoomWidth: 12.0
Room 7
  • RoomDescription: Wood
  • RoomLength: 19.0
  • RoomLevel: Main
  • RoomType: Primary Bedroom
  • RoomWidth: 27.0
  • Room Features: Luxury Features Primary Bath, 5 Piece Primary Bath
Room 8
  • RoomDescription: Carpet
  • RoomLength: 13.0
  • RoomLevel: Additional
  • RoomType: Recreation Room
  • RoomWidth: 27.0
Rental
Rental Information
  • Horse YN: Yes
  • Occupant Type: Vacant

Property History for 2504 South Brehm Road

DateEvent & SourcePriceAppreciation
Jun 2, 2008

Sold (Public Record)

Public Record #241331827

$390,000

+1.5% / yr

Feb 3, 2000

Sold (Public Record)

Public Record #56700460

$345,000—
DateEvent & SourcePrice
06/02/2008

Sold (Public Record)

Public Record #241331827

$390,000

+1.5% / yr

02/03/2000

Sold (Public Record)

Public Record #56700460

$345,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 2504 South Brehm Road

Taxable ValueLand$25,000Additions$33,444Total$58,444
Tax Record2025$5,357 ($446 / month)
Home Facts
Beds3Total Finished SqFt2,245 SqFtAbove Grade Finished SqFt2,245 SqFtStories1Lot Size435,600 SqFtStyleSingle Family ResidenceYear Built1972CountyLARIMERAPN94363-00-027Fireplace TypeHas Fireplace

Schools near 2504 South Brehm Road

This home is within Thompson R2-J School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Charter - K to 12
Rating
School
Distance
Ivy Stockwell Elementary School
PublicK to 5

Turner Middle School
Public6 to 8

Berthoud High School
Public9 to 12

Loveland Classical School
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby off-market homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Executive Choice RE, LLC, Steven Hayes; Executive Choice RE, LLC, Michele Brashers

Based on information submitted to the MLS GRID as of 10/20/2025 05:29 PM. 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. Properties displayed may be listed or sold by various participants in the MLS. IDX 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. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.