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
19
Cumulative Days On London
19
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` = 1729323 OR `props-main`.`id` = 1731771 OR `props-main`.`id` = 1696299 OR `props-main`.`id` = 1713881 OR `props-main`.`id` = 1731394 OR `props-main`.`id` = 1731082 OR `props-main`.`id` = 1731083 OR `props-main`.`id` = 1695771 OR `props-main`.`id` = 1728111 OR `props-main`.`id` = 1688382 OR `props-main`.`id` = 1679800 OR `props-main`.`id` = 1727884 OR `props-main`.`id` = 1730665 OR `props-main`.`id` = 1731722 OR `props-main`.`id` = 1691000 OR `props-main`.`id` = 1690972 OR `props-main`.`id` = 1728558 OR `props-main`.`id` = 1728562 OR `props-main`.`id` = 1731726 OR `props-main`.`id` = 1729705 OR `props-main`.`id` = 1729873 OR `props-main`.`id` = 1731767 OR `props-main`.`id` = 1729176 OR `props-main`.`id` = 1729060 OR `props-main`.`id` = 1666451 OR `props-main`.`id` = 1720786 OR `props-main`.`id` = 1724929 OR `props-main`.`id` = 1721115)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649109' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-11' 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
$498,999
3
2
1,449
0.50
18746 Auburn Way
Madera, CA 93638
Last modified 1 week ago Fresno MLS last checked for updates 47 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.
