Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (1)
    Mexico Listings (41)
    Advanced Search
Sell Find an Agent
GolfHomes.com GolfHomes.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing GolfHomes.com logo
Share
GolfHomes.com logo
Ad #7559173
MLS #652224
Listing photo

Located in the highly sought-after San Joaquin Estates, this

3146 W Alluvial Ave, Fresno, California, 93711
$850,000
4Beds
3Baths
3,204Sqft
0.328Acres

About this property

Located in the highly sought-after San Joaquin Estates, this exceptional 4-bedroom, 3-bath residence blends timeless architecture with thoughtful updates, including a new roof, elegant brick exterior, and an inviting courtyard entrance. Inside, soaring vaulted ceilings with Cathedral beams, two spacious living and entertaining areas, a wet bar, and custom built-in cabinetry create an inviting atmosphere for both everyday living and memorable gatherings. One living area opens seamlessly to the expansive covered patio, creating a true indoor-outdoor lifestyle. The kitchen showcases a custom brick stove alcove, dual ovens, gas cooktop, generous workspace, and distinctive Old World character. The private primary suite offers a romantic fireplace, custom built-ins, private patio access, and a cedar-lined walk-in closet. Spacious secondary bedrooms feature built-in cabinetry, with one ideally suited as a home office or library. The oversized three-car garage is complemented by extensive storage above, providing exceptional space for seasonal items and hobbies. Outdoors, enjoy a large, deep pool, expansive wraparound deck, mature landscaping, and established fruit trees that create a private backyard retreat. Ideally located near San Joaquin Country Club, Sierra Sport & Racquet, premier shopping, dining, and top Fresno amenities, this is an exceptional opportunity to own one of Northwest Fresno's signature homes.

Property Features

4 Beds
3 Baths
3,204 Sqft
Built in 1978
0.328 Acres
San Joaquin Country Club
On Golf Course
Composition Roof
Has Swimming Pool
Has Fireplace
Fresno County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Eric Mccormick

London Properties

559-436-4000

Location

Map
Listing Agent: Eric Mccormick 559-436-4000
Broker: London Properties 559-436-4000 Listing Site
Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
GolfHomes.com
Printed Jul 20, 2026

Photo Gallery

Located in the highly sought-after San Joaquin Estates, this - photo 1
Located in the highly sought-after San Joaquin Estates, this - photo 2
Located in the highly sought-after San Joaquin Estates, this - photo 3
Located in the highly sought-after San Joaquin Estates, this - photo 4
Located in the highly sought-after San Joaquin Estates, this - photo 5
Located in the highly sought-after San Joaquin Estates, this - photo 6
Located in the highly sought-after San Joaquin Estates, this - photo 7
Located in the highly sought-after San Joaquin Estates, this - photo 8
Located in the highly sought-after San Joaquin Estates, this - photo 9
Located in the highly sought-after San Joaquin Estates, this - photo 10
Located in the highly sought-after San Joaquin Estates, this - photo 11
Located in the highly sought-after San Joaquin Estates, this - photo 12
Located in the highly sought-after San Joaquin Estates, this - photo 13
Located in the highly sought-after San Joaquin Estates, this - photo 14
Located in the highly sought-after San Joaquin Estates, this - photo 15
Located in the highly sought-after San Joaquin Estates, this - photo 16
Located in the highly sought-after San Joaquin Estates, this - photo 17
Located in the highly sought-after San Joaquin Estates, this - photo 18
Located in the highly sought-after San Joaquin Estates, this - photo 19
Located in the highly sought-after San Joaquin Estates, this - photo 20
Located in the highly sought-after San Joaquin Estates, this - photo 21
Located in the highly sought-after San Joaquin Estates, this - photo 22
Located in the highly sought-after San Joaquin Estates, this - photo 23
Located in the highly sought-after San Joaquin Estates, this - photo 24
Located in the highly sought-after San Joaquin Estates, this - photo 25
Located in the highly sought-after San Joaquin Estates, this - photo 26
Located in the highly sought-after San Joaquin Estates, this - photo 27
Located in the highly sought-after San Joaquin Estates, this - photo 28
Located in the highly sought-after San Joaquin Estates, this - photo 29
Located in the highly sought-after San Joaquin Estates, this - photo 30
Located in the highly sought-after San Joaquin Estates, this - photo 31
Located in the highly sought-after San Joaquin Estates, this - photo 32
Located in the highly sought-after San Joaquin Estates, this - photo 33
Located in the highly sought-after San Joaquin Estates, this - photo 34
Located in the highly sought-after San Joaquin Estates, this - photo 35
Located in the highly sought-after San Joaquin Estates, this - photo 36
Located in the highly sought-after San Joaquin Estates, this - photo 37
Located in the highly sought-after San Joaquin Estates, this - photo 38
Located in the highly sought-after San Joaquin Estates, this - photo 39
Located in the highly sought-after San Joaquin Estates, this - photo 40
Located in the highly sought-after San Joaquin Estates, this - photo 41
Located in the highly sought-after San Joaquin Estates, this - photo 42
Located in the highly sought-after San Joaquin Estates, this - photo 43

$850,000

4
Beds
3
Baths
3,204
Sqft

3146 W Alluvial Ave, Fresno, California, 93711

By contacting this agent you agree to these Terms and Conditions.
Home California Fresno Fresno San Joaquin Country Club
Located in the highly sought-after San Joaquin Estates, this - photo 1
Located in the highly sought-after San Joaquin Estates, this - photo 2
Located in the highly sought-after San Joaquin Estates, this - photo 3
Located in the highly sought-after San Joaquin Estates, this - photo 4
Located in the highly sought-after San Joaquin Estates, this - photo 5
MLS# 652224
Home For Sale

Located in the highly sought-after San Joaquin Estates, this

$850,000

3146 W Alluvial Ave, Fresno, California, 93711

4
Beds
3
Baths
3,204
Sqft
0.328
Acres
$850,000
3146 W Alluvial Ave, Fresno, California, 93711
4 Beds
3 Baths
3,204 Sqft
0.328 Acres
Located in the highly sought-after San Joaquin Estates, this exceptional 4-bedroom, 3-bath residence blends timeless architecture with thoughtful updates, including a new roof, elegant brick exterior, and an inviting courtyard entrance. Inside, soaring vaulted ceilings with Cathedral beams, two spacious living and entertaining areas, a wet bar, and custom built-in cabinetry create an inviting atmosphere for both everyday living and memorable gatherings. One living area opens seamlessly to the expansive covered patio, creating a true indoor-outdoor lifestyle. The kitchen showcases a custom brick stove alcove, dual ovens, gas cooktop, generous workspace, and distinctive Old World character. The private primary suite offers a romantic fireplace, custom built-ins, private patio access, and a cedar-lined walk-in closet. Spacious secondary bedrooms feature built-in cabinetry, with one ideally suited as a home office or library. The oversized three-car garage is complemented by extensive storage above, providing exceptional space for seasonal items and hobbies. Outdoors, enjoy a large, deep pool, expansive wraparound deck, mature landscaping, and established fruit trees that create a private backyard retreat. Ideally located near San Joaquin Country Club, Sierra Sport & Racquet, premier shopping, dining, and top Fresno amenities, this is an exceptional opportunity to own one of Northwest Fresno's signature homes.
3 days
on GolfHomes.com
10
views
0
saves

Property Details

HOME DETAILS

4 Beds
3 Baths
3,204 Sqft
Built in 1978
0.328 Acres

GOLF COURSE & VIEW

San Joaquin Country Club
On Golf Course

EXTERIOR

Composition Roof
Has Swimming Pool

INTERIOR

Has Fireplace

FINANCIAL & COMMUNITY

Fresno County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7559173
Viewed
10 times
Listing Status
Active
Added
Jul 17, 2026
Last Refresh
Jul 20, 2026 04:44:54 PM

Listing Information

Data Source
Fresno Association of Realtors
Source Property ID
652224
Listing Agent: Eric Mccormick 559-436-4000
Broker: London Properties 559-436-4000 Listing Site
Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on GolfHomes.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 GolfHomes.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.21
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

San Joaquin Country Club

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

San Joaquin Country Club Real Estate Agent Info

About San Joaquin Country Club

Click to activate
Request Information
By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 GolfHomes.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.21
Terms & Policy