Metro Denver Luxury Homes For Sale

Property Description

Charming 3-bedroom, 3-bath home featuring an incredible oversized 4-car garage that offers exceptional space for vehicles, storage, hobbies, and projects. As you enter, you’re welcomed by beautiful hardwood floors and an open floor plan with well-defined living spaces that feel both spacious and inviting. The entry flows seamlessly into the formal dining area, creating an ideal layout for gathering and entertaining. The gourmet kitchen is a chef’s dream, showcasing upgraded matte black KitchenAid stainless steel appliances, rich espresso cabinetry, granite countertops, a large island with bar seating, and abundant natural light — perfect for both everyday living and hosting. The cozy living room provides a comfortable place to relax, and a convenient powder bath completes the main level. Upstairs, the spacious primary suite offers a luxurious 5-piece ensuite bath and a walk-in closet. Two additional bedrooms, a full bathroom, laundry room, and a versatile loft area complete the upper level. The enclosed loft provides excellent flexibility for a home office, media space, or additional living area. The unfinished basement is filled with natural light and offers excellent potential for future expansion, recreation space, hobbies, or additional storage. Step outside to a truly impressive backyard oasis designed for relaxation and enjoyment, featuring extensive patio space, a storage shed, and plenty of room for entertaining. With easy access to local parks and recreational amenities, this home offers the perfect balance of comfort and convenience — and best of all, no HOA, low Weld County taxes, and no metro district. Enjoy close proximity to Carbon Valley Regional Library, Frederick Skate Park, Milavec Lake, and Bella Rosa Golf Course.

Features
: Forced Air
: Central Air
: Unfinished
: Full
: Front Porch, Patio
: 4
: Dishwasher, Microwave, Range, Refrigerator
: Contemporary
: Oversized, Tandem
: Composition
: Public Sewer
Address Map
CO
Weld
Longmont
80504
Harlequin
9145
Circle
W105° 3' 1.9''
N40° 8' 6.8''
Additional Information
: Cement Siding, Stone
Centennial
: Private Yard
: Carpet, Tile, Wood
4
Frederick
Yes
Yes
Cash, Conventional, FHA, VA Loan
Coal Ridge
Farmhouse Realty
R0741901
: None
: House
Noname Creek West
$3,878
2025
: Electricity Connected, Natural Gas Connected
02/26/2026
2813
Active
1
St. Vrain Valley RE-1J
St. Vrain Valley RE-1J
St. Vrain Valley RE-1J
02/27/2026
02/27/2026
: Two

Noname Creek West

9145 Harlequin Circle, Longmont, CO 80504

3 Bedrooms
3 Total Baths
1,953 Square Feet
$584,900
Listing ID #6490572
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : 6490572
Price : $584,900
Bedrooms : 3
Rooms : 10
Total Baths : 3
Full Bathrooms : 2
1/2 Bathrooms : 1
Square Footage : 1,953 Square Feet
Year Built : 2012
Lot Area : 0.16 Acres
Lot Acres : 0.16
Property Sub Type : Single Family Residence
Status : Active
Originating System Name : REcolorado
Mortgage Calculator
$
$ %
years
%
$ %per year
$ %per year

$
Contact Agent
Open Dates
  • 1. 2026-02-28 (Start time: 2026-02-28T19:00:00Z - End time: 2026-02-28T21:00:00Z)
  • 2. 2026-03-01 (Start time: 2026-03-01T19:00:00Z - End time: 2026-03-01T21:00:00Z)