Courtesy of Myesha Frazier-Taylor, Stark Complete Real Estate Services - [email protected]
Welcome to a luxurious newly remodeled 4 bed 2 bath home on 1.1 acres in Valley Lakes Ranchos. Commercial zoned with stunning views of the mountains with natural lighting flowing through the home. Upon entry the recently installed light fixtures and open concept are stunning along with the matching built-in stainless steel kitchen Aide conduction cook top, food warming drawer, microwave, dishwasher with window that can be controlled via app, exhaust hood along with the ventilation fan, & trash compactor. Custom extended cabinets flush to ceiling and soft close kitchen drawers. Custom pantry and indoor laundry room with utility sink without exposed pipes in laundry room. Stone flooring & shutters throughout. Family room is complete with an oversized gas starter fireplace. Primary room sliding glass door allows access to the backyard. Primary room soak tub, and dual sinks are exquisite and surrounded with granite and lead you to the visually stunning walk-in closet. Both restrooms are designed with speakers to connect through Bluetooth. Custom closet in hallway and cedar lined bench storage cabinetry located in two rooms. Rear patio is extended and covered, complete with three ceiling fans. Entire property is gated with distinguished ornate metal fencing surrounding the front of the property, dual gates controlled by remote and digital gate keypad. Exterior fully painted last year with a beautiful elastomeric paint. Custom cabinets also installed inside of the 2-car garage.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$315
Price Per Acre
$599,091
Days On London
324
Cumulative Days On London
324
County
Madera
Reports Available
NHD
Leased Equipment
Propane
Special Features
Security Gate, Built In Cabinets, Water Softener
REO / Bank Owned
No
Cross Street Address
Ave 21 & Road 28 1/2
Directions
Take exit 154 on the right onto W 4th St Turn right onto W 4th St Turn left onto N Lake St Turn right onto E Cleveland Turn left onto Raymond Rd Turn right onto Avenue 21 Property will be on your left
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Trash Compactor, Breakfast Bar, Pantry
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub, Other
Flooring
Other
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered, Concrete
Yard
Drip System
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Well Depth
600.00
Solar
No
Parking Features
Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
031 504 019 000
Zoning
Commercial/Residencial
School District
Madera Unified
School Type 1
High School
School Name 1
Matilda
School Type 2
Junior High School
School Name 2
Jack G. Desmond
School Type 3
Grade School
School Name 3
Berenda
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 626050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 691950 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) >= 1839 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2339 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` = 1716992 OR `props-main`.`id` = 1720786 OR `props-main`.`id` = 1734560 OR `props-main`.`id` = 1721115 OR `props-main`.`id` = 1591884 OR `props-main`.`id` = 1730640 OR `props-main`.`id` = 1730648 OR `props-main`.`id` = 1731621 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` = 1722245 OR `props-main`.`id` = 1722377 OR `props-main`.`id` = 1722379 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` = 1736406 OR `props-main`.`id` = 1698813)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634172' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-15' 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 4 hours ago Fresno MLS last checked for updates 56 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.
