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 waterfront retreat. And yes-bring your boat! Step inside and be captivated by the elegance throughout. The gourmet kitchen is a chef's dream, featuring top-of-the-line appliances, exquisite finishes, and plenty of space for culinary creations. As the day winds down, bask in the breathtaking mountain sunsets over the shimmering lake from your spacious patio. Cozy up by the firepit or enjoy the multiple outdoor entertaining spaces perfect for gatherings. This home is an entertainer's paradise, featuring a rec room designed for fun and relaxation. Challenge your friends to games of pool, foosball, or shuffleboard. Watch the latest blockbuster in the theater area or dive into your favorite video games in the dedicated gaming space. The basement also boasts a full bar complete with an ice maker, wine chiller, and kegerator, making it the ultimate spot for hosting unforgettable gatherings. Stay active in your expansive workout room, complete with a built-in sauna for post-exercise relaxation. Every detail in this home has been thoughtfully curated to provide an unparalleled living experience. Bring your pets! Invisible Fence and Dog Run already installed for your furry friends!
Don't miss the chance to own this one-of-a-kind lakefront estate, where luxury, adventure, and natural beauty come together to create the ultimate lifestyle!
Offered By
Marshall Marquardt marshall@equity-usa.com,402-980-0090, Equity Colorado Real Estate
Playground, Fitness Center, Park, Hiking/Biking Trails, Gated
HOA
1
TAX AMOUNT
14311.0
HOA FEE
1250.0
HOA FREQUENCY
Quarterly
LATEST UPDATE
2025-06-26T22:41:24.297Z
DAYS ON MARKET
2
PRICE CHANGE(S)
$3,200,000 Jun 22, 2025
CUMULATIVE DAYS ON MARKET
2
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet7,013
MLS #3364204
Bathrooms (¾)2
FIREPLACE FEATURESLiving Room
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesElectricity Available
SEWERCity Sewer, Public Sewer
WATER SOURCECity Water
Year Built2016
BasementFull, Partially Finished
FINISHED BASEMENT SIZE3506.0
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofFiberglass
FencePartial
Lot FeaturesLawn Sprinkler System, Waterfront
Garage spaces3
Other StructuresKennel/Dog Run
ViewMountain(s), Water
CITYLongmont
SUBDIVISIONPelican Shores
COUNTYWeld
AREAGreeley/Weld
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPlayground, Fitness Center, Park, Hiking/Biking Trails, Gated
HOA1
TAX AMOUNT14311.0
HOA FEE1250.0
HOA FREQUENCYQuarterly
LATEST UPDATE2025-06-26T22:41:24.297Z
DAYS ON MARKET2
PRICE CHANGE(S)
$3,200,000 Jun 22, 2025
CUMULATIVE DAYS ON MARKET2
Market Trends
New Properties On Market
147
88%
Increase In New Listings
Average Asking Price
$713,560
$17,639 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$239
$2 Decrease In List Price/Sq. Ft.
Average Days On Market
9
26 Day
Decrease In Days On Market
Data as of Jul 04, 2025.
Remaining statistics above are calculated on activity within the period from May 01, 2025 to Jun 30, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.