This beautiful custom designed new construction home offers a great mix of comfort and style. Enjoy four bedrooms, exciting architecture, covered patio and patio pergola. Watch the sunset over the mountains from the large second floor covered deck. Customize the finishes of this home to fit your design and style tastes. Enjoy mountain views from each bedroom. Too many quality elements to list.
New construction
$1,100,000
908 Sugar Mill Ave, Longmont, CO 80504
4beds
5,105sqft
:
Get pre-qualified$6,705/mo
Single Family Residence
Built in 2026
7,935 Square Feet Lot
$-- Zestimate®
$215/sqft
$-- HOA
What's special
Patio pergolaFour bedroomsCovered patio
- 168 days |
- 191 |
- 5 |
Zillow last checked:
Listing updated:
Listed by:
Brian Terry 303-845-0949,
Bosch Real Estate Group, LLC
Source: IRES as distributed by MLS GRID,MLS#: 1051469
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Rooms
- Room types: Loft
Primary bedroom
- Description: Carpet
- Features: 3/4 Primary Bath
- Level: Upper
- Area: 256 Square Feet
- Dimensions: 16 x 16
Bedroom 2
- Description: Carpet
- Level: Upper
- Area: 132 Square Feet
- Dimensions: 11 x 12
Bedroom 3
- Description: Carpet
- Level: Upper
- Area: 132 Square Feet
- Dimensions: 11 x 12
Bedroom 4
- Description: Carpet
- Level: Upper
- Area: 165 Square Feet
- Dimensions: 11 x 15
Dining room
- Description: Wood
- Level: Main
- Area: 99 Square Feet
- Dimensions: 11 x 9
Great room
- Description: Carpet
- Level: Main
- Area: 432 Square Feet
- Dimensions: 18 x 24
Kitchen
- Description: Wood
- Level: Main
- Area: 260 Square Feet
- Dimensions: 13 x 20
Laundry
- Description: Tile
- Level: Upper
- Area: 55 Square Feet
- Dimensions: 5 x 11
Study
- Description: Carpet
- Level: Main
- Area: 135 Square Feet
- Dimensions: 9 x 15
Heating
- Forced Air
Appliances
- Included: Electric Range, Self Cleaning Oven, Dishwasher, Microwave
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Walk-In Closet(s), Kitchen Island
- Flooring: Wood
- Basement: Full
- Has fireplace: Yes
- Fireplace features: Insert
Interior area
- Total structure area: 3,364
- Total interior livable area: 5,105 sqft
- Finished area above ground: 3,364
Property
Parking
- Total spaces: 3
- Parking features: Attached
- Attached garage spaces: 3
- Details: Attached
Features
- Levels: Two
- Stories: 2
- Has view: Yes
- View description: Mountain(s), Hills, City
Lot
- Size: 7,935 Square Feet
- Features: Sloped, Paved, Curbs, Gutters
Details
- Parcel number: R0618046
- Zoning: PUD
- Special conditions: Builder
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Stucco
- Roof: Composition
Condition
- New construction: Yes
- Year built: 2026
Details
- Builder model: Custom
Utilities & green energy
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available
Community & HOA
Community
- Subdivision: Trinity Subdivision Replat A
HOA
- Has HOA: No
Location
- Region: Longmont
Financial & listing details
- Price per square foot: $215/sqft
- Date on market: 2/12/2026
- Listing terms: Cash
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 3/17/2026 | Price change | $1,100,000-18.5%$215/sqft |
Source:  IRES as distributed by MLS GRID #1051469 Report a problem | ||
| 2/12/2026 | Price change | $1,350,000+610.5%$264/sqft |
Source: IRES as distributed by MLS GRID #1051469 Report a problem | ||
| 6/18/2025 | Price change | $190,000-19.1%$37/sqft |
Source: IRES as distributed by MLS GRID #1022889 Report a problem | ||
| 4/7/2025 | Price change | $235,000-4.1%$46/sqft |
Source: IRES as distributed by MLS GRID #1022889 Report a problem | ||
| 11/30/2024 | Listed for sale | $245,000$48/sqft |
Source: IRES as distributed by MLS GRID #1022889 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: Kensington
Nearby schools
GreatSchools rating
- 5/10Rocky Mountain Elementary SchoolGrades: PK-5Distance: 0.4 mi
- 4/10Trail Ridge Middle SchoolGrades: 6-8Distance: 1 mi
- 3/10Skyline High SchoolGrades: 9-12Distance: 0.7 mi
Schools provided by the listing agent
- Elementary: Rocky Mountain
- Middle: Heritage
- High: Skyline
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $190,0008,050 Square Feet902 Sugar Mill Ave, Longmont, CO 80504Lot/Land
- $190,0008,013 Square Feet908 Sugarmill Rd, Longmont, CO 80501Lot/Land
- $293,300-- bd-- ba-- sqft901 E 9th Ave, Longmont, CO 80504Off Market
- $293,300-- bd-- ba-- sqft901 E 9th Ave, Longmont, CO 80504Off Market
- $296,100-- bd-- ba-- sqft901 E 9th Ave, Longmont, CO 80504Off Market
- $651,6184 bd1 ba3.2k sqft901 E 9th Ave, Longmont, CO 80504Off Market
- $605,1003 bd3 ba2.7k sqft812 Zachary Ct, Longmont, CO 80504Off Market
- $654,4003 bd1 ba2.2k sqft922 Sugar Mill Ave, Longmont, CO 80504Off Market
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- $1,245,0004 bd4 ba3.7k sqft12766 Strawberry Cir, Longmont, CO 80503For Sale
MLS ID #1051272, Marilyn Ackerman, HomeSmart Realty. IRES as distributed by MLS GRID - $1,199,0004 bd4 ba3k sqft9032 Tahoe Ln, Boulder, CO 80301For Sale
MLS ID #1064927, The Bernardi Group, Coldwell Banker Realty-Boulder. IRES as distributed by MLS GRID - $1,100,0004 bd3 ba5.1k sqft27850 Hopi Trl W, Loveland, CO 80534For Sale
MLS ID #1039886, Naomi Malone, Harmony Brokers. IRES as distributed by MLS GRID - $750,0005 bd3 ba2.9k sqft5514 Mustang Dr, Frederick, CO 80504For Sale
MLS ID #1064327, Josh Roberson, Ideal Team Homes. IRES as distributed by MLS GRID - $1,079,9004 bd4 ba3.9k sqft16263 Geneva Court, Brighton, CO 80602New Construction
MLS ID #6275081, Tom Ullrich, RE/MAX Professionals. REcolorado as distributed by MLS GRID - $1,129,0003 bd3 ba3.2k sqft108 Lonestar Rd, Lyons, CO 80540For SaleMLS ID #1051749, Laura Levy, Coldwell Banker Realty-Boulder. IRES as distributed by MLS GRID
- $1,150,0003 bd3 ba3.9k sqft3304 Heron Lakes Pkwy, Berthoud, CO 80513For SaleMLS ID #1063046, Stefanie Erion, Kentwood RE Northern Prop Llc. IRES as distributed by MLS GRID
- $719,9505 bd3 ba3.7k sqft5451 Green Thumb Avenue, Firestone, CO 80504New ConstructionREcolorado as distributed by MLS GRID
- $940,0004 bd4 ba4k sqft3423 Pacific Peak Drive, Broomfield, CO 80023For SaleMLS ID #5974014, Megan Denham, Resident Realty North Metro LLC. REcolorado as distributed by MLS GRID
- $1,395,0004 bd3 ba4.7k sqft420 E County Road 10 Rd, Berthoud, CO 80513For SaleMLS ID #1051681, James Gentry, Hayden Outdoors - Windsor. IRES as distributed by MLS GRID
- $1,399,0004 bd6 ba4.5k sqft4481 Clay St, Boulder, CO 80301For SaleMLS ID #1064765, Laurie Kaufman, milehimodern - Boulder. IRES as distributed by MLS GRID
- $1,177,5004 bd4 ba4.2k sqftDillon Pointe, Broomfield, CO 80020For SaleMLS ID #1952728, Seth Williamson, WK Real Estate. REcolorado as distributed by MLS GRID
- $950,0004 bd3 ba3.4k sqft5905 County Road 38, Platteville, CO 80651For SaleMLS ID #1045281, Karen Mikkelson, Mason & Morse Ranch Company. IRES as distributed by MLS GRID
- $1,199,0003 bd3 ba3.2k sqft5215 E County Road 16, Loveland, CO 80537For SaleMLS ID #1051177, Paul Jansen, Realty One Group Fourpoints. IRES as distributed by MLS GRID
- $1,422,0004 bd4 ba4.6k sqft1222 Eliza Ave, Berthoud, CO 80513New ConstructionMLS ID #1064710, Dennis Schick, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $684,0004 bd3 ba3.2k sqft2927 Glendevey Dr, Loveland, CO 80538For SaleMLS ID #1065418, Sam Moes, Roots Real Estate. IRES as distributed by MLS GRID
- $795,0003 bd2 ba4k sqft5842 Aspenglow St, Firestone, CO 80504New ConstructionIRES as distributed by MLS GRID
- $774,9904 bd4 ba3.8k sqft5891 Aspenglow St, Longmont, CO 80504New ConstructionIRES as distributed by MLS GRID
- $1,075,7005 bd6 ba4.5k sqft1651 Poplar Dr, Erie, CO 80516New ConstructionIRES as distributed by MLS GRID
- $644,9003 bd3 ba2.6k sqft232 High Point Dr, Longmont, CO 80504New ConstructionMLS ID #1061629, Tamara Sherrill, RE/MAX Alliance-FTC Dwtn. IRES as distributed by MLS GRID
