The Brian Petrelli Team is your St. Vrain Valley School District home experts..
Let our St. Vrain Valley School District agents help you find the perfect home in the St. Vrain Valley School district for your needs. Don't see what you're looking for here? Contact our team for a free, custom search.
MLS #: 4567891057753
Status: active
Listing Office: wk real estate longmont
Broker Remarks:
live the resort lifestyle in this exquisite european-inspired, tuscan-mediterranean home, where timeless architecture meets premier lakefront living. stone lined bridge over moat leads to a grand portico entry and elegant curved turret create a striking first impression, while the private cul-de-sac...
more...
MLS #: 4567891050500
Status: active
Listing Office: compass - boulder
Broker Remarks:
completely reconstructed in 2025 and tucked in boulder's lake of the pines, the city's only gated community, this newly rebuilt waterfront retreat pairs modern luxury with timeless design. the home showcases meticulous craftsmanship, all-new systems, and thoughtful design. set on 1.25 wooded acres w...
more...
MLS #: 4567891055566
Status: active
Listing Office: re/max of boulder, inc
Broker Remarks:
set on one of the most coveted lots in prestigious somerset estates, this exceptional estate offers a rare blend of privacy, scale & sweeping front range views. tucked at the end of a private cul-de-sac on 1.10 acres, the home is introduced by a circular drive and covered entry, setting the tone for...
more...
MLS #: 4567891050525
Status: active
Listing Office: madison & company properties - niwot
Broker Remarks:
welcome to 7401 deerfield road, an exceptional retreat in longmont, colorado, where refined modern design meets peaceful country living. set on an expansive lot with breathtaking mountain views, this beautifully remodeled home offers privacy, luxury, and resort-style amenities at every turn. the tho...
more...
MLS #: 5795042
Status: active
Listing Office: re/max of boulder
Broker Remarks:
set on one of the most coveted lots in prestigious somerset estates, this exceptional estate offers a rare blend of privacy, scale & sweeping front range views. tucked at the end of a private cul-de-sac on 1.10 acres, the home is introduced by a circular drive and covered entry, setting the tone for...
more...
MLS #: 3364204
Status: active
Listing Office: equity colorado real estate
Broker Remarks:
welcome to your dream home, where luxury meets the serenity of lakefront living. this exclusive property offers direct access to a private lake, perfect for all your favorite water activities. whether you're into water skiing, surfing, wakeboarding, or fishing, this home is your year-round waterfron...
more...
MLS #: 4567891056185
Status: active
Listing Office: madison & company properties - niwot
Broker Remarks:
welcome to 9260 shooting star court, a beautifully crafted residence tucked away on a quiet cul-de-sac in the heart of niwot. offering a seamless blend of timeless design and modern comfort, this home features expansive, light-filled living spaces designed for both everyday living and effortless ent...
more...
MLS #: 456789996820
Status: active
Listing Office: 375 realty llc
Broker Remarks:
nearly 40 acres in the heart of rural boulder county! "the creek", currently an equestrian facility. take on existing biz for 30++ horses or bring your 4h projects or make it your dream estate. property offers 2 barns with 13 stalls, loafing sheds for the rest. indoor arena, outdoor arena, hay barn,...
more...
MLS #: 4154785
Status: active
Listing Office: compass - denver
Broker Remarks:
a once-in-a-lifetime opportunity to own one of the front range’s most extraordinary lakefront properties. some homes simply check boxes. others redefine the way you live.
tucked behind the gates of one of longmont’s most private communities, this extraordinary lakefront estate is positioned directl...
more...
Broker Remarks:
new price + $400,000 in mechanical improvements - new tile roof, heating and cooling systems. welcome to a truly one-of-a-kind property, inside and out. upon entrance through the gate, a tree-lined drive sets the tone—its canopy lush and vibrant in both summer and fall. the circular driveway makes t...
more...
MLS #: 4865499
Status: active
Listing Office: nav real estate
Broker Remarks:
952 rembrandt road is one of the rare boulder properties where the views feel almost limitless. set on 35 private wooded acres within the gated enclave of buckingham hills, this nine-home community is surrounded by over 300 acres of protected forest — with panoramic views stretching from boulder res...
more...
MLS #: 4567891051039
Status: active
Listing Office: the agency - boulder
Broker Remarks:
welcome to a rare fusion of modern european elegance and colorado farmland serenity. set on 22 sweeping acres with 10 class a shares of boulder white rock ditch, this 2023-built estate delivers a lifestyle as dynamic as it is luxurious. every detail has been crafted for impact-from the dramatic aust...
more...
Broker Remarks:
this stunning equestrian estate is newly remodeled and completely updated! on over 11 acres of breathtaking colorado acreage, this stunning home sits along the st. vrain river with expansive front range mountain views. this premier estate offers an unparalleled blend of sophisticated comfort and equ...
more...
MLS #: 4567891058211
Status: active
Listing Office: re/max of boulder, inc
Broker Remarks:
situated at the top of niwot's premier somerset estates community, this iconic residence rests on a private 1-acre lot backing to open space & trails, offering unobstructed views of the flatirons & front range. enjoy thoughtfully curated grounds w/ lush landscaping, pond, stream, vibrant gardens & n...
more...
MLS #: 9491651
Status: active
Listing Office: re/max of boulder
Broker Remarks:
situated at the top of niwot's premier somerset estates community, this iconic residence rests on a private 1-acre lot backing to open space & trails, offering unobstructed views of the flatirons & front range. enjoy thoughtfully curated grounds w/ lush landscaping, pond, stream, vibrant gardens & n...
more...
The content relating to real estate for sale in this web site comes
in part from the Internet Data eXchange ("IDX") program of
METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other
than The Brian Petrelli Team are marked with the IDX Logo.
This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
