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
$271
Price Per Acre
$3,798,948
Days On London
21
Cumulative Days On London
21
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) >= 617500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682500 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) >= 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` = 1758708 OR `props-main`.`id` = 1758704 OR `props-main`.`id` = 1758709 OR `props-main`.`id` = 1758705 OR `props-main`.`id` = 1758707 OR `props-main`.`id` = 1758710 OR `props-main`.`id` = 1758706 OR `props-main`.`id` = 1762328 OR `props-main`.`id` = 1756449 OR `props-main`.`id` = 1749116 OR `props-main`.`id` = 1716220 OR `props-main`.`id` = 1755284 OR `props-main`.`id` = 1735506 OR `props-main`.`id` = 1748122)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652582' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-14' 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 2 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.
