Property Description

Wow take advantage on this unique + spacious Next Gen Home. This beautifully designed home offer you a one of a kind Next Gen Suite, featuring a private entrance, living room, kitchenette, bedroom and bathroom conveniently attach to the main house. This is perfect to have love ones close by and allowing for complete independence.
This home has a prime location with over 3,900 sqt ft living space backing to the community trail and Weld County open space. The home includes 5 large bedroom, 4.5 bathroom, oversize loft area, whole house carbon filtration system, reverse osmosis drinking water system plumbed into the kitchen sink and refrigerator, a solar system, dual Lennox furnaces and 2 ac units for efficient heating and cooling. Enjoy the oversize deck that runs the length of the home, perfect for outdoor living and entertainment. The unfinish basement gives you plenty of space for additional storage. Lets talk a bit about the interior upgrades, the home has a spectacular gourmet kitchen and top of the line appliances, large quartz counter, 5" wide plank flooring and 42" upgraded cabinets adjacent to a expansive dinning and living room which look out to the Weld County open space. Upstairs you will find a beautiful expansive primary bedroom and bathroom, large walkin closet and spacious retreat area, there are three additional bedrooms and large loft space perfect for a work at home office.
The home also have a great access to Boulder, Denver and DIA. Don't miss this rare opportunity to own a thoughtfully home flexible living option and spectacular location.

Launch 3D Virtual Tour

Opens in a new window

Included Appliances

DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher

Property Details

Interior

Above Grade Finished Area

3910

Appliances

DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher

Basement

Sump PumpUnfinished

Below Grade Unfinished Area

1958

Building Area Total

5868

Cooling

Central Air

Furnished

Unfurnished

Heating

Active SolarForced Air

Interior Features

Eat-in KitchenKitchen IslandOpen FloorplanQuartz CountersRadon Mitigation SystemSmoke FreeWalk-In Closet(s)

Laundry Features

Laundry Closet

Living Area

3910

Other Equipment

Air Purifier

Room Count

13

Security Features

Carbon Monoxide Detector(s)Radon DetectorSmoke Detector(s)Video Doorbell

Window Features

Double Pane WindowsWindow Coverings

Construction

Additional Living Structure

Yes

Also Marketed As

Residential

Architectural Style

Contemporary

Building Area Source

Public Records

Construction Materials

BrickFrameVinyl Siding

Direction Faces

South

Levels

Two

Livable Structure Count

Yes

Roof

Composition

Structure Type

House

Year Built

2023

Site & Exterior

Electric

110V220 Volts

Exterior Features

Private YardRain Gutters

Fencing

Partial

Garage Spaces

3

Lot Features

Borders Public LandLevelSprinklers In FrontSprinklers In Rear

Lot Size Acres

0.15

Lot Size Area

6677

Lot Size Square Feet

6677

Lot Size Units

Square Feet

Parking Features

ConcreteDry Walled

Parking Total

3

Patio And Porch Features

CoveredDeckPatio

Power Production Count

Yes

Road Frontage Type

Public

Road Responsibility

Public Maintained Road

Road Surface Type

Paved

Sewer

Public Sewer

Utilities

Electricity ConnectedNatural Gas Connected

View

Meadow

Water Included

Yes

Water Source

Public

Zoning

RES

Financials

Association Fee

65

Association Fee Annual

780.00

Association Fee Frequency

Monthly

Association Fee Includes

ReservesSnow RemovalTrash

Association Fee Total Annual

780.00

Contract Earnest Check To

Land Title

Contract Min Earnest

15000.00

Exclusions

All personal belongings

Home Warranty

No

Ownership

Individual

Parcel Number

R8874956

Special Listing Conditions

None

Tax Annual Amount

10125

Tax Legal Description

SUBD: PALISADE PARK FILING NO 6 LOT: 28 BLOCK: 10 S: 27 T: 1N R: 68W

Tax Year

2025

Title Company

Land Title

Neighborhood & Lifestyle

Community & Association

Association Amenities

Park

Association Management Type

Professionally Managed

Association Name

Advance HOA

Association Phone

303-482-2213

Pets Allowed

Cats OKDogs OK

Restrictions Covenants

Yes

Senior Community

No

Subdivision Name

Palisade Park Filing 6

Schools

Ratings

Elementary

St. Vrain Community Montessori

Middle

Erie

High

Erie

Elem. District

St. Vrain Valley RE-1J

Middle District

St. Vrain Valley RE-1J

High District

St. Vrain Valley RE-1J

Listing provided courtesy of RECOLORADO via IDX. Updated: Jun 18, 2026, 7:00pm.

583 Olive Street

583 Olive Street

Property Description

Property Details

Interior

Construction

Site & Exterior

Financials

Neighborhood & Lifestyle

Community & Association

Schools

Joe Gallo

$20

$200

Your Digital HQ

Growth Tools

$100 Voucher

583 Olive Street

583 Olive Street

Property Description

Property Details

Interior

Construction

Site & Exterior

Financials

Neighborhood & Lifestyle

Community & Association

Schools

Joe Gallo