Public Remarks: Stunning modern farmhouse nestled on 1.5+ acre lakefront property overlooks breathtaking panoramic lake and mountain views. Rare and exclusive access to motorized recreation on Gaynor Lake and a convenient, private dock combine to provide an unrivaled boating lifestyle. White oak wood floors and soaring cathedral ceilings open to a spacious living room with a stone wrapped fireplace and vast accordion glass doors that effortlessly flow to an expansive deck with jaw dropping views. A gourmet kitchen boasts a high end appliance package, butler's pantry and breakfast nook. The luxurious primary suite includes a cozy fireplace and offers utmost privacy and relaxation amid a serene lake backdrop. A custom double sided steel fireplace flows from the suite to a chic, glassed office space Unwind in a lavish five piece bath with a 72" hydro massage tub and oversized steam shower with floating bench. Walk in closet conveniently leads to main level laundry. Upstairs, a non conforming bedroom or additional office space leads to a private upper deck overlooking sweeping views. An open tread staircase framed by a soaring stone accent wall leads downstairs. The lower level suite offers ideal separate living or entertaining space with walkout access, a rec room, wet bar, exercise space, separate laundry hookups, 2 bedrooms & 3 baths.
Single-familyProperty Type
2020Year Built
1.6 acresLot Size
$706Est. Price/Sq.Ft.
3 car garageParking
Listed by Tatiana Tebo• Tebo Realty & Design, LLC
Listed by Beau Burris• Slifer Smith & Frampton-Bldr
Contact: 6302443566
Bought with Angie Clauser• Windermere Fort Collins
Rare lakefront opportunity! This is your chance to have it all, lakefront property with spectacular mountain views/sunsets, yet close to Niwot and Longmont amenities, restaurants and shopping! Open floor plan with finished walk-out basement and lots of natural light. Big yard that's great for entertaining, one of the largest lakefront lots in Gaynor Lake and a boat dock with lift. 4 beds, 4 baths, over 4400 SF. This home is ready for upgrades and your personal touch to make it a dream come true!
IRES as Distributed by MLS Grid #502491
Mar 3, 2007
Listing Removed
—
Jul 30, 2006
Listed
$1,085,000
$159/sq ft
IRES as Distributed by MLS Grid #459605
Nov 4, 2005
Listing Removed
—
Jul 19, 2005
Listed
$975,000
$143/sq ft
IRES as Distributed by MLS Grid #187904
Jan 19, 1999
Sold
$625,000
$92/sq ft
Sep 10, 1998
Listed
$629,000
$92/sq ft
Public Records
Sep 16, 1997
Sold
$397,000
$58/sq ft
Public Records
Jan 24, 1984
Sold
$60,000
$9/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$26,938 (+7.9%)
$34,638 + $214,575
$249,213
2024
$24,961 (+1.3%)
$34,638 + $214,575
$249,213
2023
$24,631 (+35.1%)
$16,462 + $236,657
$253,119
2022
$18,230 (−1.3%)
$20,147 + $236,657
$256,804
2021
$18,474 (+36.2%)
$18,105 + $160,677
$178,782
2020
$13,568 (+139.1%)
$18,626 + $165,301
$183,927
2019
$5,674 (−28.7%)
$28,672 + $106,721
$135,393
2018
$7,959 (+16.6%)
$28,672 + $28,664
$57,336
2017
$6,827 (+2.0%)
$26,064 + $54,994
$81,058
2016
$6,693 (+5.0%)
$26,064 + $54,994
$81,058
2015
$6,374 (+30.9%)
$24,119 + $54,781
$78,900
2014
$4,869 (−10.5%)
$27,860 + $33,034
$60,894
2013
$5,438 (+7.9%)
$27,860 + $33,034
$60,894
2012
$5,041 (−6.7%)
$27,860 + $33,034
$60,894
2011
$5,404 (−11.2%)
$30,646 + $32,477
$63,123
2010
$6,088 (+1.8%)
$30,646 + $32,477
$63,123
2009
$5,982
$34,830 + $36,970
$71,800
Tax history for 10508 Mooring Rd
Year
Property tax
Land + Additions
Assessment*
2025
$26,938 (+7.9%)
$34,638 + $214,575
$249,213
2024
$24,961 (+1.3%)
$34,638 + $214,575
$249,213
2023
$24,631 (+35.1%)
$16,462 + $236,657
$253,119
2022
$18,230 (−1.3%)
$20,147 + $236,657
$256,804
2021
$18,474 (+36.2%)
$18,105 + $160,677
$178,782
2020
$13,568 (+139.1%)
$18,626 + $165,301
$183,927
2019
$5,674 (−28.7%)
$28,672 + $106,721
$135,393
2018
$7,959 (+16.6%)
$28,672 + $28,664
$57,336
2017
$6,827 (+2.0%)
$26,064 + $54,994
$81,058
2016
$6,693 (+5.0%)
$26,064 + $54,994
$81,058
2015
$6,374 (+30.9%)
$24,119 + $54,781
$78,900
2014
$4,869 (−10.5%)
$27,860 + $33,034
$60,894
2013
$5,438 (+7.9%)
$27,860 + $33,034
$60,894
2012
$5,041 (−6.7%)
$27,860 + $33,034
$60,894
2011
$5,404 (−11.2%)
$30,646 + $32,477
$63,123
2010
$6,088 (+1.8%)
$30,646 + $32,477
$63,123
2009
$5,982
$34,830 + $36,970
$71,800
*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
Beds
4
Baths
5.5
Stories
1
Lot width
—
Lot depth
—
Lot size
1.6 Acres
Year renovated
2017
Sq. Ft.
5,763
Year built
2017
Style
Single Family Residential
County
Boulder County
APN
R0090495
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
A
Agricultural District
Rural areas where conservation of agricultural resources is of major value, and where residential development compatible with agricultural uses is allowed.
Permitted uses
Include but are not limited to:
Agriculture
Equestrian facility
Livestock production
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Bed & breakfast
Educational/school
Kennel
Property details
Parking
Parking Features
Covered Spaces: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Parking Features: Garage Door Opener
Interior
Bathroom Information
Bathrooms (Full): 5
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 4
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Heat Pump, Radiant
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer
Fireplace: Yes
Fireplace Features: Gas, Great Room
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Wet Bar, Kitchen Island, Steam Shower, 9ft+ Ceilings
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: Walk-Out Access
Exterior
Exterior Features
Patio and Porch Features: Patio, Deck
Roof: Metal
Land Information
Road Surface Type: Asphalt
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System, Level
Road Frontage Type: City Street
Zoning: A
Property Information
Property Type: Residential
View: Yes
Waterfront: Yes
Subdivision Information
Subdivision Name: Gaynor Lake 2
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 5763
Below Grade Finished Area: 0
Building Area Total: 5763
Construction Materials: Wood/Frame, Brick/Brick Veneer, Stone
Financial
Tax Information
Parcel Number: R0090495
Tax Annual Amount: 18230
Tax Year: 2022
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available
Gas: Natural Gas
Sewer: Septic
Location
HOA Information
Association: Yes
Association Fee: 525
Association Fee Frequency: Annually
Association Fee Includes: Common Amenities
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Indian Peaks
Middle or Junior School: Sunset Middle
High School: Niwot
Location Information
Directions: From highway 287 and Niwot road, head north on 287, and west on Mooring road.
Unparsed Address: 10508 Mooring Rd Longmont CO 80504
Street Number: 10508
Street Name: Mooring
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80504
Coordinates: -105.10722,40.12364
Latitude: 40.12364
Longitude: -105.10722
Public facts
Beds: 4
Baths: 5.5
Sq. Ft.: 5,763
Stories: 1.0
Lot Size: 1.6 acres
Style: Single Family Residential
Year Built: 2017
Year Renovated: 2017
County: Boulder County
APN: R0090495
Home facts updated by county records on Sep 2, 2026
Other
Miscellaneous Information
Exclusions: Seller's Personal Property
Listing Information
Attribution Contact: 6302443566
Close Price: $5,000,025
Photos Count: 37
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Monday, November 6, 2023
Cumulative Days on Market: 20
Days on Market: 20
Listing Contract Date: Wednesday, October 11, 2023
Modification Timestamp: Friday, August 2, 2024 12:24 PM
Home Information
Levels: Three Or More
Window Features: Window Coverings, Skylight(s)
Year Built: 2020
Green Information
Green Energy Efficient: Energy Rated
Efficient Hot Water Distribution
Power Production Type: Photovoltaics
Around this home
Schools
Indian Peaks Elementary School
Public PreK-5 • Assigned • 1.5mi
4/10
Sunset Middle School
Public 6-8 • Assigned • 1.6mi
6/10
Niwot High School
Public 9-12 • Assigned • 2.4mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
0.93% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 94° expected this year, 18 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
6/10 Air Factor
10 unhealthy days expected this year, 10 days in 30 years
Provided by First Street
Historical weather
Longmont, CO • 80504
Average low and high temperatures (°F)
42
16
52
23
65
36
65
37
72
46
85
55
92
61
87
57
79
50
69
41
55
29
53
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 6 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$4.58M – $5.54M
Reach more buyers when you sell with Redfin. Save up to $48,166 in fees.3 minutes to get started.