The Charleston is a spacious floor plan offering incredible features throughout. The covered porch welcomes guests as they enter the large, formal entryway. A study awaits, along with the convenience of a powder bathroom. The massive kitchen with large center island including quartz countertops, a tile backsplash and gourmet kitchen with a double oven and gas range, overlooks the breakfast nook and great room. Entertaining in this home is a breeze, indoors or out, thanks to a covered patio adjacent to the breakfast nook. The family room features an impressive stone, floor to ceiling fireplace for those cold, winter nights. The roomy, 3 car tandem garage offers plenty of space for storage. Upstairs, 4 bedrooms plus a loft. The enormous master suite boasts a large walk in closet, luxury master bath with quartz countertops and undercount sinks, a shower seat and dual vanity. This home backs directly to Coyote Creek Golf Course with amazing views and privacy. Be one of the first to purchase a home in this beautiful, brand new community.
The Charleston is a spacious floor plan offering incredible features throughout. The covered porch welcomes guests as they enter the large, formal entryway. A study awaits, along with the convenience of a powder bathroom. The massive kitchen with large center island including quartz countertops, a tile backsplash and gourmet kitchen with a double oven and gas range, overlooks the breakfast nook and great room. Entertaining in this home is a breeze, indoors or out, thanks to a covered patio adjacent to the breakfast nook. The family room features an impressive stone, floor to ceiling fireplace for those cold, winter nights. The roomy, 3 car tandem garage offers plenty of space for storage. Upstairs, 4 bedrooms plus a loft. The enormous master suite boasts a large walk in closet, luxury master bath with quartz countertops and undercount sinks, a shower seat and dual vanity. This home backs directly to Coyote Creek Golf Course with amazing views and privacy. Be one of the first to purchase a home in this beautiful, brand new community.
REColorado as Distributed by MLS Grid #3515126
Jul 21, 2023
Price Changed
$574,900
$207/sq ft
Jul 21, 2023
Listing Removed
—
Jul 21, 2023
Price Changed
$583,392
$210/sq ft
Jul 14, 2023
Price Changed
$607,700
$218/sq ft
May 23, 2023
Listed
$589,469
$212/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$3,530 (+1.9%)
$5,940 + $29,320
$35,260
2024
$3,464 (+473.9%)
$5,940 + $29,320
$35,260
2023
$604
$6,700 + $32,420
$39,120
Tax history for 611 Raffi Ave
Year
Property tax
Land + Additions
Assessment*
2025
$3,530 (+1.9%)
$5,940 + $29,320
$35,260
2024
$3,464 (+473.9%)
$5,940 + $29,320
$35,260
2023
$604
$6,700 + $32,420
$39,120
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
3
Stories
2
Lot width
—
Lot depth
—
Lot size
5,250 Sq. Ft.
Year renovated
—
Sq. Ft.
2,762
Year built
2023
Style
Single Family Residential
County
Weld County
APN
R8978195
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 31, 2026.
PUD
Planned Unit Development District
The planned development process is intended for development concepts that require a higher degree of specific planning based on the scale and complexity of the project. It is a type of change of zone, but is based on a specific and integrated development plan The process affords flexibility in the standards to improve the relationship of the project to the context, and to better meet the purpose, intent and objectives of this code. Application for a planned development may be filed by the property owner, the City Council, or the Planning Commission, or by staff on behalf of these city entities.; A development plan shall include sufficient area to implement planning concepts that generate broader public benefits only be gained from flexible application of the standards, and not simply be used to justify deviations for single projects or on a site-specific basis. Smaller additions to previously approved development plans may be considered an amendment to that plan if used to integrate projects into the previous plan.
Property details
Parking
Parking/Garage Information
Parking Total: 3
Garage Spaces: 3
AttachedGarageYN: Yes
Interior
Bedroom Information
Bedrooms Total: 4
Upper Level Bedrooms: 4
Bathroom Information
Bathrooms Total Integer: 3
Bathrooms Full: 2
Bathrooms Half: 1
Upper Level Bathrooms: 2
Main Level Bathrooms: 1
Room 1 Information
Family Room
Length: 18
Width: 15
Level: Main
Room 2 Information
Dining Room
Description: Bay Window
Length: 14
Width: 10
Level: Main
Room 3 Information
Office
Description: French Doors
Length: 10
Width: 14
Level: Main
Room 4 Information
Kitchen
Description: Stainless, gas
Length: 14
Width: 12
Level: Main
Room 5 Information
Bathroom (1/2)
Description: Powder room
Level: Main
Room 6 Information
Primary Bedroom
Description: Ensuite bath, sitting area
Length: 17
Width: 19
Level: Upper
Room 7 Information
Bedroom
Length: 10
Width: 16
Level: Upper
Room 8 Information
Bonus Room
Description: Flex space, loft area
Length: 14
Width: 14
Level: Upper
Room 9 Information
Laundry
Length: 9
Width: 6
Level: Upper
Room 10 Information
Bedroom
Description: Walk in closet
Length: 13
Width: 13
Level: Upper
Room 11 Information
Bedroom
Description: Walk in closet
Length: 13
Width: 13
Level: Upper
Room 12 Information
Bathroom (Full)
Level: Upper
Room 13 Information
Primary Bathroom (Full)
Description: Walk in closet, shower seat, soaking tub, double vanity