BUILD TO ORDER - This charming French cottage-style single-story home is currently under construction and welcomes you with a cozy front porch and inviting curb appeal. Inside, 9-ft. ceilings and a spacious great room. The kitchen features a central island with sink overlooking the great room, making it the perfect gathering space, along with a walk-in pantry and Whirlpool® stainless steel appliance package. An additional storage closet offers the option to convert to a powder room for added flexibility. A dedicated laundry room enhances everyday convenience. The private primary suite includes a generously sized walk-in closet, linen closet, and dual-sink vanity. Designed with energy efficiency in mind, the home includes WaterSense® fixtures, Low-E windows, a smart thermostat, and a solar energy system available for purchase or lease for added comfort and sustainability. While construction is underway, personalize your home with a selection of cabinetry, countertops, flooring, bath options and more to match your style. Located in the new Orchards at Parkwood community, residents will enjoy planned parks, nearby local schools, convenient access to downtown amenities, and quick connections to Hwy. 99. Modesto is just 10 minutes away and Turlock approximately 13 minutes away, offering abundant shopping, dining, and entertainment options. Outdoor enthusiasts will appreciate nearby recreation at Ceres River Bluff Regional Park and Fox Grove Park, with Yosemite National Park also within reach for weekend adventures.
Pending
Price cut: $2K (10/10)
$487,990
6058 Flamekist Ln, Hughson, CA 95326
4beds
1,950sqft
Single Family Residence
Built in ----
5,745 Square Feet Lot
$486,700 Zestimate®
$250/sqft
$59/mo HOA
What's special
Cozy front porchPrivate primary suiteLow-e windowsGenerously sized walk-in closetLinen closetSmart thermostatInviting curb appeal
- 67 days
- 21
- 0
Zillow last checked:
Listing updated:
Listed by:
Lisa Celestino DRE #01516500 707-720-6165,
KB HOME Sales-Northern California Inc
Source: MetroList Services of CA,MLS#: 226115381Originating MLS: MetroList Services, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Dining room
- Features: Dining/Family Combo
Kitchen
- Features: Pantry Closet, Island w/Sink
Heating
- Central
Cooling
- Central Air
Appliances
- Laundry: Inside
Features
- Flooring: See Remarks
- Has fireplace: No
Interior area
- Total interior livable area: 1,950 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Lot
- Size: 5,745 Square Feet
- Features: Other
Details
- Parcel number: 018100020000
- Zoning: Residential
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stucco, Wood
- Foundation: Concrete, Slab
- Roof: Tile
Condition
- New construction: Yes
Utilities & green energy
- Electric: 220 Volts
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public
Community & HOA
HOA
- Has HOA: Yes
- Amenities included: None
- Services included: Other
- HOA fee: $59 monthly
Location
- Region: Hughson
Financial & listing details
- Price per square foot: $250/sqft
- Tax assessed value: $120,129
- Price range: $488K - $488K
- Date on market: 9/14/2026
Estimated market value
$486,700
$462,000 - $511,000
$2,716/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/16/2026 | Pending sale | $487,990$250/sqft |
Source: MetroList Services of CA #226115381 Report a problem | ||
| 10/10/2026 | Price change | $487,990-0.4%$250/sqft |
Source: MetroList Services of CA #226115381 Report a problem | ||
| 9/14/2026 | Listed for sale | $489,990$251/sqft |
Source: MetroList Services of CA #226115381 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $120,129 +35.1% |
| 2025 | $1,010 -16.8% | $88,950 -20.4% |
| 2024 | $1,214 | $111,795 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 95326
Local buyer's agents are ready to help




