active

474 E Alluvial 174, Fresno, CA 93720

$300,000

$296 per ft²

2 Bed

2 Bath

1,015 Sq Ft

0.093 Acres

Listing Office: DIAMOND REALTORS

Image 1 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 2 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 3 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 4 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 5 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 6 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 7 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 8 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 9 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 10 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 11 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 12 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 13 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 14 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 15 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 16 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 17 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 18 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 19 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 20 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 21 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 22 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 23 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 24 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 25 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 26 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 27 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 28 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 29 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 30 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 31 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 32 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 33 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 34 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 35 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Image 36 of property listing at 474 E Alluvial 174, Fresno, CA 93720

Move-in ready 2 bedroom, 2 bathroom PUD located in a fully gated North Fresno community! This well-maintained home features newer carpet, an inviting floor plan, and a bright kitchen with tile countertops, white appliances, a brand-new dishwasher, and a charming bay window above the sink. The home includes an indoor laundry room with washer and dryer included and an attached 1-car garage for added convenience. Enjoy low-maintenance living with a covered backyard patio, perfect for relaxing with minimal upkeep. The Horizons community offers desirable amenities including a community pool, relaxing pond with fountain views, clubhouse/community room, and beautifully maintained grounds. Ideally located near River Park Shopping Center, Woodward Park, Kaiser Permanente Medical Center, restaurants, shopping, and quick access to Hwy 41, all within the Clovis Unified School District. Perfect for buyers seeking gated community living, low-maintenance lifestyle, and a prime North Fresno location.

Listing Agent: Crystal Ansay

License Number: 01850335

Offered by: DIAMOND REALTORS

Office Phone: 559-298-2033

MLS: #FR26049036

California Regional MLS

Date Added: 03/05/2026 12:00:00 am

Last Update: 03/06/2026 02:33:36 pm

Days on Market: 3

Interior

General: Bedroom on Main Level,Main Level Primary
Appliances: Dishwasher,Free-Standing Range
Laundry: Inside,Laundry Room
A/C: true, Central Air
Heating: true, Central
Fireplace: Living Room, Fireplace

Exterior

Pool: Community,Association
Parking: Parking spaces: 1

Construction

Roofing: Tile
General: 1

Location

HOA Amenities: Clubhouse,Picnic Area,Pool, 380.0, Monthly
Originating MLS: CRMLS_CRM
School District: Clovis Unified
County: Fresno

Lot

Zoning: 30341043
View: Neighborhood, View

Utilities

Water: Public
Sewer: Public Sewer

Financial

Source: CRMLS_CRM

Property

Year Built: 1984
Type: Condo
Parcel #: 30341043

Schools

District: Clovis Unified

03/06/2026Active

03/06/2026$300,000@ 296 per ft²Listed

Listing Broker

Tade Keshishyan

1 @

License #: 02190628

Email: [email protected]

Phone: 8183592303

Location: CA

Last Updated: 03/06/2026 02:33:36 pm

Offered by: Crystal Ansay, 01850335, 559-298-2033 @ DIAMOND REALTORS

MLS: #FR26049036

Source: California Regional MLS

<IMG SRC='https://d37ukvrrv3in12.cloudfront.net/mls/logos/IDX_580_large.png' ALT='IDX'> Based on information from California Regional Multiple Listing Service, Inc. and /or other sources. 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 or MLS. All information should be independently reviewed and verified for accuracy. The data contained herein is copyrighted by CRMLS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.<BR><BR>The information being provided by California Regional Multiple Listing Service, Inc. (“CRMLS”) is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Any information relating to a property referenced on this web site comes from CRMLS. Properties may or may not be listed by the office/agent presenting the information. Real estate listings held by brokerage firms other than this broker are marked with the Internet Data Exchange logo and detailed information about them includes the names of the listing brokers and listing agents. MLS search engine provided by <A HREF='http://www.realtywatchsolutions.com/' TARGET='_blank'>RealtyWatch Solutions</A>. This data is updated every 2 hours. Some properties appearing for sale on this display may subsequently have sold and may no longer be available. Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

View Listing

474 E Alluvial 174, Fresno, CA 93720 is a 2 Bed, 2 Bath, 1,015 Sq Ft, 0.093 Acres, Condo built in 1984.

This property is currently available and was listed by California Regional MLS on 03/05/2026 12:00:00 am. The MLS # for the property is MLS #FR26049036.