Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/649109/18746-Auburn-Way/Madera/https://www.londonproperties.com/images/props/fresno/full/649109.jpgLondon Properties Madera Real Estate | 18746 Auburn Way
Courtesy of Wayland Chu, Century 21 Select Real Estate - [email protected]
This charming home offers a serene country living experience while still being conveniently close to highway access. It features unique amenities that can help reduce monthly expenses. You'll find a fire hydrant within 100 feet of the property, as well as curbing instead of dirt at the street, complete with a storm drain. The front and back yards boast mature, meticulously maintained landscaping, front and backyard sprinkler system.The property sits on half an acre, fully fenced, with a 3-foot-wide dog run along the perimeter. Enjoy the beauty of palm trees and well-established landscaping, along with a cozy fire pit for cool evenings. This completely updated home is spacious, making it perfect for family gatherings, and there is ample space for the inground pool of your choice.Located in the country club area, you'll have access to private golfing just a stone's throw away. This corner lot is truly a hidden gem don't miss out on this opportunity! Ample space for the inground pool of your choice.Located in the Country Club area, you'll have access to private golfing just a stone's throw away. This corner lot is truly a hidden gem don't miss out on this opportunity!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1997
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$344
Price Per Acre
$997,998
Days On London
40
Cumulative Days On London
40
County
Madera
Reports Available
Home Inspection
Special Features
Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Country Club Dr./ Frontage Rd
Directions
Hwy99 exit Ave 17(right going East), Left on Road 26(North), right on Club Dr, quick right on Frontage Rd, which curves into Auburn Way.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474049.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 523948.95 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) >= 1199 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1699 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` = 1719845 OR `props-main`.`id` = 1724637 OR `props-main`.`id` = 1724638 OR `props-main`.`id` = 1724641 OR `props-main`.`id` = 1724469 OR `props-main`.`id` = 1724640 OR `props-main`.`id` = 1724468 OR `props-main`.`id` = 1739799 OR `props-main`.`id` = 1740350 OR `props-main`.`id` = 1739774 OR `props-main`.`id` = 1713881 OR `props-main`.`id` = 1731082 OR `props-main`.`id` = 1731083 OR `props-main`.`id` = 1695771 OR `props-main`.`id` = 1728111 OR `props-main`.`id` = 1737821 OR `props-main`.`id` = 1737831 OR `props-main`.`id` = 1742813 OR `props-main`.`id` = 1740730 OR `props-main`.`id` = 1688382 OR `props-main`.`id` = 1743879 OR `props-main`.`id` = 1742711 OR `props-main`.`id` = 1740764 OR `props-main`.`id` = 1743914 OR `props-main`.`id` = 1742615 OR `props-main`.`id` = 1727884 OR `props-main`.`id` = 1742590 OR `props-main`.`id` = 1742592 OR `props-main`.`id` = 1728558 OR `props-main`.`id` = 1728562 OR `props-main`.`id` = 1729705 OR `props-main`.`id` = 1729873 OR `props-main`.`id` = 1731767 OR `props-main`.`id` = 1744306 OR `props-main`.`id` = 1744318 OR `props-main`.`id` = 1666451 OR `props-main`.`id` = 1744651 OR `props-main`.`id` = 1720786 OR `props-main`.`id` = 1738018 OR `props-main`.`id` = 1721115)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649109' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-02' 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();
1
Similar Properties
$490,000
3
2
1,689
0.99
18014 Daley Rd
Madera, CA 93638
Last modified 1 week ago Fresno MLS last checked for updates 12 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.
