Courtesy of Jose Briseno Arredondo, Berkshire Hathaway HomeServices California Realty - [email protected]
Country living at its finest! Two Homes on over 18 Acres. Main home is ~1,976 sqft, 3 bedroom 2 baths, open living room, dining room, kitchen, family room, office, covered patio and a three car garage. The second home is ~1,572, 2-bedroom, 2-bathroom, living room, dining room, kitchen, two covered patios and a 2-car garage. Both homes have new roofs. Land has a large shop, land can be used for many things including farming or keeping animals.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1970
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$200
Price Per Acre
$36,959
Days On London
496
Cumulative Days On London
496
County
Tulare
REO / Bank Owned
No
Cross Street Address
Road 42
Directions
HWY 99 to Earlimart, take exit 65A, west towards Sierra Ave., Turn Right (west) onto Sierra Rd. Continue straight onto Avenue 56, W. Sierra Ave., Turn Left (south) On Rd 50 and then right (west) onto Avenue 50. Property will be on the right hand side
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Other
Foundation
Concrete
Primary Bedroom Level
Main
# of Fireplaces
2
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
5
APN
311 110 026
School District
Alpaugh
School Type 1
High School
School Name 1
Aplaugh
School Type 2
Junior High School
School Name 2
Aplaugh
School Type 3
Grade School
School Name 3
Aplaugh
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 734998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3253 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3753 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` = 1720114 OR `props-main`.`id` = 1726314 OR `props-main`.`id` = 1719965 OR `props-main`.`id` = 1709577 OR `props-main`.`id` = 1712889 OR `props-main`.`id` = 1654589 OR `props-main`.`id` = 1654584 OR `props-main`.`id` = 1674748 OR `props-main`.`id` = 1654593 OR `props-main`.`id` = 1720124 OR `props-main`.`id` = 1750452 OR `props-main`.`id` = 1748873 OR `props-main`.`id` = 1748872 OR `props-main`.`id` = 1721436 OR `props-main`.`id` = 1753551 OR `props-main`.`id` = 1712916 OR `props-main`.`id` = 1763446 OR `props-main`.`id` = 1740217 OR `props-main`.`id` = 1746123)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629036' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-31' 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();
1
Similar Properties
$699,999
5
4
3,503
18.94
4306 Avenue 50
Alpaugh, CA 93201
Last modified 3 months ago Fresno MLS last checked for updates 26 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.
