Discover an extraordinary riverside haven offering an unparalleled investment opportunity in the heart of Firebaugh. This property offers over 580' +/- of San Joaquin River frontage on 3.75 acres, providing stunning views. The main home is 2,773 sq ft with 3 beds and 2 baths. The Plantation Mobile Home Park currently hosts 22 fully-occupied mobile homes with stable tenants, generating immediate rental income. Additional features include a small cottage that is about 400 sq ft +/- with 1 bed, 1 bath, and a kitchen, multiple storage sheds, and a 30'X41' shop. The property's strategic location near downtown Firebaugh and the new West Hills College enhances its appeal. Outdoor enthusiasts will appreciate the proximity to trails and natural spaces, while convenient access to Fresno is only 45 minutes away. Whether for residential use or investment, this property is a rare find.