---
listing_id: CRFR26049036
status: Pending
price: 285000
beds: 2
baths_full: 2
baths_half: 0
sqft_living: 1015
sqft_lot: 4050
lot_acres: 
year_built: 1984
property_type: Residential
property_subtype: Condominium
address: "474 E Alluvial 174"
city: Fresno
state: CA
zip: 93720
county: "Fresno County"
lat: 36.8454996
lng: -119.7769842
days_on_market: 49
hoa_fee: 380
hoa_frequency: Monthly
garage_spaces: 1
list_agent: "Crystal Ansay"
list_office: "DIAMOND REALTORS"
list_agent_phone: "–"
list_agent_license: 01850335
mls_source: CRMLS
modified: 2026-03-29
transaction_type: buy
---

Home | Fresno County | Fresno | 93720 | 474 E Alluvial 174

474 E Alluvial #174, Fresno, CA 93720

MLS: CRFR26049036 | Status: PendingDoNotShow | Price: $285,000
Beds/Baths: 2 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
2 2 1,015 4,050 1984

Remarks

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.

MLS Listing Information

Field Value
MLS # CRFR26049036
MLS Source California Regional MLS

Features

Interior Features

Feature Details
Bedrooms Ground Floor Bedroom, Primary Suite/Retreat
Appliances Dishwasher, Other, Oven Range
Fireplace Living Room
Laundry In Laundry Room, Other
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Tile
Pool Community Facility

Parking, School, and Other Information

Feature Details
Garage/Parking Garage: 1 Car(s)
Elementary District Clovis Unified
High School District Clovis Unified
HOA Fee $380
HOA Fee Frequency Monthly
Complex Amenities Club House, Community Pool, Picnic Area

Contact Information

Crystal Ansay
DIAMOND REALTORS
License #: 01850335
Phone: –

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Lincoln Elementary School public K-6 0.26 mi 8
Kastner Intermediate School public 7-8 0.32 mi 8
Pinedale Elementary School public K-6 0.92 mi 4
McCardle Elementary School public K-6 1.10 mi 6
Fort Washington Elementary School public K-6 1.15 mi 7
Clovis West High School public 9-12 1.26 mi 9
Eaton Elementary School public K-6 1.38 mi 6
Ahwahnee Middle School public 7-8 1.40 mi 2
Mountain View Elementary School public K-6 1.64 mi 6
Kratt Elementary School public K-6 1.85 mi 6
Robinson Elementary School public K-6 1.86 mi 5
Maple Creek Elementary School public K-6 1.91 mi 9
Herbert Hoover High School public 9-12 1.97 mi 4
Valley Oak Elementary School public K-6 2.18 mi 8
Nelson Elementary School public K-6 2.21 mi 7
Liberty Elementary School public K-6 2.23 mi 10
Baird Middle School public 5-8 2.27 mi 9
Wolters Elementary School public K-6 2.40 mi 6
Tenaya Middle School public 7-8 2.51 mi 3
Fresno Rop School public 9-12 2.52 mi N/A

Nearby Homes

Address Price Beds Baths Sq Ft Status
198 W Barstow $232,500 2 2 1,028 Active
7675 N 1st St 136 $265,900 2 2 1,146 Active
7675 N 1st 136 $269,900 2 2 1,146 Active

Disclosures

©2026 California Regional MLS. All rights reserved. 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. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from California Regional MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of March 29, 2026. For the most current information, please contact Crystal Ansay.