Courtesy of Rogelio Guizar, Universal Realty Services, Inc. - [email protected]
Come take a look at this Country Living Gem just 5 minutes From ChukChansi Gold Resort and Casino. This Cute little Home offers 4 Bedrooms and 2 baths and an open Floor Plan! The Home has been Updated Inside and Out, The Open Floor Kitchen has nice Granite Counter tops and New Stainless Steel Appliances. Also new Flooring and Paint Throughout. This Cute Home sits on an Acre on the Corner lot and is and perfect for Privacy and Entertainment. Call Your local Agent and take a look at this Beauty, Send us an offer.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1979
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$214
Price Per Acre
$329,900
Days On London
0
Cumulative Days On London
0
County
Madera
Reports Available
Pest
Leased Equipment
Propane
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Road 417
Directions
41 to Road 417 East to Delaware South than East on Klamath
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Breakfast Bar
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Extra Rooms
Converted Garage
Basement
None
Flooring
Laminate
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Uncovered
Yard
Fenced, Mature Landscape
Gas & Electric
Propane
Sewer / Water
Public Water, Community Well
Solar
No
Parking Features
Existing RV Parking, Potential RV Parking
Are there garage spaces?
No
Site Amenities
Corner
APN
054 373 013 000
School District
Madera Unified
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Eastin-Arcola
School Type 3
Grade School
School Name 3
John Adams
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Free & Clear
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 313405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 346395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1290 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1790 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` = 1717727 OR `props-main`.`id` = 1717714 OR `props-main`.`id` = 1735362 OR `props-main`.`id` = 1731465 OR `props-main`.`id` = 1706720 OR `props-main`.`id` = 1706689 OR `props-main`.`id` = 1665733 OR `props-main`.`id` = 1665734 OR `props-main`.`id` = 1687540 OR `props-main`.`id` = 1687541 OR `props-main`.`id` = 1731198 OR `props-main`.`id` = 1727052 OR `props-main`.`id` = 1711503 OR `props-main`.`id` = 1711512 OR `props-main`.`id` = 1734080 OR `props-main`.`id` = 1733374 OR `props-main`.`id` = 1733314 OR `props-main`.`id` = 1735470 OR `props-main`.`id` = 1725484 OR `props-main`.`id` = 1725498 OR `props-main`.`id` = 1723235 OR `props-main`.`id` = 1690456 OR `props-main`.`id` = 1722179 OR `props-main`.`id` = 1665689 OR `props-main`.`id` = 1731337 OR `props-main`.`id` = 1665648 OR `props-main`.`id` = 1731530 OR `props-main`.`id` = 1717119 OR `props-main`.`id` = 1717142 OR `props-main`.`id` = 1732729 OR `props-main`.`id` = 1725898 OR `props-main`.`id` = 1725891 OR `props-main`.`id` = 1732706 OR `props-main`.`id` = 1732172 OR `props-main`.`id` = 1731535 OR `props-main`.`id` = 1718021 OR `props-main`.`id` = 1718043)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650182' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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
Last modified 2 hours ago Fresno MLS last checked for updates 5 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.
