Qualifying buyers may have the opportunity to ASSUME the seller's existing VA loan with a LOW interest rate. Experience elevated living in the sought-after Mad Russian Estates golf course community, set among rolling hills with beautiful Rocky Mountain views. NO HOA and NO METRO TAX. Nearly 3,500 sq ft of light-filled luxury in a meticulously maintained 2-story residence designed for comfort, function, and entertaining. An open-concept main living area features cathedral ceilings, abundant natural light, and oversized windows that bring in the surrounding landscape. High-end finishes include granite countertops, LVP flooring, and an updated kitchen. Elegant chandeliers add a refined touch. The kitchen offers custom slide-out shelving and a pantry with four floor-to-ceiling storage cabinets for exceptional organization. A large, separate dining room provides a defined space for gatherings, distinct from the main living area. Main-level bedroom or office with adjacent full bath offers flexibility for guests, multigenerational living, or remote work. Upstairs, the primary suite is a spacious retreat with a 5-piece bath and walk-in closet. Two additional bedrooms, a full bath, and upper-level laundry complete the second floor. Views from upstairs allow you to enjoy cotton candy skies at sunrise and sunset, plus both mountain and cityscapes. Outdoor living shines with a covered front porch and swing, gated deck, and expansive wraparound patio extending around the home-ideal for entertaining and enjoying the day. The fully fenced yard includes full sprinkler coverage and a raised garden bed. A massive unfinished basement spans the full footprint, offering rare expansion potential. Additional highlights include a new Class 4 roof (9/2023), oversized 3-car garage, and south-facing orientation for natural light and snow melt. Conveniently located 15 minutes to I-25, 10 minutes to Greeley, and about an hour to Denver.
86 days
|
331
|
15
|
Zillow last checked:
Listing updated:
Listed by:
Deni Niethammer303-995-4742,
The Resource Group, LLC
Source: IRES as distributed by MLS GRID,MLS#: 1057997
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Full bathrooms: 3
Main level bathrooms: 1
Primary bedroom
Description: Carpet
Level: Upper
Area: 280 Square Feet
Dimensions: 14 x 20
Bedroom 2
Description: Carpet
Level: Main
Bedroom 3
Description: Carpet
Level: Upper
Bedroom 4
Description: Carpet
Level: Upper
Dining room
Description: Luxury Vinyl
Level: Main
Kitchen
Description: Luxury Vinyl
Level: Main
Area: 252 Square Feet
Dimensions: 12 x 21
Laundry
Description: Tile
Level: Upper
Living room
Description: Luxury Vinyl
Level: Main
Heating
Forced Air
Cooling
Central Air
Appliances
Included: Electric Range, Gas Range, Dishwasher, Refrigerator, Disposal
Laundry: Washer/Dryer Hookup
Features
Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, High Ceilings
Windows: Window Coverings
Basement: Unfinished
Has fireplace: No
Fireplace features: None
Interior area
Total structure area: 2,368
Total interior livable area: 3,492 sqft
Finished area above ground: 2,368
Property
Parking
Total spaces: 3
Parking features: Garage Door Opener, Attached, Oversized
Attached garage spaces: 3
Details: Attached
Accessibility
Accessibility features: Main Floor Bath, Accessible Bedroom
Features
Levels: Two
Stories: 2
Patio & porch: Patio, Deck, Enclosed
Exterior features: Sprinkler System
Spa features: Bath
Fencing: Fenced,Vinyl
Has view: Yes
View description: Hills, City
Lot
Size: 7,320 Square Feet
Features: Sloped, Near Golf Course, Paved, Curbs, Sidewalks
Details
Parcel number: R8424200
Zoning: RES
Special conditions: Private Owner
Construction
Type & style
Home type: SingleFamily
Property subtype: Single Family Residence
Materials
Frame
Roof: Composition
Condition
New construction: No
Year built: 2015
Utilities & green energy
Electric: Poudre Valley
Gas: Xcel
Sewer: Public Sewer
Water: City
Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail, Underground Utilities
Exclusions: TV mount in primary bedroom, TV mount in living room, microwave (not built in), personal decor, playground, trampoline, washer and dryer, personal property and furniture, refrigerator in basement, 2 deep freezers in garage, patio furniture, grills, hanging planters, hooked planters, ring doorbell, security cameras.
Electric utility on property: Yes
Road surface type: Asphalt
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
7/6/2026
Price change
$635,000-1.1%$182/sqft
Source: IRES as distributed by MLS GRID #1057997Report a problem
5/1/2026
Listed for sale
$642,000+32.4%$184/sqft
Source: REcolorado as distributed by MLS GRID #IR1057997Report a problem
Explore the cost of this home by adjusting the details. Changes won't be saved.
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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.