Unleash the potential at 33828 Shaver Springs Rd! Listed way below market just $225K vs. an estimated value of around $355K. This 3 bed, 3 bath, 1,432 sqft gem sits on a ~7,500 sqft lot and only needs cosmetic updates. Think quick flip, rental, or investment ROI hustle. Plus, financing available!!!. Act fast!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1978
Region
Rural
# of Stories
Two
Price Per Square Foot
$156
Price Per Acre
$1,295,006
Days On Market
69
Cumulative Days On Market
69
County
Fresno
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Shaver springs
Directions
Use gps map to get to property
Style
Cottage
Heating & Cooling
Window or Wall A/C
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 211850 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 234150 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1182 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1682 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` = 1681763 OR `props-main`.`id` = 1682006 OR `props-main`.`id` = 1695707 OR `props-main`.`id` = 1656697 OR `props-main`.`id` = 1691155 OR `props-main`.`id` = 1676696 OR `props-main`.`id` = 1697417 OR `props-main`.`id` = 1683151 OR `props-main`.`id` = 1669868 OR `props-main`.`id` = 1678691 OR `props-main`.`id` = 1683249 OR `props-main`.`id` = 1666345 OR `props-main`.`id` = 1690893 OR `props-main`.`id` = 1691012 OR `props-main`.`id` = 1701176 OR `props-main`.`id` = 1691752)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno635673' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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 Harbhavnik Singh, Bien Properties Inc. - [email protected] Last modified 2 months 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.
