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/650284/14404-Killarney-Dr/Madera/https://www.londonproperties.com/images/props/fresno/full/650284.jpgLondon Properties Madera Real Estate | 14404 Killarney Dr
Courtesy of Ana Sherwood, Realty Concepts, Ltd. - Fresno - [email protected]
Located in the prestigious gated community known as Sumner Hill, (only minutes from River Park), this fabulous, 4bedroom, 2.5bath home on sits on 2.46 ac andhas never before been on the market, this one of a kind home has been exceptionally maintained. Peaceful views from almost every window and the breathtaking San Joaquin River is just minutes away via the private Sumner Hill river access gate. This property features an expansive covered back patio with views to the west/southwest. Enter this grand estate via the long, tree-lined driveway. This custom built home features a formal living room with large, floor to ceiling windows, Berber carpet, ceramic tile floors in the entrance hall, kitchen and dining areas; the spacious kitchen offers tile counters, stainless steel appliances; a large kitchen island with views of the surrounding pastures and rolling hills. The four bedrooms and 2.5 baths are all located on one main floor. This luxury estate features 2333 sq ft of living space, plus three garage bays. This home is all about the peaceful, serene setting, plus it comes with the bonus of miles and miles of walking and biking trails nearby. Walk to the river from your home for fishing, a family picnic, kayaking, canoeing or simply enjoy the fantastic views and surrounding nature. You won't find another home quite like this. Large three car garage, plus enough driveway parking for 20 cars or more! Schedule your showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$312
Price Per Acre
$296,341
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Security System, Security Gate, Built In Cabinets, Central Vac
REO / Bank Owned
No
Cross Street Address
Hwy 41/Town Center Blvd
Directions
Head north on Hwy 41 from Ave 12, east on Town Center Blvd, right on Rio Mesa, left on Enchanted Hill, right on Creekside, right on Killarney through private gate, third house on the right side of st.
Special Disclosure
Death On Property
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Both
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 692550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 765450 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) >= 2088 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2588 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` = 1716851 OR `props-main`.`id` = 1736482 OR `props-main`.`id` = 1732247 OR `props-main`.`id` = 1733197 OR `props-main`.`id` = 1716815 OR `props-main`.`id` = 1691781 OR `props-main`.`id` = 1717685 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1718634 OR `props-main`.`id` = 1718647 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1735376 OR `props-main`.`id` = 1729258 OR `props-main`.`id` = 1731766 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1712496 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1704029 OR `props-main`.`id` = 1721662 OR `props-main`.`id` = 1722322 OR `props-main`.`id` = 1731613 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1704028 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1719598 OR `props-main`.`id` = 1731689 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1714903 OR `props-main`.`id` = 1722288 OR `props-main`.`id` = 1705650 OR `props-main`.`id` = 1732187 OR `props-main`.`id` = 1722471 OR `props-main`.`id` = 1722207 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1727679 OR `props-main`.`id` = 1732212 OR `props-main`.`id` = 1727715 OR `props-main`.`id` = 1734042 OR `props-main`.`id` = 1722656 OR `props-main`.`id` = 1725593 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1721656 OR `props-main`.`id` = 1731643 OR `props-main`.`id` = 1726279 OR `props-main`.`id` = 1723560 OR `props-main`.`id` = 1701823 OR `props-main`.`id` = 1722147 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1722102 OR `props-main`.`id` = 1731610 OR `props-main`.`id` = 1711144 OR `props-main`.`id` = 1715813 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1702888 OR `props-main`.`id` = 1696084 OR `props-main`.`id` = 1731391 OR `props-main`.`id` = 1731390)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650284' 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();
0
Last modified 2 hours ago Fresno MLS last checked for updates 21 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.
