Attractively priced Merced duplex with two occupied 2-bedroom, 2-bath units generating combined monthly rents of $3,050. A great opportunity for an investor seeking immediate rental income. Home and pest inspection reports are available in the disclosure package. The NHD report will be added when available.
For sale
$475,000
3074 W Queens Cir, Merced, CA 95340
4beds
4baths
2,272sqft
Duplex, Residential Income
Built in 1988
-- sqft lot
$-- Zestimate®
$209/sqft
$-- HOA
What's special
- 41 days
- 489
- 24
Zillow last checked:
Listing updated:
Listed by:
Zia Malik 00797668 408-661-9755,
Silicon Valley Realtors 408-661-9755
Source: MLSListings Inc,MLS#: ML82063633
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
Kitchen
- Features: Countertop_Formica, ExhaustFan, IslandwithSink
Heating
- Central Forced Air Gas
Cooling
- Central Air
Appliances
- Included: Electric Cooktop, Dishwasher, Exhaust Fan, Microwave, Electric Oven, Refrigerator, Washer/Dryer
Features
- Vaulted Ceiling(s)
- Flooring: Carpet, Vinyl Linoleum
- Doors: None
- Windows: Skylight(s)
Interior area
- Total structure area: 2,272
- Total interior livable area: 2,272 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Garage spaces: 2
- Has carport: Yes
Accessibility
- Accessibility features: None
Features
- Stories: 1
Lot
- Size: 6,279 Square Feet
Details
- Parcel number: 007081068000
- Zoning: R-2
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Ranch
- Property subtype: Duplex, Residential Income
Materials
- Foundation: Slab
- Roof: Composition
Condition
- Year built: 1988
Utilities & green energy
- Gas: IndividualGasMeters, NaturalGas, PublicUtilities
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available, Public Utilities, Water Public, Individual Electric Meters, Individual Gas Meters
Community & HOA
Location
- Region: Merced
Financial & listing details
- Price per square foot: $209/sqft
- Tax assessed value: $485,000
- Annual tax amount: $4,723
- Date on market: 10/5/2026
- Listing agreement: ExclusiveRightToSell
- Listing terms: CashorConventionalLoan
- Inclusions: Building, DishwasherAllUnits, Land, OvenRangeAllUnits
- Lease term: Month To Month
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 10/5/2026 | Listed for sale | $475,000+30.1%$209/sqft |
Source: | ||
| 9/1/2004 | Sold | $365,000+114.7%$161/sqft |
Source: Public Record Report a problem | ||
| 7/19/1999 | Sold | $170,000$75/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $485,000 +15.4% |
| 2025 | $4,723 +6.1% | $420,160 +2.4% |
| 2024 | $4,450 +1.9% | $410,150 +2.5% |
| 2023 | $4,368 +16.6% | $400,150 +17.6% |
| 2022 | $3,747 +9.3% | $340,140 +11.5% |
| 2021 | $3,428 -1.8% | $305,150 0% |
| 2020 | $3,489 +1.1% | $305,190 +1.6% |
| 2019 | $3,451 +52% | $300,240 +42.8% |
| 2018 | $2,271 -0.8% | $210,300 +5% |
| 2017 | $2,290 -0.4% | $200,350 0% |
| 2016 | $2,300 +8.1% | $200,430 +3.1% |
| 2015 | $2,128 | $194,490 +4.8% |
| 2014 | $2,128 +75.7% | $185,590 +75.7% |
| 2013 | $1,211 | $105,640 -0.1% |
| 2012 | -- | $105,720 -12.5% |
| 2011 | -- | $120,770 -19.9% |
| 2010 | -- | $150,850 -31.4% |
| 2009 | -- | $220,000 -43.2% |
| 2008 | -- | $387,340 +2% |
| 2007 | -- | $379,746 +2% |
| 2006 | -- | $372,301 +2% |
| 2005 | -- | $365,001 +103.1% |
| 2004 | -- | $179,671 +1.9% |
| 2003 | -- | $176,347 +2% |
| 2002 | -- | $172,898 +2.1% |
| 2001 | -- | $169,316 |
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: 95340
Nearby schools
Schools provided by the listing agent
- District: MercedCityElementary
Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




