Phone858-220-9001
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
  • Home
  • 3074 W Queens Circle

3074 W Queens Circle, Merced, CA 95340

$475,000 Approx. USD 0 beds, 0 baths
2,272 sqft

New Listing
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure

Photo of Patrick Ahern

Patrick Ahern REALTOR® - Sales Associate 858-220-9001 m
858-459-0501 o
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com Text Me
Call My Cell
Call My Office
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com La Jolla Prospect Office
1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
Phone: 858-459-0501
Fax: 858-459-3275
 La Jolla Prospect 1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
Call Branch Office
Fax: 858-459-3275
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Patrick.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Zia Malik | ziamalik51@gmail.com
Lic#: 00797668
Broker: Courtesy of Silicon Valley Realtors
Phone: 408-661-9755

Agent Remarks

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.

Listing Details

Property type: Duplex (Multi-Family)
Status: Active
MLS# ML82063633
Price: $475,000
Beds: 0
Baths: 0
Built in 1988
2,272 sqft
1 story
0.14 acres
Lot size: 0.1441
County: Merced
Property style: Ranch
Zoning: R-2
Appliances: Dishwasher,Electric Cooktop,Electric Oven,Microwave,Refrigerator,Vented Exhaust Fan
Heating/cooling: Central Air
MLS area: 699 - Not Defined

Last Updated: 10/8/2026

 Days On Market (DOM): 5

 Find more Merced homes and real estate

 Find more homes in 95340 zip code

This listing belongs to the 699 - Not Defined MLS area

The style of this listing is Ranch.
Find more Ranch style homes for sale

Lat/Long: 37.317728, -120.455037.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

95340 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
2520 Mckee Road VIRTUAL TOUR
2520 Mckee Road ,
$410,000 Approx. USD

List Date: 1/15/2025
 Status: Active
 MLS #: MC25010088

My Notes Save
Listing courtesy of
2205 O VIRTUAL TOUR
2205 O ,
$475,000 Approx. USD

List Date: 9/16/2026
 Status: Pending
 MLS #: MC26196327

My Notes Save
Listing courtesy of
3224 Nashville Court VIRTUAL TOUR
3224 Nashville Court ,
$485,000 Approx. USD

List Date: 7/23/2026
 Status: Active
 MLS #: MC26159955

My Notes Save
Listing courtesy of
1122 N Street VIRTUAL TOUR
1122 N Street ,
$495,000 Approx. USD 5 beds, 2 baths

List Date: 10/7/2024
 Status: Active
 MLS #: MC24208217

My Notes Save
Listing courtesy of
1360 Willow VIRTUAL TOUR
1360 Willow ,
$415,000 Approx. USD

List Date: 9/30/2026
 Status: Active
 MLS #: MC26213232

My Notes Save
Listing courtesy of
211 Kingston Lane VIRTUAL TOUR
211 Kingston Lane ,
$480,000 Approx. USD

List Date: 9/28/2026
 Status: Active
 MLS #: 41149653

My Notes Save
Listing courtesy of
2404 2406 Counts Ct VIRTUAL TOUR
2404 2406 Counts Ct ,
$519,000 Approx. USD

List Date: 6/24/2026
 Status: Pending
 MLS #: 41139524

My Notes Save
Listing courtesy of
15895 Morris Rd VIRTUAL TOUR
15895 Morris Rd ,
$499,000 Approx. USD

List Date: 6/10/2026
 Status: Active
 MLS #: 41137826

My Notes Save
Listing courtesy of
105 Upper Sunset VIRTUAL TOUR
105 Upper Sunset ,
$525,000 Approx. USD

List Date: 8/19/2026
 Status: Active
 MLS #: 41145508

My Notes Save
Listing courtesy of
172 N Shepherd St VIRTUAL TOUR
172 N Shepherd St ,
$452,000 Approx. USD

List Date: 7/9/2026
 Status: Active
 MLS #: 41140988

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only

Photo of Patrick Ahern

Patrick Ahern REALTOR® - Sales Associate 858-220-9001 m
858-459-0501 o
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com Text Me
Call My Cell
Call My Office
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com
La Jolla Prospect Office
1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
hsoa-logo

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status