Date
Details
Price
Change
Source
5/11/2026
Listed
$1,999,970
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
$1,999,970
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
Property Description
Experience the best of Colorado county living on this private, irrigated 10-acre estate just 10 minutes from Longmont and 30 minutes from Boulder. Tucked away at the end of a quiet road in Weld County, this exceptional 7,050 sq. ft. Cape Cod-style farmhouse captures breathtaking 360-degree mountain and plains views. Designed for comfortable living and entertaining, the home features expansive rooms filled with natural light from large windows and skylights. Choose between a main-level primary suite or an upper-level suite with an adjoining nursery and sitting room. Two moss-rock fireplaces add warmth and charm, while fresh interior and exterior paint, new carpet, a new roof, and newer HVAC systems make this home truly move-in ready. The chef's kitchen is equipped with a commercial Viking gas range, granite countertops, abundant cabinetry, and two walk-in pantries. An oversized mudroom includes a convenient walk-up dog wash. A 900 sq. ft. basement provides additional storage. The attached three-car garage is complemented by 1,164 sq. ft. of unfinished space above, offering excellent potential for an ADU, guest quarters, studio, or home office. Outside the fully fenced property includes LHWD domestic tap water, a private well, and a versatile 2,200 sq. ft. barn/kennel with its own bathroom and separate septic system. Whether you envision horses, a hobby farm, orchard, greenhouse, apiary, cidery, chickens, or extensive gardens, this property offers endless homestead possibilities. With no HOA, no covenants, and no conservation easement, you'll enjoy the freedom to create the lifestyle you've always imagined. A rare opportunity to own and extraordinary country estate with privacy, flexibility, and spectacular views in one of northern Colorado's most desirable locations.
Full Property Details
Full Property Details for 677 Co Rd 18
General
- Price: $1,999,970
- Taxes: $8,266 (2025)
- Status: Active
- Type: Single Family
- Source: IRES
- MLS ID: 1063026
- Updated: 6/29/2026
- Added to Site: 51 day(s) ago
Interior
- Interior Features: Eat-In Kitchen, Separate Dining Room, Cathedral Ceiling(s), Pantry, Wood Windows, Walk-In Closet(s), Washer/Dryer Hookup, Skylights, Kitchen Island, Two Primary Suites, High Ceilings, Sun Room, Split Bedroom Plan
- Fireplace: Yes
- Fireplace(s): Insert, Two or More, Living Room, Family Room
- Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Disposal, Fire Alarm
- Flooring: Wood
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 2
- 3/4 Bathrooms: 1
- Half Bathrooms: 2
- Main Floor Baths: 1
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: Sink
Additional Information
- Spa: Yes
- Spa Description: Bath
- Equipment: Fireplace Tools Included
Exterior
- Exterior Features: Sprinkler System, Oversized Garage
- Porch/Patio/Deck: Patio, Deck
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Parking Features: Garage Door Opener, RV Access/Parking, Attached
- Garage Description: Attached
Location
- Area: Longmont
- County: Weld
- Subdivision: Rec Exempt
- Driving Directions: From 3rd Ave. and Main St. Longmont, head south on US 287 for 3.3 miles, turn left onto Oxford Road and go 2.5 miles. Continue straight onto CO Rd 18 for 0.7 miles. Look for the property on the left. Turn into the driveway at the Flying Piglet Ranch sign.
School Information
- School District: ST Vrain Dist RE 1J
- Elementary School: Grand View
- Middle School: Coal Ridge
- High School: Mead
Heating & Cooling
- Cooling Type: Central Air, Ceiling Fan(s)
- Heating Type: Forced Air, Baseboard, Zoned, 2 or more Heat Sources, 2 or More Water Heaters
Utilities
- Gas: Yes
- Gas: Propane
- Sewer: Septic Tank
- Water: District, Well
- Utility Description: Natural Gas Available, Electricity Available, Wood/Coal, Satellite Available, High-Speed Internet Available
Structural Information
- Architectural Style: Cape Cod, Farmhouse, Contemporary
- Construction: Frame, Brick, Vinyl Siding
- Exterior Const.: Frame, Brick, Vinyl Siding
- Basement: Yes
- Basement Desc.: Unfinished, Sump Pump
- Roof: Composition
- Windows: Skylight(s), Window Coverings
- Square Feet: 8,214
- Sq. Ft. Source: Assessor
- Living Area: 7,050 Sq. Ft.
- Year Built: 1985
Additional Structures
- Other Structures: Storage
Lot Features
- Property View: Mountain(s), Hills, Plains View, Panoramic
- Mountain views: Yes
- Lot Size (Acres): 10
- Lot Size (Sq. Ft.): 435,600
- Frontage: County Road, Privately Maintained
- Street/Road Desc.: Gravel
- Fence: Yes
- Lot Features: Evergreen Trees, Deciduous Trees, Native Grass, Level, House Faces West, Unincorporated, Water Rights Included, Mineral Rights Excluded
- Potential Use: Single-Family, Farm
- Zoning: SFR
- Fencing (Description): Fenced, Dog Run/Kennel, Vinyl
Horse Property
- Horse Facility Desc.: Zoning Appropriate for 4+ Horses, Barn, Corral(s), Pasture, Tack Room, Riding Trail
Green Features
- Energy Efficient: Sun Space, Windows, Doors, Thermostat
Financial Considerations
- Tax Amount: $8,266
- Tax Year: 2025
- Terms: Cash, Conventional, FHA, VA
Disclosures and Reports
- Special Conditions: Private Owner
- Property ID: R4357606
Listed by Turner Realty (303) 776-1105
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 677 Co Rd 18 —
Turner Realty
303-776-1105
Turner Realty
303-776-1105
3037761105
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 677 Co Rd 18
School District:St. Vrain Valley School District Re 1j
| Name | Grades | Distance |
|---|---|---|
Grand View Elementary 6601 Aggregate Boulevard, Frederick, CO 80516 | PK-5 | 2.7 mi |
Coal Ridge Middle School 6201 Booth Drive, Firestone, CO 80504 | 6-8 | 6.3 mi |
Mead High School 12750 County Road 7, Longmont, CO 80504 | 9-12 | 5.2 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 677 Co Rd 18
Tax History
Tax History for 677 Co Rd 18
Year
Property Taxes
Change
Tax Assessment
Change
2025
$8,266
—
$90,690
3%
2025
$8,266
29%
$87,730
11%
2024
$6,392
4%
$78,710
-1%
2023
$6,130
-3%
$79,470
16%
2021
$6,352
2%
$68,420
3%
2022
$6,242
5%
$66,510
3%
2020
$5,961
-1%
$64,790
—
2019
$6,029
-4%
$64,790
-6%
2018
$6,309
4%
$68,630
—
2017
$6,053
20%
$68,630
21%
2016
$5,048
4%
$56,870
—
2015
$4,876
10%
$56,870
9%
2014
$4,450
-1%
$52,050
—
2013
$4,502
—
$52,050
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 677 Co Rd 18
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 12 days ago
- 4Beds
- 4Total Baths
- 4,768Sq. Ft.
- MLS # 1062184
Listed by Compass - Boulder
- Single Family
- Active
- Updated 6 days ago
- 5Beds
- 5Total Baths
- 7,440Sq. Ft.
- MLS # 1062442
Listed by Compass - Boulder
- Single Family
- Active
- 5Beds
- 6Total Baths
- 6,126Sq. Ft.
- MLS # 4082729
Listed by Mary Rose (312) 952-0494
- Single Family
- Active
- 4Beds
- 5Total Baths
- 3,628Sq. Ft.
- MLS # 1061609
Listed by Compass - Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Lots/Land
- Active
- Updated 12 hours ago
- 1.12Acres
- MLS # 1063089
Listed by RE/MAX Alliance-Longmont
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 2Total Baths
- 1,465Sq. Ft.
- MLS # 1062449
Listed by West and Main Homes
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 3Total Baths
- 2,472Sq. Ft.
- MLS # 1062441
Listed by 1st Realty Associates Inc
- Single Family
- Active
- Updated 1 day ago
- 5Beds
- 4Total Baths
- 4,042Sq. Ft.
- MLS # 1063036
Listed by Compass - Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 5 days ago
- 1Bed
- 2Total Baths
- 760Sq. Ft.
- MLS # 7199796
Listed by The Bernardi Group (303) 402-6000
- Condo
- Active
- Updated 1 day ago
- 2Beds
- 2Total Baths
- 1,650Sq. Ft.
- MLS # 6901645
Listed by Your Castle Realty LLC
- Single Family
- Active
- Updated 6 days ago
- 4Beds
- 3Total Baths
- 2,860Sq. Ft.
- MLS # 4205801
Listed by eXp Realty, LLC
- Condo
- Active
- Updated 1 day ago
- 2Beds
- 2Total Baths
- 1,533Sq. Ft.
- MLS # 1060785
Listed by eXp Realty LLC
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 4Beds
- 4Total Baths
- 6,430Sq. Ft.
- MLS # 1047075
Listed and Sold by Compass - Boulder
- Single Family
- Closed
- 4Beds
- 4Total Baths
- 4,616Sq. Ft.
- MLS # 1056046
Listed by Suzy Williamson
Sold by Denise Patryas
Sold by Denise Patryas
- Single Family
- Closed
- 5Beds
- 3Total Baths
- 3,020Sq. Ft.
- MLS # 1041099
Listed by Compass - Boulder
Sold by Compass - Boulder
Sold by Compass - Boulder
- Single Family
- Closed
- 5Beds
- 5Total Baths
- 6,484Sq. Ft.
- MLS # 9302961
Listed by Compass Colorado, LLC - Boulder and Compass - Denver
Sold by RE/MAX of Boulder
Sold by RE/MAX of Boulder
677 County Road 18, Longmont, CO 80504 (MLS# 1063026) is a Single Family property with 4 bedrooms, 2 full bathrooms and 3 partial bathrooms. 677 County Road 18 is currently listed for $1,999,970 and was received on May 11, 2026. Want to learn more about 677 County Road 18? Do you have questions about finding other Single Family real estate for sale in Longmont? You can browse all Longmont real estate or contact a Coldwell Banker agent to request more information.