The Charleston is a spacious floor plan offering incredible features throughout. The covered front porch welcomes guests as they enter the large formal entryway. A lovely study awaits, along with the convenience of a powder room. The massive kitchen with large center island overlooks the sunny 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 roomy 3-car tandem garage offers plenty of space for storage. Upstairs, you'll retreat to the expansive loft, which can be used as another living room, a game room, or anything else, while both of the secondary bedrooms feature walk-in closets. The master suite boasts a large walk-in closet, soaking tub, walk-in shower, and dual vanity. ***This is currently being used as our model home. Must qualify to purchase as an investment property as we will need up to a 6 month lease back.***
Single-familyProperty Type
2022Year Built
9,928 sq ftLot Size
$209Est. Price/Sq.Ft.
4 car garageParking
Listed by Kristen Gaccetta• New Home Star, LLC
Contact: kjanney@challengerhomes.com,970-618-4940
Bought with Alex White• BLVD Real Estate Group, LLC
The Charleston is a spacious floor plan offering incredible features throughout. The covered front porch welcomes guests as they enter the large formal entryway. A lovely study awaits, along with the convenience of a powder room. The massive kitchen with large center island overlooks the sunny 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 roomy 3-car tandem garage offers plenty of space for storage. Upstairs, you'll retreat to the expansive loft, which can be used as another living room, a game room, or anything else, while both of the secondary bedrooms feature walk-in closets. The master suite boasts a large walk-in closet, soaking tub, walk-in shower, and dual vanity. ***This is currently being used as our model home. Must qualify to purchase as an investment property as we will need up to a 6 month lease back.***
IRES as Distributed by MLS Grid #979590
Apr 5, 2023
Listing Removed
—
Dec 5, 2022
Listed
$691,650
$249/sq ft
Public Records
Jun 7, 2022
Sold
$1,512,340
$544/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$3,493
$5,940 + $28,950
$34,890
2024
$3,492 (+12.9%)
$5,940 + $28,950
$34,890
2023
$3,093
$6,700 + $32,710
$39,410
Tax history for 511 Raffi Ave
Year
Property tax
Land + Additions
Assessment*
2025
$3,493
$5,940 + $28,950
$34,890
2024
$3,492 (+12.9%)
$5,940 + $28,950
$34,890
2023
$3,093
$6,700 + $32,710
$39,410
*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
9,928 Sq. Ft.
Year renovated
—
Sq. Ft.
2,780
Year built
2022
Style
Single Family Residential
County
Weld County
APN
R8978191
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: 4
Garage Spaces: 4
AttachedGarageYN: Yes
Parking Features: Tandem
Interior
Bedroom Information
Bedrooms Total: 3
Upper Level Bedrooms: 3
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
Description: Fireplace
Length: 18
Width: 15
Level: Main
Room 2 Information
Dining Room
Description: Bay Window
Length: 14
Width: 10
Level: Main
Room 3 Information
Kitchen
Description: Gourmet Kitchen, double oven, large island, quartz countert