Location, location, location! Beautiful move in ready home full of character.brCompletely rehabbed & ready for a new family. Beautiful kitchen & large primary suite w/incredible bathroom w/soaker tub. Completely fenced w/room to add a shop and/or some animals. Beautiful Mountain View's all around. This one will go fast so bring your buyers.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1969
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$424
Price Per Acre
$259,797
Days On Market
0
Cumulative Days On Market
0
County
Fresno
Reports Available
Pest
REO / Bank Owned
No
Cross Street Address
Fowler/International
Directions
168 turn North on Fowler, go past Shepherd and Behymer home will be on your right before International
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 730550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 807450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1565 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2065 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` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1665909 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1697088 OR `props-main`.`id` = 1698917 OR `props-main`.`id` = 1698913 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1693615 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1690721 OR `props-main`.`id` = 1697082 OR `props-main`.`id` = 1686437 OR `props-main`.`id` = 1687299 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1697347 OR `props-main`.`id` = 1699235 OR `props-main`.`id` = 1700153 OR `props-main`.`id` = 1697691 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 820696 OR `props-main`.`id` = 1690411 OR `props-main`.`id` = 1699225 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1690432 OR `props-main`.`id` = 1674389 OR `props-main`.`id` = 1689630 OR `props-main`.`id` = 1653256 OR `props-main`.`id` = 1689446 OR `props-main`.`id` = 1699972 OR `props-main`.`id` = 1696333)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641459' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-30' 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 Julianna Spadier, Better Homes & Garden Real Estate GoldLeaf - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 2 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.
