Seller's Agent in 2023
The Bernardi Group
Coldwell Banker Realty-Boulder
(303) 402-6000
265 Total Sales
8850 N County Line Rd Longmont, CO 80503
Estimated Value: $2,718,000 - $3,449,777
7
Beds
9
Baths
6,561
Sq Ft
$483/Sq Ft
Est. Value
Highlights
- Water Views
- Parking available for a boat
- Spa
- Berthoud Elementary School Rated A-
- Barn or Stable
- 34.47 Acre Lot
About This Home
As of July 2023The Hamlet. Luxury pastoral living on a stunning property offering jaw-dropping views, a grand scale main residence, 3 stall barn, a greenhouse, gardens & pond. Sited on over 34 acres for optimal privacy, this beautiful, quiet setting is one of a kind. A welcoming wraparound front porch greets your arrival. Soaring, beamed ceilings make a tremendous first impression with natural light pouring through numerous windows. Great room is highlighted by a two-sided floor-to-ceiling rock fireplace that captures the eye. An effortless flow to the dining & kitchen where you will find premium appliances, a sunny breakfast nook to enjoy the view, & a seamless indoor/outdoor flow that is perfect for entertaining. A secluded main level owner's suite is spacious w/sitting area, patio & hot tub access, & walkthrough closet leading to luxe 5 piece bath with claw foot soaking tub. Ascend the wrought iron curved staircase for 2 secondary bedrooms that are spacious & bright each with ensuite baths, walk-in closets, and a window bench. Lower level would make perfect guest quarters with a kitchenette, 4 bedrooms, a bonus room, & private entrance. Country living at its finest: enjoy fresh eggs from the chickens, organic produce from gardens & greenhouse, raising animals in the barn, & savoring the sunset from the pond. WATER RIGHTS Valued at $500,000 plus MINERAL RIGHTS at $170,000 brings tremendous value to this property.
Last Agent to Sell the Property
Coldwell Banker Realty-Boulder Listed on: 01/27/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $15,062
Year Built
- Built in 2002
Lot Details
- 34.47 Acre Lot
- Dirt Road
- Unincorporated Location
- Southern Exposure
- Partially Fenced Property
- Wood Fence
- Level Lot
- Sprinkler System
- Property is zoned AG
Parking
- 3 Car Attached Garage
- Heated Garage
- Garage Door Opener
- Parking available for a boat
Property Views
- Water
- Panoramic
- Mountain
Home Design
- Contemporary Architecture
- Farmhouse Style Home
- Composition Roof
- Stucco
- Stone
Interior Spaces
- 6,561 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Bar Fridge
- Beamed Ceilings
- Cathedral Ceiling
- Multiple Fireplaces
- Double Sided Fireplace
- Gas Fireplace
- Double Pane Windows
- Window Treatments
- French Doors
- Great Room with Fireplace
- Dining Room
- Home Office
- Sun or Florida Room
- Radon Detector
Kitchen
- Eat-In Kitchen
- Double Oven
- Gas Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 7 Bedrooms
- Main Floor Bedroom
- Fireplace in Primary Bedroom
- Walk-In Closet
- Primary bathroom on main floor
Laundry
- Laundry on main level
- Dryer
- Washer
- Sink Near Laundry
Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump
- Natural lighting in basement
Outdoor Features
- Spa
- Pond
- Balcony
- Deck
- Patio
- Separate Outdoor Workshop
- Outdoor Storage
Location
- Near Farm
Schools
- Berthoud Elementary School
- Turner Middle School
- Berthoud High School
Farming
- Loafing Shed
- Pasture
Horse Facilities and Amenities
- Horses Allowed On Property
- Tack Room
- Barn or Stable
- Arena
Utilities
- Forced Air Heating and Cooling System
- Water Rights
- Septic System
Community Details
- No Home Owners Association
- Northern Plains Subdivision
Listing and Financial Details
- Assessor Parcel Number R0055679
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 27, 2023
Closed on
Jul 19, 2023
Sold by
Smith Terri
Bought by
Fleming Paul and Towers Amber
Seller's Agent
The Bernardi Group
Coldwell Banker Realty-Boulder
Buyer's Agent
Daphne Queen
8z Real Estate
List Price
$2,997,000
Sold Price
$2,775,000
Premium/Discount to List
-$222,000
-7.41%
Views
145
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$396,944
Avg. Annual Appreciation
6.07%
Original Mortgage
$1,275,000
Outstanding Balance
$1,244,131
Interest Rate
6.71%
Mortgage Type
New Conventional
Estimated Equity
$1,927,813
Purchase Details
Closed on
Apr 4, 2019
Sold by
Kreitman Terri L
Bought by
Smith Terri
Purchase Details
Listed on
Jun 29, 2017
Closed on
Apr 6, 2018
Sold by
Templeton William M
Bought by
Kreitman Terri L
Seller's Agent
Joel Ripmaster
Slifer Smith & Frampton-Bldr
Buyer's Agent
Dennis Culver
WK Real Estate
List Price
$1,750,000
Sold Price
$1,500,000
Premium/Discount to List
-$250,000
-14.29%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.41%
Purchase Details
Listed on
Jul 26, 2012
Closed on
May 23, 2013
Sold by
Kirkup Richard G and Kirkup Brittany D
Bought by
Templeton William M
Seller's Agent
Candace Loving
Gateway Real Estate Vail Valley
Buyer's Agent
Dena Schlutz
Estate Professionals
List Price
$1,795,000
Sold Price
$1,492,000
Premium/Discount to List
-$303,000
-16.88%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.11%
Purchase Details
Closed on
Apr 26, 2011
Sold by
Holtsclaw Lewis and Holtsclaw Rosemary
Bought by
Kirkup Richard G
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,181,250
Interest Rate
4.82%
Mortgage Type
New Conventional
Purchase Details
Closed on
Apr 9, 2002
Sold by
Holtsclaw Equities Inc
Bought by
Holtsclaw Lewis
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$800,000
Interest Rate
6.96%
Mortgage Type
Construction
Purchase Details
Closed on
Apr 28, 2000
Sold by
Young Kathleen Edna
Bought by
Holtsclaw Equities Inc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$200,000
Interest Rate
8.21%
Mortgage Type
Construction
Purchase Details
Closed on
Jul 14, 1982
Bought by
Templeton William M
Purchase Details
Closed on
Jan 11, 1980
Bought by
Templeton William M
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Fleming Paul | $2,775,000 | None Listed On Document | |
| Smith Terri | -- | Land Title Guarantee | |
| Kreitman Terri L | $1,500,000 | Land Title Guarantee | |
| Templeton William M | $1,492,000 | None Available | |
| Kirkup Richard G | $1,575,000 | None Available | |
| Holtsclaw Lewis | -- | First American Heritage Titl | |
| Holtsclaw Equities Inc | -- | -- | |
| Holtsclaw Equities Inc | $315,000 | -- | |
| Templeton William M | $110,000 | -- | |
| Templeton William M | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Fleming Paul | $1,275,000 | |
| Previous Owner | Kirkup Richard G | $1,181,250 | |
| Previous Owner | Holtsclaw Lewis | $800,000 | |
| Previous Owner | Holtsclaw Equities Inc | $200,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/19/2023 07/19/23 | Sold | $2,775,000 | 0.0% | $423 / Sq Ft | |
| 05/25/2023 05/25/23 | Price Changed | $2,775,000 | -4.2% | $423 / Sq Ft | |
| 04/20/2023 04/20/23 | Price Changed | $2,897,000 | -3.3% | $442 / Sq Ft | |
| 01/27/2023 01/27/23 | For Sale | $2,997,000 | +99.8% | $457 / Sq Ft | |
| 01/28/2019 01/28/19 | Off Market | $1,500,000 | -- | -- | |
| 01/28/2019 01/28/19 | Off Market | $1,492,000 | -- | -- | |
| 04/06/2018 04/06/18 | Sold | $1,500,000 | -14.3% | $227 / Sq Ft | View Prior Sale |
| 04/04/2018 04/04/18 | Pending | -- | -- | -- | |
| 06/29/2017 06/29/17 | For Sale | $1,750,000 | +17.3% | $265 / Sq Ft | |
| 05/23/2013 05/23/13 | Sold | $1,492,000 | -16.9% | $226 / Sq Ft | View Prior Sale |
| 04/23/2013 04/23/13 | Pending | -- | -- | -- | |
| 07/26/2012 07/26/12 | For Sale | $1,795,000 | -- | $271 / Sq Ft |
Source: IRES MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $18,940 | $197,925 | $84,625 | $113,300 |
| 2024 | $18,940 | $197,925 | $84,625 | $113,300 |
| 2023 | $18,147 | $224,758 | $51,175 | $177,268 |
| 2022 | $15,062 | $174,954 | $51,861 | $123,093 |
| 2021 | $15,408 | $179,988 | $53,353 | $126,635 |
| 2020 | $11,476 | $133,025 | $40,183 | $92,842 |
| 2019 | $11,047 | $133,025 | $40,183 | $92,842 |
| 2018 | $11,685 | $134,273 | $50,760 | $83,513 |
| 2017 | $10,018 | $148,445 | $56,118 | $92,327 |
| 2016 | $10,210 | $131,148 | $60,894 | $70,254 |
| 2015 | $10,022 | $125,203 | $47,760 | $77,443 |
| 2014 | $10,316 | $125,203 | $47,760 | $77,443 |
Source: Public Records
Agents Affiliated with this Home
-
The Bernardi Group
-
Daphne Queen
Buyer's Agent in 2023
Daphne Queen
8z Real Estate
(303) 589-4308
144 Total Sales
-
Joel Ripmaster
Seller's Agent in 2018
Joel Ripmaster
Slifer Smith & Frampton-Bldr
(303) 641-3377
28 Total Sales
-
Dennis Culver
Buyer's Agent in 2018
Dennis Culver
WK Real Estate
(303) 618-3366
83 Total Sales
-
Candace Loving
Seller's Agent in 2013
Candace Loving
Gateway Real Estate Vail Valley
(303) 332-4530
23 Total Sales
-
Dena Schlutz
Buyer's Agent in 2013
Dena Schlutz
Estate Professionals
(720) 734-8588
175 Total Sales
Map
Source: IRES MLS
MLS Number: 981181
APN: 1205050-00-023
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
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.
Information deemed reliable but not guaranteed by the MLS.
Nearby Homes
- 15789 N 83rd St
- 4301 W County Road 4
- 0 Rodney Ln Unit 1030974
- 1785 Serene Place
- 9402 Crystal Ln
- 1796 Serene Place
- 6310 W County Road 4
- 0 Beverly Dr
- 4808 Beverly Dr
- 9025 Woodland Rd
- 2316 Horseshoe Cir
- 1884 Chaparro Cir
- 0 Lucky Ln
- 2548 Horseshoe Cir
- 15293 N 107th St
- 5306 Foothills Dr
- 10650 Yellowstone Rd
- 205 S County Road 23
- 1637 S U S Highway 287
- 1921 Glenview Ct
- 4050 W County Road 2
- 3818 W County Road 2
- 2532 Little Thompson Dr
- 3714 W County Road 2
- 2651 Ponds Field Ct
- 3610 W County Road 2
- 4441 Hoot Owl Dr
- 2520 Little Thompson Dr
- 8422 N County Line Rd
- 3420 W County Road 2
- 4480 Hoot Owl Dr
- 15560 N 83rd St
- 8400 N County Line Rd
- 15690 N 83rd St
- 4516 W County Road 2
- 15626 N 83rd St
- 9300 N County Line Rd
- 3362 W County Road 2
- 3362 W County Road 2
- 15790 N 83rd St