Courtesy of Maria Herrera, London Properties, Ltd. - [email protected]
Discover peaceful country on this spacious rural property located just outside Dinuba. This home offers wide-open surroundings, mature trees, and plenty of room for outdoor activities, equipment, or future improvements. Enjoy the privacy of a quiet setting while being close to town conveniences, schools, and major road access. With a bit of thoughtful TLC, this property has the potential to become a wonderful home, offering to perfect opportunity to customize and create a space tailored to your vision.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1981
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$276
Price Per Acre
$1,191,121
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
Ave 376, Rd 60
Directions
From Fresno Take CA-99 South to Mountain View Ave heading east, turn right on Road 80, then make left onto Ave 384, turn right to Hunter Road to 37774 Hunter Rd
Heating & Cooling
Central Heating
Laundry
On Porch
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
1
APN
043 063 014
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) >= 209000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 231000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 546 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1046 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` = 1742647)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650885' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-26' 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
Last modified 2 hours ago Fresno MLS last checked for updates 10 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.
