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/651809/31612-Duke-Rd/North-Fork/https://www.londonproperties.com/images/props/fresno/full/651809.jpgLondon Properties North Fork Real Estate | 31612 Duke Rd
Courtesy of Manuel Chavez, M. C. Real Estate Corp - [email protected]
The Duke Estate is a beautifully reimagined remodeled Traditional residence in the heart of North Fork. Blending timeless architecture with sophisticated modern touches. Thoughtfully transformed through an extensive renovation, this exceptional estate offers approximately 3,592 square feet with 4 bedrooms and 3 bathrooms, where every detail has been curated to honor its architectural heritage while embracing modern luxury. Set behind mountains, welcomes you with a circular driveway, with effortless indoor-outdoor living. A dramatic entrance introduces expansive living spaces, including a grand living room with new carpet, light fixtures and paint, expansive windows, and a statement brick fireplace, alongside a room designed for an office, or your dream studio.The chef's kitchen serves as the heart of the home, anchored by a spectacular granite island and appointed with premium appliances. Opening seamlessly to the family room, extended cabinetry and a large walk-in pantry. An attached pool house adds exceptional versatility, ideal as a gym, wellness studio, private office, or guest retreat for a true California lifestyle. Four additional en suite bedrooms provide comfort and privacy for family and guests. The Duke Estate presents a rare opportunity to own a turnkey Mountain residence that seamlessly blends with modern refinement and exceptional location on a cul-de-sac, conveniently located for commuting to Fresno, Oakhurst, close to Bass Lake for recreation. Now offered at an exceptional value representing one of the area's most compelling opportunities to acquire a renovated, move-in ready estate.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1970
Region
Mountain
# of Stories
Single Story
Price Per Square Foot
$135
Price Per Acre
$112,009
Days On London
1
Cumulative Days On London
1
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 200
Directions
From CA 41 and Road 200 go east on Road 200, follow Road 200 to Duke Rd, go south on Duke Rd to property
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Electric Appliances, Disposal, Dishwasher, Trash Compactor, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Carpet, Vinyl
# of Fireplaces
1
Exterior
Stucco, Brick
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Solar
No
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
2
APN
060 501 008 000
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
North Fork
School Type 3
Grade School
School Name 3
North Fork
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 509250 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) >= 3342 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3842 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` = 1744633 OR `props-main`.`id` = 1744621 OR `props-main`.`id` = 1747719 OR `props-main`.`id` = 1727233 OR `props-main`.`id` = 1656217 OR `props-main`.`id` = 1746898 OR `props-main`.`id` = 1725656)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651809' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-10' 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 52 minutes 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.
