Investor Alert! Don't miss this awesome opportunity2 bedrooms plus a bonus room 1 bath home with tons of potential. Big backyard with room to grow and ready for your vision. Contact your favorite realtor today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1934
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$215
Price Per Acre
$974,995
Days On Market
212
Cumulative Days On Market
212
County
Kern
REO / Bank Owned
No
Cross Street Address
Weedpatch Hwy/Muller RD
Directions
Weed patch Hwy, and Muller Rd
Heating & Cooling
Evaporative Cool, Floor or Wall Unit
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Shower
Flooring
Tile
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Solar
No
Parking Features
Uncovered
APN
177 202 140
School District
Kern
School Type 1
High School
School Name 1
Kern
School Type 2
Junior High School
School Name 2
Kern
School Type 3
Grade School
School Name 3
Kern
Seller Will Consider
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 185249.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 204748.95 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) >= 659 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1159 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` = 1655533)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629365' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Roger Magana, Golden Valley Real Estate Group - [email protected] Last modified 7 months ago Fresno MLS last checked for updates 6 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.
