9200 W Herndon, Fresno, CA 93723

Newly Improved Price! Don't miss your opportunity to own a rare Luxury San Joaquin Riverfront Homesite and Prime Young Pistachios!! Not one, but two prime properties to choose from (adjacent property also available) with buildable areas along the river frontage just minutes from nearby shopping, entertainment, food, golfing and more near the Herndon and Highway 99 area. Proposed World's Largest Costco within a 5 minute drive.But wait, it just keeps getting better!! 3 sources of water for your farming and recreation needs, Riparian Water Rights, the Fresno Irrigation District (FID) and one Ag pump and well.If that isn't enough, enjoy the benefit of the income producing 2016 planted Lost Hills Pistachio's!! The trees are in prime condition and have just reached a full production capacity for many more years of profits! (Farm management is available if needed)River frontage land has easy access to the San Joaquin River for recreational activities including fishing, hunting, shooting, floating, off-road vehicles, private fishing pond, camp sites and more. There is approximately -900 feet of river frontage.