Skip to main contentSkip to navigation
1 / 48

Land with Home for Sale in Longmont, Colorado

677 County Road 18, Longmont, CO 80504

$1,999,970
10 acres
Active sale
ago
Est $10,907/mo

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.

7,050
Sq feet
4
Beds
2
Full baths
1
3/4 bath
2
1/2 baths
1985
Built

Location

Street address
677 County Road 18
Zip code
80504
Community
Rec Exempt
School district
St. Vrain Valley RE-1J
Elevation
4,995 feet
Coordinates
40.1174, -105.0424

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

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

CategoryTypeStatus
PowerGridAvailable
GasNatural GasAvailable
WaterPublicAvailable
SewageSeptic SystemConnected
WaterPrivate WellConnected

Nearby schools

NameTypeDistrict
Grand ViewElementarySt. Vrain Valley RE-1J
Coal RidgeMiddle
MeadHighSt. Vrain Valley RE-1J

Listing history

DateEventPriceChangeSource
June 30, 2026New listing$1,999,970REcolorado
Subscribe to listing updates

Payment calculator

This 10-acre property is located at 677 County Road 18 in Longmont, CO 80504. The property is available for sale, priced at $1,999,970. It has a 7,050 square foot 4-bedroom, 4-bath house built in 1985.

Checked 1 hour agoUpdated

Report listing issue
REcolorado

Based on information submitted to the MLS GRID as of June 29, 2026 11:00 pm MT. 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. Some IDX listings have been excluded from this website. View more

Contact agent Rules
By submitting, I agree to the terms of use and to be contacted by real estate professionals. Message and data rates may apply.
Contact