Sat, Oct 11 1:00pm - 4:30pm Courtesy of Century 21 Select Real Estate
Sun, Oct 12 1:00pm - 4:00pm Courtesy of Century 21 Select Real Estate
Schedule a Tour
Contact Info
Presented By:
Robin Hillhouse209.777.2282robinsbestnest@outlook.comEmail Agent
Property Description
Exquisite custom built Mediterranean boasts the classical features architectural features such as stucco smooth walls, columns, and arches with the classic outdoor living space. Specifically designed, crafted, and thoughtfully designed for this owner's sole comfort and beauty. Perfect blend for a family who wants large animals but the convenience of high end living. The family room amenities are gas fireplace with remote, with built in refrigerator and a microwave located above a beautifully shelved craftsmanship shows upon walking in this amazing spacious kitchen with top of the line appliances double oven, microwave, dishwasher, etc. along with a center island, breakfast bar along with an energy efficient wall fireplace which offer warmth and ambiance during the winter. Primary bedroom is large and spacious with a dual fireplace shared with a large custom primary bathroom with a jacuzzi tub, large beautiful shower with exceptional cabinetry. All bedrooms are large with deep closets. Ceiling fans are throughout the interior and in the patio. Backyard has custom outdoor kitchen, with several sitting areas, and also a hot tub. Drought oasis landscaping front and back.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2008
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$317
Price Per Acre
$263,125
Days On Market
5
Cumulative Days On Market
5
County
Madera
Reports Available
Well
Leased Equipment
Security System, Propane
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Security Gate, Built In Cabinets, Other/See Remarks, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Ave 23 1/2
Directions
Merge onto 99 North, Take exit 164 for Avenue 21 1/2 toward Road 20. Slight right only ramp 21 1/2 merge onto 21 1/2. You will see Road 20 and continue North.
Unit Description
Ground Floor
Style
Mediterranean
Heating & Cooling
Central Heat & Cool, Ductless or Split, Floor or Wall Unit
Laundry
Inside, On Lower Level
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Wine Refrigerator
Dining Room Features
Formal
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Jetted Tub, Oval Tub
Extra Rooms
Office
Basement
None
Disabled Features
Wide Doors, One Level Floor
Flooring
Tile
# of Fireplaces
3
Fireplace Type
Zero Clearance
Exterior
Stucco
Pool
No
Pool
No
Spa
Yes
Spa Type
Above Ground
Patio Features
Covered, Concrete
Yard
Mature Landscape, Garden Area, Drip System, Other
Gas & Electric
Propane, All Electric
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Triple Pane Windows
Solar
No
Parking Features
Potential RV Parking, Carport, Drive Thru, Auto Opener, Street, Circular Driveway, Tandem Garage
Garage Type
Attached
Garage Spaces
2
Carport Spaces
2
Site Amenities
Pasture
APN
027 071 033 000
Zoning
RS2
School District
Chowchilla
School Type 1
High School
School Name 1
Chowchilla
School Type 2
Junior High School
School Name 2
Wilson
School Type 3
Grade School
School Name 3
Chowchilla Schools
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Free & Clear
72872
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 839895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2275 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2775 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` = 1622929 OR `props-main`.`id` = 1684708 OR `props-main`.`id` = 1676842 OR `props-main`.`id` = 1666399 OR `props-main`.`id` = 1687243 OR `props-main`.`id` = 1676879 OR `props-main`.`id` = 1677234 OR `props-main`.`id` = 1676892 OR `props-main`.`id` = 1622909 OR `props-main`.`id` = 1665818 OR `props-main`.`id` = 1680016 OR `props-main`.`id` = 1682293 OR `props-main`.`id` = 1675417 OR `props-main`.`id` = 1679079 OR `props-main`.`id` = 1680678 OR `props-main`.`id` = 1666308 OR `props-main`.`id` = 1687626 OR `props-main`.`id` = 1682621 OR `props-main`.`id` = 1686769 OR `props-main`.`id` = 1682313 OR `props-main`.`id` = 1622790 OR `props-main`.`id` = 1688244 OR `props-main`.`id` = 1636375 OR `props-main`.`id` = 1682427 OR `props-main`.`id` = 1666061)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637870' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-07' 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 Anita Ruvalcaba, Century 21 Select Real Estate - nittacasa@yahoo.com Last modified 2 days ago Fresno MLS last checked for updates 9 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.