Don't miss this rare opportunity to own this one of a kind piece of property with approximately 270 feet of prime Fresno River frontage. This immaculate 4-bedroom, 3-bathroom custom home built in 2020 boasts 2,122 square feet of pure luxury. As you step inside, you will be impressed by the 100% luxury wide plank vinyl flooring and the extra high 9-foot ceilings, providing a feeling of openness throughout the home. The spacious great room welcomes you with a stylish dining area, exquisite modern fireplace, a chef's dream kitchen featuring a substantial 8-foot island and a large walk-in pantry. The countertops are adorned with elegant granite, and the appliances are all stainless steel. The homes exceptional layout offers various bedroom and bathroom areas, ensuring privacy for all. It also makes it ideal for granny quarters, in-law set up, guests, older children, Airbnb, etc. The master suite is truly indulgent, with expansive space, multiple closets, his and hers vanities, a relaxing soaking tub, and a generous walk-in shower. Plus there's an extra bonus room that could serve as an office or additional storage space. This home features many modern amenities, including a tankless water heater, upgraded insulation, and a high efficiency heating and air system with a WiFi enabled thermostat. The exterior features stucco, stone and a fire-resistant concrete tile roof. This isn't just a home; it's a lifestyle. Seize this opportunity to make this waterfront living a reality.