Courtesy of Michael Pappace, Real Brokerage Technologies - [email protected]
Very nice custom home now available! 2,400 plus sq. ft. home on 1.31 acres. Nice sized bedrooms with good closet space in each. Separate room is utilized as an office, right off the kitchen/dining room area. Expansive front yard w/deep set-back of the home for quiet & privacy.This single-story home has a wide-open living room & kitchen/dining area layout. High ceilings with a ceiling fan in the family room. The kitchen has a good amount of cabinetry & has a granite countertop. Wood flooring runs throughout much of the home. There is an abundance of natural lighting throughout the home.Good sized bedrooms, an indoor laundry room, lots of closet space throughout the home. The back yard is completely fenced. Potential parking for an RV, 18 wheeler, construction equipment, storage. Lots of room to add an exterior shop, ADU, in-ground pool. Lots of potential to put your stamp on this property. Buyers to verify potential of all future use.This is a very nice property with much upside potential at a great price. I think you will agree once you visit it for yourself!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1995
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$245
Price Per Acre
$454,160
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Security System, Propane, Solar Panels
Special Features
Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Valley View Road
Directions
From Cleveland Ave, go north on Raymond Road, which will become Road 28 1/2. keep going. Make a right turn on Avenue 22. Go about 1 1/2 to 2 miles. On the corner of Avenue 22 and Valley View Road, home will be on your right.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Refrigerator
Dining Room Features
Family Room/Area
Primary Bedroom Level
Lower
Bath Features
Shower
Extra Rooms
Office, Family Room
Basement
None
Flooring
Laminate, Tile, Other
# of Fireplaces
1
Fireplace Type
Masonry, Wood Insert, Zero Clearance
Exterior
Other
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Uncovered, Concrete
Yard
Sprinklers Manual, Fenced, Mature Landscape
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Other
Parking Features
Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Corner
APN
031 552 002 000
Zoning
SFR
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Junior High School
School Name 2
Jack G. Desmond
School Type 3
Grade School
School Name 3
Berenda
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Non-Assumable
Census Tract
5.140
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 565202.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 624697.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2182 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2682 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` = 1742212 OR `props-main`.`id` = 1743810 OR `props-main`.`id` = 1731620 OR `props-main`.`id` = 1734560 OR `props-main`.`id` = 1591884 OR `props-main`.`id` = 1730640 OR `props-main`.`id` = 1730648 OR `props-main`.`id` = 1723687 OR `props-main`.`id` = 1723583 OR `props-main`.`id` = 1723578 OR `props-main`.`id` = 1677466 OR `props-main`.`id` = 1725993 OR `props-main`.`id` = 1727455 OR `props-main`.`id` = 1728986 OR `props-main`.`id` = 1731863 OR `props-main`.`id` = 1723923 OR `props-main`.`id` = 1724658 OR `props-main`.`id` = 1722076 OR `props-main`.`id` = 1749259 OR `props-main`.`id` = 1736406 OR `props-main`.`id` = 1698813)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652048' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-14' 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 1 hour 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.
