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/642937/4280-Ipsen/Le-Grand/https://www.londonproperties.com/images/props/fresno/full/642937.jpgLondon Properties Le Grand Real Estate | 4280 Ipsen
Courtesy of Matthew Kinsley, Zuffalo Real Estate - [email protected]
Combined 6,369 sq ft gated ranchette estate on nearly 39 acres featuring a 3,970 sq ft main residence, 2,129 sq ft detached ADU/game room, and 270 sq ft pool house. Designed for lifestyle and flexibility, the property offers 3 bedrooms, 4 baths, office/gym, open entertaining kitchen with walk-in commercial refrigerator, walk-in pantry/cooler, and built-in Jenn-Air units. Resort-style amenities include in-ground pool, full-size lighted tennis court, 40x60 shop, 4-stall horse paddock, covered patio, landscaped yard, and multiple storage buildings. Improvements sit on approx. 3.25 fenced acres with remaining prime Class I and II farmland ideal for equestrian, agricultural, or expansion use. Adjoining 28.7-acre parcel with three income-producing rental homes available separately. Rare gated country compound with lifestyle, land, and long-term value.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1993
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$378
Price Per Acre
$38,505
Days On London
132
Cumulative Days On London
132
County
Merced
REO / Bank Owned
No
Cross Street Address
Le Grand Road
Directions
From Highway 99, take the Minturn Road exit and head towards Le Grand. Take a right on Le Grand road then a right on Ipsen.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Both
Primary Bedroom Level
Main
Exterior
Wood
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?
No
APN
068 320 022 000
School District
Le Grand
School Type 1
High School
School Name 1
Le Grand Union
School Type 2
Junior High School
School Name 2
Le Grand
School Type 3
Grade School
School Name 3
Le Grand Elem
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1424050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1573950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3720 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4220 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` = 1650877 OR `props-main`.`id` = 1723276 OR `props-main`.`id` = 1714885 OR `props-main`.`id` = 1705457 OR `props-main`.`id` = 1705440 OR `props-main`.`id` = 1725716 OR `props-main`.`id` = 1704845 OR `props-main`.`id` = 1704630 OR `props-main`.`id` = 1704651 OR `props-main`.`id` = 1716520 OR `props-main`.`id` = 1724129 OR `props-main`.`id` = 1729576 OR `props-main`.`id` = 1729577 OR `props-main`.`id` = 1729871 OR `props-main`.`id` = 1724018 OR `props-main`.`id` = 1622808 OR `props-main`.`id` = 1714120 OR `props-main`.`id` = 1703991 OR `props-main`.`id` = 1690276 OR `props-main`.`id` = 1687688 OR `props-main`.`id` = 1646096 OR `props-main`.`id` = 1731329)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642937' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 1 month ago Fresno MLS last checked for updates 20 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.
