Be ready to say Wow Wow Wow! How can one property offer so much! Great rural setting between Dinuba and Kingsburg with a solid built vintage 3 bedroom 2 bath home on 10 acres of Peaches, spacious outdoor entertaining area with covered patio and open courtyard for a possible venue site, mature landscaping and well planned out back yard, old western town with it's own saloon, deep pit bbq and tons and tons of storge space for all your tables, chairs and party dcor.But that is not all, don't forget the full size Santa Fe Railroad Caboose, water tower and crossing arm to round out the backdrop of the event. It would make a great Airbnb or Groomsman Suite on the day of the intimate wedding. The back up generator will keep the party going even if the power goes out!We are not done yet! Don't forget about the finished Shop/Mancave with a cabinet make setup for you side or full time business and storge room for all your toys! There are multiple electrical outlets throughout for all of your woodworking equipment and the large roll-up door lets your biggest projects and toys in with ease. That doesn't even count the spacious 2-car garage with even more storage cabinet already in place and the covered RV storage.Family, Farming and Fun!! It doesn't get any better than that!Make your appointment to see the one of a kind property today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1962
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$368
Price Per Acre
$86,978
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
Avenue 400
Directions
East bound Avenue 400, turn south on Road 74, property is on west side of road.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Wood Subfloor
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco, Brick
Pool
No
Pool
No
Gas & Electric
Public Utilities, Propane, Generator
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Existing RV Parking, Carport
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
Carport Spaces
2
APN
030 060 011
School District
Dinuba
School Type 1
High School
School Name 1
Dinuba
School Type 2
Junior High School
School Name 2
Washington
School Type 3
Grade School
School Name 3
Grand View
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2125 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2625 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` = 1729145 OR `props-main`.`id` = 1721691 OR `props-main`.`id` = 1721693)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649231' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-27' 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();
0
Courtesy of Matthew Pennebaker, Advanced AG Realty & Appraisal - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 20 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.
