Beautifully updated single-story home offering comfort, efficiency, and functionality. This home is well maintained with many upgrades like newer roof and new HVAC system, solar and many other details throughout. Bedrooms are a perfect size with closets that offer plenty of space. Bathrooms have modern fixtures, tub and shower mix for practicality. Open kitchen area with plent of counter space. Enjoy the spacious backyard with covered patio, mature trees, plenty of room for gardening, play, or future customization. Located in an establised neighborhood, this home offers a great blend of move in ready condition, energy efficiency, indoor comfortability and outdoor space. An excellent opportunity that won't last long!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1997
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$273
Price Per Acre
$2,624,983
Days On London
2
Cumulative Days On London
2
County
Madera
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
Avenue 9/Rd 24
Directions
From Hwy 99 North, exit Avenue 9, head West. Pass Road 24. Left on Paraiso Avenue, right on Las Uvas, home on right hand side.
Style
Mid-Century Modern
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Lower
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
Yes
Solar Type
Power Purchase AGMT
Garage Type
Attached
Garage Spaces
2
APN
044 310 020 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Junior High School
School Name 2
La Vina
School Type 3
Grade School
School Name 3
La Vina
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299248.1 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330747.9 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 904 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1404 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` = 1709981 OR `props-main`.`id` = 1705619)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644141' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Karina Cano, Western Pioneer Properties - [email protected] Last modified 3 days ago Fresno MLS last checked for updates 15 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.
