For Sale

Listed by Gustavo Lopez Silva from Envision Realty, Inc.

Source: Fresno Association of Realtors #643196

3474 E Terrace Ave, Mayfair, CA, 93703

$439,900

4
2
1704 sq. ft.
6600 sq. ft.

Duplex

30+ days on the market

What's around 3474 E Terrace Ave

About this property

Beautifully Renovated Multi-Family Duplex with ADU Potential!

Don't miss this exceptional opportunity to own a fully remodeled duplex, ideally situated in a desirable neighborhood. This turnkey property offers modern upgrades and thoughtful enhancements throughout both units, making it perfect for investors or multi-generational living.

Each unit features updated kitchens with contemporary finishes, stylish new flooring, and beautifully remodeled bathrooms. Dual-pane windows have been installed throughout the entire property, providing energy efficiency and enhanced comfort. One of the units also boasts a brand-new HVAC system for year-round climate control.

The exterior has been equally well-maintained, with a newly updated fence, and brick wall on the back adding privacy and curb appeal. A standout feature of this property is the generous backyard space behind each unit, offering excellent potential for building an ADU ideal for added rental income or extended family living.

Whether you're expanding your investment portfolio or seeking a live-in-one, rent-the-other scenario, this duplex delivers value, flexibility, and future potential.

Looking for more information on 3474 E Terrace Ave?

Explore comparables, sales history and growth for this property.
Learn more

Similar properties for sale nearby

Pending
$495,000
2026 E Hunter Ave
Fresno CA 93703
4
Duplex
Listing courtesy of Liberty Realty Masters
Pending
$499,990
3236 East Clinton Avenue
Mayfair CA 93703
4
Duplex
Listing courtesy of Real Broker
For Sale
$315,000
3434 Mayfair Drive North
Mayfair CA 93703
4
Duplex
Listing courtesy of Century 21 Dan Cheney

Other properties for sale by Envision Realty, Inc.

For Sale
$1,068,913
2721 Aida Avenue
San Jose CA 95122
5
Single-Family
Listing courtesy of Envision Realty, Inc.
Pending
$429,900
1302 N Safford Ave
Fresno CA 93728
4
Single-Family
Listing courtesy of Envision Realty, Inc.
Pending
$459,000
474 E Escalon Ave
Fresno CA 93710
3
Single-Family
Listing courtesy of Envision Realty, Inc.

Browse properties sold in nearby areas

Based on information from the Humboldt Association of REALTORS®. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be verified by broker for accuracy. Properties may or may not be listed by the office/agent presenting the information. Copyright © 2026 Humboldt Association of REALTORS®. All Rights Reserved.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under MLS GRID IDX Rules Updated September 16, 2024 7 U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: dmca@ratemyagent.com

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Email
© 2026 RateMyAgent