EXCELLENT HOME CENTRALLY LOCATED BETWEEN FRESNO AND MERCED COUNTY. DOUBLE STORY HOME CLOSE TO GOLF COURSE. TOWN W GREAT VIBE AND COMMUNITY THAT IS GROWING. DONT MISS THIS AMAZING HOME. COME AND SEE ME.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Attached
Year Built
2022
Year Built Source
Other
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
2
Home Warranty
No
Directions to Property
99 TO FIG TREE TO CONADRIA
Cross Street
FIG TREE RD
County
Madera
Special Listing Conditions
None
Main Level
Bedroom(s), Full Bath(s)
Construction Materials
Wood
Foundation
Slab
Roof
Shingle
Heating
Central
Cooling
Central
Laundry Features
Inside Area
Full Bathrooms
3
Bath Features
Shower Stall(s), Tub, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Wood
Kitchen Features
Quartz Counter
Dining Room Features
Other
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
Other
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Other
APN
014 021 088
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Madera
Elementary School District
Other
Middle or Junior School District
Other
Senior High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 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) >= 1519 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2019 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` = 1654610 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1702898 OR `props-main`.`id` = 1702827 OR `props-main`.`id` = 1702880 OR `props-main`.`id` = 1704177 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1711273 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1710975 OR `props-main`.`id` = 1675030 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1682128 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1710574 OR `props-main`.`id` = 1709896 OR `props-main`.`id` = 1709744 OR `props-main`.`id` = 1700186 OR `props-main`.`id` = 1687217 OR `props-main`.`id` = 1710205 OR `props-main`.`id` = 1710203 OR `props-main`.`id` = 1687858 OR `props-main`.`id` = 1691708 OR `props-main`.`id` = 1646822 OR `props-main`.`id` = 1646820 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1710478 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1710045 OR `props-main`.`id` = 1691873 OR `props-main`.`id` = 1710027 OR `props-main`.`id` = 1699086 OR `props-main`.`id` = 1704531 OR `props-main`.`id` = 1709211 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1696088 OR `props-main`.`id` = 1701332 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1710843 OR `props-main`.`id` = 1711104 OR `props-main`.`id` = 1711098 OR `props-main`.`id` = 1711099 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1710491 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1685347 OR `props-main`.`id` = 1691123 OR `props-main`.`id` = 1691137 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1700156 OR `props-main`.`id` = 1654660 OR `props-main`.`id` = 1692518 OR `props-main`.`id` = 1701828 OR `props-main`.`id` = 1705326 OR `props-main`.`id` = 1709558 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1707237 OR `props-main`.`id` = 1707242 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1705307 OR `props-main`.`id` = 1702108 OR `props-main`.`id` = 1702253 OR `props-main`.`id` = 1655889)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225140551' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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 Amit Gambhir, eXp Realty of Northern California, Inc. IDX provided by Reliance Marketing
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.
