Location, location, location! Beautiful move in ready home full of character. Completely 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
7
Cumulative Days On Market
7
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` = 1696276 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1701508 OR `props-main`.`id` = 1701459 OR `props-main`.`id` = 1701437 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1698913 OR `props-main`.`id` = 1701433 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701435 OR `props-main`.`id` = 1701535 OR `props-main`.`id` = 1701460 OR `props-main`.`id` = 1701461 OR `props-main`.`id` = 1701462 OR `props-main`.`id` = 1701536 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1701439 OR `props-main`.`id` = 1701440 OR `props-main`.`id` = 1701438 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1701534 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1701431 OR `props-main`.`id` = 1701432 OR `props-main`.`id` = 1697082 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` = 1677702 OR `props-main`.`id` = 820696 OR `props-main`.`id` = 1677889 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 OR `props-main`.`id` = 1701191)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641459' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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 - juliannaspadier1@gmail.com Last modified 4 days ago Fresno MLS last checked for updates 35 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.
