WATERFRONT OASIS ON THE SAN JOAQUIN RIVER IN RIVIERA CLIFFS. This one is a once in a lifetime opportunity with front row river views on over an acre and 300' of riverfront property. Absolutely stunning property with numerous upgrades. Live the indoor outdoor lifestyle with ample space for entertaining. The property features in part a salt water pool/spa, swim up bar, BBQ area, mature landscaping all irrigated from the river, small vineyard and fruit trees. The expansive 5100 plus SF house has great flow with floor to ceiling windows with river views from most every room in the house. There's a huge outdoor covered patio with 100" fireplace, built-in Memphis BBQ and custom iron railing and floor. The custom kitchen has carrera marble counter tops and thermador appliances. Theres so much more! This is literally resort living on the San Joaquin river. Boat to San Francisco, fish in your backyard. Take the golf cart over to the Stockton Golf and Country Club. Your piece of paradise awaits!