Seller offering $10,000 in credits. This is an PUD VA, FHA and Conventional Financing available. Rarely available and meticulously reimagined, this single-story condo has been completely taken down to the studs and updated with every inch touched by custom, high-end finishes. The extensive mechanical and infrastructure overhaul includes new drywall, plumbing, triple-pane windows, a tankless gas water heater, and brand-new Minka ceiling fans installed in March 2026. Every detail has been curated for luxury and efficiency, from the custom imperfect smooth wall texture and Venetian plaster fireplace to the gourmet kitchen equipped with granite countertops and premium appliances like a Fisher & Paykel double-drawer dishwasher and Zephyr chimney hood. The primary suite serves as a true retreat with a deep Japanese soaking tub, travertine-tiled shower, and a custom California walk-in closets. Complete with private patios featuring high privacy fencing and a finished two-car garage with cabinetry, this residence offers a move in ready living experience that is seldom seen on the market. Amazing HOA covers pool, spa, tennis courts, pickleball courts, sewer, water, garbage, structure, roof, exterior lighting and landscape.
Active
$460,000
2860 Sherwood Ave APT B, Modesto, CA 95350
2beds
1,658sqft
Condominium
Built in 1980
-- sqft lot
$459,000 Zestimate®
$277/sqft
$599/mo HOA
What's special
Venetian plaster fireplaceNew drywallGourmet kitchenBrand-new minka ceiling fansTravertine-tiled showerPremium appliancesGranite countertops
- 211 days
- 426
- 17
Zillow last checked:
Listing updated:
Listed by:
Jamie MacDonald DRE #02070891 213-268-1749,
PMZ Real Estate,
Jeannie A. MacDonald DRE #01177273 209-342-2465,
PMZ Real Estate
Source: MetroList Services of CA,MLS#: 226019410Originating MLS: MetroList Services, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: Attic, Kitchen, Laundry, Living Room
Primary bedroom
- Features: Walk-In Closet, Outside Access
Primary bathroom
- Features: Shower Stall(s), Double Vanity, Dual Flush Toilet, Soaking Tub, Tile, Walk-In Closet(s), Quartz, Window
Dining room
- Features: Formal Area
Kitchen
- Features: Breakfast Area, Pantry Cabinet, Pantry Closet, Granite Counters, Stone Counters
Heating
- Central, Fireplace(s), Natural Gas
Cooling
- Ceiling Fan(s), Central Air, Attic Fan
Appliances
- Included: Free-Standing Gas Range, Free-Standing Refrigerator, Gas Cooktop, Gas Plumbed, Gas Water Heater, Range Hood, Ice Maker, Dishwasher, Double Oven, Plumbed For Ice Maker, Self Cleaning Oven, Electric Cooktop, Tankless Water Heater, Free-Standing Gas Oven, Washer/Dryer Stacked, Washer/Dryer Stacked Included
- Laundry: Laundry Room, Cabinets, Laundry Closet, Sink, Hookups Only, Inside, Inside Room
Features
- Flooring: Carpet, Tile
- Attic: Room
- Number of fireplaces: 1
- Fireplace features: Living Room, Double Sided, Gas
- Common walls with other units/homes: No One Below
Interior area
- Total interior livable area: 1,658 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, RV Access/Parking, RV Possible, RV Storage, Garage Door Opener, Garage Faces Rear, Guest
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Entry location: Ground Floor
- Has private pool: Yes
- Pool features: In Ground, Fenced, Gunite
- Fencing: Wood,Fenced
Lot
- Size: 1,446 Square Feet
- Features: Auto Sprinkler F&R
- Topography: Level,Trees Few,Level,Trees Few
Details
- Additional structures: Pergola
- Parcel number: 059039015000
- Zoning: R1
- Special conditions: Standard
- Other equipment: Audio/Video Prewired, Networked
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
- Attached to another structure: Yes
Materials
- Frame, Wood Siding
- Foundation: Concrete
- Roof: Composition
Condition
- Year built: 1980
Utilities & green energy
- Electric: 220 Volts in Laundry
- Sewer: See Remarks
- Water: Meter on Site
- Utilities for property: Cable Available, Electric, Internet Available, Natural Gas Available, Natural Gas Connected
Community & HOA
HOA
- Has HOA: Yes
- Amenities included: Pool, Clubhouse, Sauna, Spa/Hot Tub, Tennis Court(s)
- Services included: Common Areas, Pool, Roof, Sewer, Trash, Insurance on Structure, Water, Maintenance Grounds
- HOA fee: $599 monthly
Location
- Region: Modesto
Financial & listing details
- Price per square foot: $277/sqft
- Tax assessed value: $423,770
- Price range: $460K - $460K
- Date on market: 3/11/2026
- Road surface type: Asphalt, Paved
Estimated market value
$459,000
$436,000 - $482,000
$2,242/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/7/2026 | Price change | $460,000-4.2%$277/sqft |
Source: MetroList Services of CA #226019410 Report a problem | ||
| 6/11/2026 | Price change | $479,999-4%$290/sqft |
Source: MetroList Services of CA #226019410 Report a problem | ||
| 3/11/2026 | Listed for sale | $499,999+11.1%$302/sqft |
Source: MetroList Services of CA #226019410 Report a problem | ||
| 4/1/2022 | Sold | $450,000+28.6%$271/sqft |
Source: Public Record Report a problem | ||
| 6/30/2015 | Sold | $350,000+85.2%$211/sqft |
Source: Public Record Report a problem | ||
| 5/3/2013 | Sold | $189,000+14.5%$114/sqft |
Source: MetroList Services of CA #13018740 Report a problem | ||
| 12/17/2012 | Sold | $165,000-8.3%$100/sqft |
Source: MetroList Services of CA #12054488 Report a problem | ||
| 12/13/2012 | Pending sale | $179,950$109/sqft |
Source: CENTURY 21 M&M And Associates #12054488 Report a problem | ||
| 9/6/2012 | Listed for sale | $179,950-16.3%$109/sqft |
Source: Century 21 M&M #12054488 Report a problem | ||
| 6/30/2009 | Sold | $215,000-34.8%$130/sqft |
Source: MetroList Services of CA #90031990 Report a problem | ||
| 2/22/2008 | Listing removed | $329,900$199/sqft |
Source: NCI Report a problem | ||
| 2/1/2008 | Listed for sale | $329,900+3.1%$199/sqft |
Source: NCI Report a problem | ||
| 11/16/2007 | Sold | $320,000+93.9%$193/sqft |
Source: MetroList Services of CA #70080853 Report a problem | ||
| 9/1/1998 | Sold | $165,000$100/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $423,770 +2% |
| 2025 | $4,514 +1.9% | $415,462 +2% |
| 2024 | $4,431 +2% | $407,316 +2% |
| 2023 | $4,345 +9.3% | $399,330 +6.9% |
| 2022 | $3,975 +1.8% | $373,727 +2% |
| 2021 | $3,904 +1.5% | $366,400 +1% |
| 2020 | $3,847 +1.9% | $362,644 +2% |
| 2019 | $3,775 +2% | $355,535 +2% |
| 2018 | $3,699 +2.5% | $348,565 +2% |
| 2017 | $3,610 +0.6% | $341,732 +2% |
| 2016 | $3,587 +75.7% | $335,032 +73% |
| 2015 | $2,042 -0.3% | $193,650 +2% |
| 2014 | $2,049 | $189,857 +21.7% |
| 2012 | -- | $156,000 |
| 2011 | -- | $156,000 -14.5% |
| 2010 | -- | $182,500 +5.8% |
| 2009 | -- | $172,500 -32.6% |
| 2008 | -- | $256,000 +34.2% |
| 2007 | -- | $190,727 +2% |
| 2006 | -- | $186,988 +2% |
| 2005 | -- | $183,322 +2% |
| 2004 | $1,828 +0.8% | $179,728 +1.9% |
| 2003 | $1,813 | $176,435 |
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: 95350
Similar homes
- $470,0003 bd2 ba1.3k sqft1032 Hawthorne Ave, Modesto, CA 95350For Sale
MLS ID #226090188, Lorraine Cardoza. MetroList Services of CA - $474,9993 bd2 ba1.5k sqft1016 Wolverine Way, Modesto, CA 95355For Sale
MLS ID #226116359, Carlos Gutierrez. MetroList Services of CA - $449,9003 bd2 ba1.5k sqft601 Waddell Way, Modesto, CA 95357For Sale
MLS ID #226123243, Pete Diryawush. MetroList Services of CA - $489,0003 bd2 ba1.6k sqft3845 Carver Rd, Modesto, CA 95356For Sale
MLS ID #226111383, Leslie Nelson. MetroList Services of CA
