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/652582/15641-Oak-Dr/Kerman/https://www.londonproperties.com/images/props/fresno/full/652582.jpgLondon Properties Kerman Real Estate | 15641 Oak Dr
Welcome to this beautifully maintained custom home in one of Kerman's most desirable neighborhoods. Lovingly cared for by its original owners, this home shows with exceptional pride of ownership and feels remarkably fresh from the moment you arrive.Step through the inviting entry into a light-filled living room where large windows frame peaceful views of the backyard, complete with a sparkling pool and soothing waterfallan ideal setting for relaxing or entertaining family and friends.The spacious custom kitchen is designed for both everyday living and special occasions, featuring premium Thermador built-in appliances, including a side-by-side refrigerator, a gas cooktop with four burners and griddle, convection oven, warming drawer, and abundant custom cabinetry.The private primary suite offers a flexible bonus space that can easily serve as a sitting area, home office, nursery, or personal retreat. The luxurious primary bath features a jetted soaking tub and an elegant glass-enclosed shower.Throughout the home, you'll find thoughtfully designed built-in storage that keeps everything organized without sacrificing style.Additional highlights include a whole-home sound system that extends to the backyard, making it easy to enjoy your favorite music while relaxing by the pool.The sellers have especially loved the quiet neighborhood with minimal traffic, and friendly neighbors. It has been the backdrop for many wonderful family memories, and they hope the next owners will enjoy this special home for years to come.LOW Maintenance Yard!!SO Many custom features - A MUST SEE!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Two
Price Per Square Foot
$281
Price Per Acre
$3,945,061
Days On London
1
Cumulative Days On London
1
County
Fresno
Reports Available
Pest, NHD, Prelim Title Report, Seller Disclosure
Special Features
Isolated Bedroom, Security System, Built In Cabinets, Skylight
REO / Bank Owned
No
Cross Street Address
Park
Directions
West on 180 from Fresno, enter Kerman. Make a left on Del Norte, Right on Kearney Blvd. Then make a left on Park, left on Orchard Way and right on Oak.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 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) >= 2150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2650 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` = 1752678 OR `props-main`.`id` = 1753349 OR `props-main`.`id` = 1742205 OR `props-main`.`id` = 1746733 OR `props-main`.`id` = 1748820 OR `props-main`.`id` = 1753882 OR `props-main`.`id` = 1744869 OR `props-main`.`id` = 1720543 OR `props-main`.`id` = 1745278 OR `props-main`.`id` = 1724357 OR `props-main`.`id` = 1747837 OR `props-main`.`id` = 1724358 OR `props-main`.`id` = 1732248 OR `props-main`.`id` = 1747838 OR `props-main`.`id` = 1732261 OR `props-main`.`id` = 1712580 OR `props-main`.`id` = 1707067 OR `props-main`.`id` = 1727586 OR `props-main`.`id` = 1749116 OR `props-main`.`id` = 1716220 OR `props-main`.`id` = 1735506 OR `props-main`.`id` = 1748122 OR `props-main`.`id` = 1752310)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652582' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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
Last modified 2 hours ago Fresno MLS last checked for updates 40 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.
