Public Remarks: 25K Price Reduction! Private corner lot with lush mature landscaping makes this property feel like your own country home. Open floor plan, vaulted ceilings, ample built in storage and spacious rooms adorn the inside and mature vegetation, custom landscaping, and an adjacent golf course invite you outside. This well maintained and move in ready home is a must see.
Single-familyProperty Type
1986Year Built
7,680 sq ftLot Size
$191Est. Price/Sq.Ft.
2 car garageParking
Listed by Keith Kozielski• KPK Realty, LLC
Contact: 3039173239
Bought with John Marlin• Prudential Rky Mtn Realtors Lg
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
2
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
7,679 Sq. Ft.
Year renovated
1986
Sq. Ft.
2,566
Year built
1986
Style
Single Family Residential
County
Boulder County
APN
R0091263
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
R-MN
Residential Mixed Neighborhood District
This district is intended to be conveniently located near collector and arterial streets, and in close proximity to activity centers and other public amenities and/or complementary uses and activities such as schools, parks, open space, and public transit. The R-MN district can also serve as a transition from single-family neighborhoods to multifamily residential, mixed-use, and nonresidential areas.
Permitted uses
Include but are not limited to:
Housing-Single unit
Housing-Multiple units
Housing-Student
Infrastructure
Public service
Communications tower
Park & open space
Oct 3, 2017 • Final
Interior remodel - residential
Remodel
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Features
Covered Spaces: 2
Garage: Yes
Attached Garage: Yes
Garage Spaces: 2
Interior
Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 0
Bathrooms (Three Quarter): 1
Bedroom Information
Bedrooms Total: 3
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Disposal
Fireplace: Yes
Fireplace Features: Gas
Flooring: Wood Floors
Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
Laundry Features: Washer/Dryer Hookups, In Basement
Room Information
Basement: Full
Exterior
Exterior Features
Fencing: Fenced, Wood
Patio and Porch Features: Patio, Deck
Roof: Composition
Pool Information
Spa: Yes
Spa Features: Bath
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System, Corner Lot, Wooded, Level, Near Golf Course
Zoning: RES
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: The Valley
MLS Area Major: Longmont
Building Information
Above Grade Finished Area: 1620
Below Grade Finished Area: 1620
Building Area Total: 1620
Construction Materials: Wood/Frame, Brick/Brick Veneer
Financial
Tax Information
Parcel Number: R0091263
Tax Annual Amount: 1754
Tax Year: 2011
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,City
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
Association Fee: 0
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Longmont Estates
Middle or Junior School: Westview
High School: Silver Creek
Location Information
Directions: From Hwy 66 & Hover Road (N. 95th St.) in Longmont, Head south on Hover Road to 9th Avenue, Go West on 9th Avenue to Wade Rd. Take a left (South) on Wade Road to house on your right.
Unparsed Address: 857 Wade Rd Longmont CO 80503
Street Number: 857
Street Name: Wade
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.14367,40.17384
Latitude: 40.17384
Longitude: -105.14367
Public facts
Beds: 2
Baths: 3.0
Sq. Ft.: 2,566
Stories: 1.0
Lot Size: 7,679 square feet
Style: Single Family Residential
Year Built: 1986
Year Renovated: 1986
County: Boulder County
APN: R0091263
Home facts updated by county records on Sep 2, 2026
Other
Miscellaneous Information
Exclusions: washer and dryer
Listing Information
Attribution Contact: 3039173239
Close Price: $227,500
Photos Count: 20
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, March 23, 2012
Cumulative Days on Market: 190
Days on Market: 190
Listing Contract Date: Tuesday, September 20, 2011
Modification Timestamp: Saturday, July 27, 2024 8:21 AM
Home Information
Direction Faces: East
Door Features: Storm Door(s)
Window Features: Window Coverings, Double Pane Windows
Year Built: 1986
Around this home
Schools
Longmont Estates Elementary School
Public PreK-5 • Assigned • 0.8mi
7/10
Westview Middle School
Public 6-8 • Assigned • 1.1mi
7/10
Silver Creek High School
Public 9-12 • Assigned • 2.0mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
A vibrant northern Colorado community known for its scenic mountain views, extensive parks and trails, greenways, and a mix of established neighborhoods and newer housing options.