London Properties Clovis Real Estate

997 Pistachio Ave

Clovis, CA 93611

Copy Link Get Directions

Photo Gallery

$579,850

4 bd

2 ba

2,227 sq ft

0.20 acre

997 Pistachio Ave

Clovis, CA 93611

Get Directions

Virtual Tour

Listed On: 05/22/2026

Status: Active

Listing Number: 649206 (Fresno MLS)

Open House

Sun, May 24
1:00pm - 4:00pm
Courtesy of Real Broker

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.322.4000 Email Agent

Property Description

Welcome to 997 Pistachio Ave in the heart of Clovis a beautifully updated home offering comfort, flexibility, and one of the most desirable lifestyles in the Central Valley. Ideally situated directly across from a serene neighborhood park, this spacious residence features 4 bedrooms PLUS a versatile BONUS room perfect for a home office, playroom, gym, media room, or potential 5th bedroom.Step inside to discover NEW waterproof luxury vinyl flooring throughout, creating a clean, modern feel with durability designed for everyday living. The newly remodeled owner's suite offers a private retreat with a beautifully updated spa-inspired bathroom designed for relaxation and functionality. The modernized kitchen showcases elegant granite countertops, updated finishes, and an inviting layout ideal for entertaining family and friends.Enjoy California living at its finest with a sparkling pool perfect for warm Central Valley summers, while OWNED SOLAR helps provide long-term energy efficiency and lower utility costs. The spacious 3-CAR garage offers ample storage and parking, with additional RV PARKING potential for recreational vehicles, trailers, or extra toys.For added buyer confidence and peace of mind, the sellers have proactively completed preexisting inspections including termite, home, and sewer lateral inspections.Located within close proximity to award-winning Clovis Unified School District schools including Clovis High School and nearby elementary schools, this home is also conveniently positioned near Old Town Clovis, shopping, dining, local coffee shops, and everyday amenities. Commuters and professionals will appreciate the easy access to major corridors, while students and faculty will value being just minutes from California State University, Fresno.Whether you're looking for flexible living space, modern upgrades, energy efficiency, or a prime Clovis location, 997 Pistachio Ave offers an exceptional opportunity to experience the best of Clovis living.SCHEDULED SHOWINGS COMMENCING : SATURDAY MAY 23 2026 BEGINNING @ 1:00 PM. KINDLY RESERVE THROUGH SHOWING TIME

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1990

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$260

Price Per Acre

$2,843,796

Days On London

Cumulative Days On London

County

Fresno

Reports Available

Home Inspection, Pest

Special Features

Security System, Security Gate

REO / Bank Owned

Cross Street Address

N/Barstow E/Pistachio

Directions

Barstow | Pistachio

Style

Contemporary

Heating & Cooling

Central Heat & Cool, Central Heating

Laundry

Inside, Utility Room

Roofing

Tile

Foundation

Concrete

Detached Structures

Shed, Other/See Remarks

Kitchen

F/S Range/Oven, Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry, Refrigerator

Dining Room Features

Formal

Primary Bedroom Level

Main

Bath Features

Tub/Shower, Shower

Extra Rooms

Office, Den/Study, Game Room

Basement

None

Disabled Features

One Level Floor

# of Fireplaces

Fireplace Type

Gas Insert

Exterior

Stucco

Pool

Yes

Pool

Yes

Pool Type

In Ground

Spa

Patio Features

Covered

Yard

Sprinklers Auto, Fenced, Mature Landscape, Garden Area

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Yes

Solar Type

Owned

Parking Features

Potential RV Parking

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

Lot Dimensions

80X111

Site Amenities

Other

APN

551 114 04 [PARCEL MAP]

Zoning

School District

Clovis Unified

School Type 1

High School

School Name 1

Clovis

School Type 2

Junior High School

School Name 2

Clark

School Type 3

Grade School

School Name 3

Clovis Elementary

Seller Will Consider

Conventional, Cash

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 550857.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 608842.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1977 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2477 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1728381 OR `props-main`.`id` = 1727686 OR `props-main`.`id` = 1726013 OR `props-main`.`id` = 1725911 OR `props-main`.`id` = 1728326 OR `props-main`.`id` = 1725804 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1718828 OR `props-main`.`id` = 1719384 OR `props-main`.`id` = 1722193 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1727068 OR `props-main`.`id` = 1722446 OR `props-main`.`id` = 1707114 OR `props-main`.`id` = 1700214 OR `props-main`.`id` = 1698700 OR `props-main`.`id` = 1700216 OR `props-main`.`id` = 1712804 OR `props-main`.`id` = 1722354 OR `props-main`.`id` = 1722227 OR `props-main`.`id` = 1727677 OR `props-main`.`id` = 1725096 OR `props-main`.`id` = 1716978 OR `props-main`.`id` = 1721089 OR `props-main`.`id` = 1718751 OR `props-main`.`id` = 1726196 OR `props-main`.`id` = 1697079 OR `props-main`.`id` = 1716655 OR `props-main`.`id` = 1716157 OR `props-main`.`id` = 1722529 OR `props-main`.`id` = 1724752 OR `props-main`.`id` = 1724532 OR `props-main`.`id` = 1725806 OR `props-main`.`id` = 1722862 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1713121 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1717580 OR `props-main`.`id` = 1718093 OR `props-main`.`id` = 1724570 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1722918 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1726250 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1713841 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1718498 OR `props-main`.`id` = 1721031 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1728339 OR `props-main`.`id` = 1728168 OR `props-main`.`id` = 1725534 OR `props-main`.`id` = 1726630 OR `props-main`.`id` = 1718456 OR `props-main`.`id` = 1727496 OR `props-main`.`id` = 1718568 OR `props-main`.`id` = 1718959 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1727125 OR `props-main`.`id` = 1727762 OR `props-main`.`id` = 1727761 OR `props-main`.`id` = 1727767 OR `props-main`.`id` = 1726920 OR `props-main`.`id` = 1723088 OR `props-main`.`id` = 1721948 OR `props-main`.`id` = 1728341 OR `props-main`.`id` = 1728340 OR `props-main`.`id` = 1692117 OR `props-main`.`id` = 1725836 OR `props-main`.`id` = 1725880 OR `props-main`.`id` = 1720527 OR `props-main`.`id` = 1707233 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1727061 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1721724 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1728397 OR `props-main`.`id` = 1711200 OR `props-main`.`id` = 1718677 OR `props-main`.`id` = 1715688 OR `props-main`.`id` = 1724931 OR `props-main`.`id` = 1720863 OR `props-main`.`id` = 1726529 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 1724473 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1685150 OR `props-main`.`id` = 1721535 OR `props-main`.`id` = 1721541 OR `props-main`.`id` = 1721492 OR `props-main`.`id` = 1727133 OR `props-main`.`id` = 1712341 OR `props-main`.`id` = 1720270 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 1718239 OR `props-main`.`id` = 1702478 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1700881 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1720830 OR `props-main`.`id` = 1728346 OR `props-main`.`id` = 1721860 OR `props-main`.`id` = 1726398 OR `props-main`.`id` = 1726287 OR `props-main`.`id` = 1726840 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1723006 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 OR `props-main`.`id` = 1723835 OR `props-main`.`id` = 1723817 OR `props-main`.`id` = 1725062 OR `props-main`.`id` = 1724803 OR `props-main`.`id` = 1721879 OR `props-main`.`id` = 1724299 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1720480 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1724886 OR `props-main`.`id` = 1723559)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649206' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-22' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

Similar Properties

$575,000

5
2
2,040
0.18

2337 Wrenwood Ave

Clovis, CA 93611

$569,000

4
3
2,240
0.19

2154 Wrenwood Ave

Clovis, CA 93611

$560,000

5
2
2,206
0.22

701 McArthur Ave

Clovis, CA 93611

$560,000

4
3.5
2,250
0.31

1758 Barstow Ave

Clovis, CA 93611

Courtesy of Rufi Alday, Real Broker - [email protected]
Last modified 2 hours ago
Fresno MLS last checked for updates 19 minutes ago

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

997 Pistachio Ave

Clovis, CA 93611

Photo Gallery

$579,850

997 Pistachio Ave

Clovis, CA 93611

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$575,000

$569,000

$560,000

$560,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

997 Pistachio Ave

Clovis, CA 93611

Photo Gallery

$579,850

997 Pistachio Ave

Clovis, CA 93611

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$575,000

$569,000

$560,000

$560,000

Loading...

Saving...

Deleting...

Searching...