
Land with Home for Sale in Longmont, Colorado
677 County Road 18, Longmont, CO 80504
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.
- Listed by Arnold Turner, (303) 776-1105, Turner Realty
Location
- Street address
- 677 County Road 18
- County
- Weld County
- Zip code
- 80504
- Community
- Rec Exempt
- School district
- St. Vrain Valley RE-1J
- Elevation
- 4,995 feet
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.
Property details
- Acreage
- 10 acres
- Zoning
- SFR
- Access
- Private road
- MLS #
- REcolorado IR1063026
- Posted
Property taxes
- 2025
- $8,266
Parcels
- R4357606
Legal description
PT S2SE4 19-2-68 LOT A REC EXEMPT RE-107
Resources
Details and features
Listing
- Type
- Residential
- Subtype
- Single Family Residence
- Possible Use
- Agricultural
- Ownership
- Individual
- Terms
- Cash, Conventional, FHA, VA Loan
- Exclusions
- N/A, Water Rights Included, Mineral Rights Excluded
- Possession
- Closing/DOD
Lot
- Vegetation
- Grassed, Wooded
- Road Frontage
- Private Road, Public
- Road Surface
- Gravel
- Road Responsibility
- Private Maintained Road
- Exposure
- West
- View
- Mountain(s), Plains
- Well Permits
- 98097-Ve
- Rights
- Water Rights
- Features
- Level, Sprinklers in Front
Exterior
- Parking Spaces
- 3
- Parking
- Oversized, RV Access/Parking
- Garage
- Attached
- Fencing
- Fenced
- Horses Allowed
- Yes
- Equestrian
- Corral(s), Pasture, Tack Room
- Hot Tub
- Bath
- Outdoor Spaces
- Deck, Patio
- Features
- Dog Run, Gas Grill
Structure
- Type
- House
- Style
- Contemporary, Rustic
- Levels
- One
- Basement
- Sump Pump, Unfinished
- Water
- Well
- Sewer
- Septic Tank
- Heating
- Baseboard, Forced Air
- Cooling
- Ceiling Fan(s), Central Air
- Materials
- Brick, Frame, Vinyl Siding
- Roof
- Composition
- Windows
- Double Pane Windows, Skylight(s), Window Coverings
Interior
- Above Grade
- 6,085 sq ft
- Below Grade
- 965 sq ft
- Rooms
- Bathroom Full x 2, Bathroom Half, Bathroom Three Quarter, Bedroom x 4, Dining Room, Game Room, Kitchen, Laundry, Living Room, Office
- Flooring
- Wood
- Fireplaces
- Family Room, Insert, Living Room
- Appliances
- Bar Fridge, Dishwasher, Disposal, Double Oven, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
- Laundry
- In Unit
- Security
- Smoke Detector(s)
- Equipment
- Satellite Dish
- Features
- Eat-In Kitchen, Kitchen Island, Pantry, Primary Suite, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s)
Property utilities
| Category | Type | Status |
|---|---|---|
| Power | Grid | Available |
| Gas | Natural Gas | Available |
| Water | Public | Available |
| Sewage | Septic System | Connected |
| Water | Private Well | Connected |
Nearby schools
| Name | Type | District |
|---|---|---|
| Grand View | Elementary | St. Vrain Valley RE-1J |
| Coal Ridge | Middle | — |
| Mead | High | St. Vrain Valley RE-1J |
Listing history
| Date | Event | Price | Change | Source |
|---|---|---|---|---|
| June 30, 2026 | New listing | $1,999,970 | — | REcolorado |















































