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/649783/7280-W-Menlo-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/649783.jpgLondon Properties Fresno Real Estate | 7280 W Menlo Ave
Courtesy of Alice Rocha, Century 21 Select Real Estate - [email protected]
Discover this expansive 3,914 SF residence featuring 4 bedrooms and 3 bathrooms, beautifully updated with luxury finishes, vaulted ceilings, and premium materials throughout. The heart of the home is a chef-inspired kitchen equipped with commercial grade appliances, large walk in pantry quartz countertops, and an oversized center island.Designed for entertaining, the property includes a dedicated theatre/game room, aside from the formal living room , and seamless indoor-outdoor flow to the backyard. The fully fenced 2.3-acre grounds offer immense privacy and versatility, complete with solar, dual HVAC systems, and high-end security features.This unique estate also includes a detached in-law suite, with dedicated private entrance , Expansive detached workshop offers incredible flexibility. The space is divided into several secure, finished storage areas accessible via roll-up doors and is fully equipped with an on-site bathroom and shower, making it an ideal setup for a home business, or private workshop. and a custom-built housing structure for dogs and or animals equipped with its own heating and cooling unit ,The formal dining room features an exquisite, 17 ft custom large quartz dining table physically affixed to structure (tile flooring ) seamlessly bonded to the flooring, serving as a permanent and striking centerpiece for entertaining included in sale of homeAll buyers are expected to conduct their own independent investigations regarding permit status, building codes, and legal usage of these structures. Property sold strictly AS-IS regarding all improvements..
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1978
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$345
Price Per Acre
$586,522
Days On London
45
Cumulative Days On London
45
County
Fresno
Reports Available
Appraisal
Leased Equipment
Solar Panels
Special Features
Security Gate, Other/See Remarks, Horses Allowed
REO / Bank Owned
No
Cross Street Address
W Menlo Ave + N Parkway Dr
Directions
Head N on CA-99 , exit W Herndon ave , turn Left onto Polk Ave , Turn Left on W Menlo Ave
Special Disclosure
See Remrks/Attchmnts
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool, Central Heating, Central Cooling, Floor or Wall Unit
Laundry
Inside, On Lower Level
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop, Kennel, Other/See Remarks
Kitchen
Built In Range/Oven, Gas Appliances, Dishwasher, Microwave, Eating Area, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1281550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1416450 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) >= 3664 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4164 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` = 1747015 OR `props-main`.`id` = 1716816 OR `props-main`.`id` = 1716822 OR `props-main`.`id` = 1744799 OR `props-main`.`id` = 1729354 OR `props-main`.`id` = 1723907 OR `props-main`.`id` = 1731903 OR `props-main`.`id` = 1721346 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1744868 OR `props-main`.`id` = 1726922 OR `props-main`.`id` = 1726942 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1717545 OR `props-main`.`id` = 1732701 OR `props-main`.`id` = 1732728 OR `props-main`.`id` = 1745188 OR `props-main`.`id` = 1745192 OR `props-main`.`id` = 1747704 OR `props-main`.`id` = 1744742 OR `props-main`.`id` = 1725573 OR `props-main`.`id` = 1748168 OR `props-main`.`id` = 1738648 OR `props-main`.`id` = 1742152 OR `props-main`.`id` = 1749839 OR `props-main`.`id` = 1729028 OR `props-main`.`id` = 1746559 OR `props-main`.`id` = 1728517 OR `props-main`.`id` = 1721722 OR `props-main`.`id` = 1732898 OR `props-main`.`id` = 1725666 OR `props-main`.`id` = 1734161 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1748107 OR `props-main`.`id` = 1740677 OR `props-main`.`id` = 1735579 OR `props-main`.`id` = 1736673 OR `props-main`.`id` = 1731930 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1749947 OR `props-main`.`id` = 1709253 OR `props-main`.`id` = 1727523 OR `props-main`.`id` = 1744196 OR `props-main`.`id` = 1703160 OR `props-main`.`id` = 1728743 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1743933 OR `props-main`.`id` = 1708477 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1745845 OR `props-main`.`id` = 1726877 OR `props-main`.`id` = 1719319 OR `props-main`.`id` = 1743374 OR `props-main`.`id` = 1743247 OR `props-main`.`id` = 1738644 OR `props-main`.`id` = 1743478 OR `props-main`.`id` = 1743575 OR `props-main`.`id` = 1728419 OR `props-main`.`id` = 1742775 OR `props-main`.`id` = 256897 OR `props-main`.`id` = 1747284)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649783' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-16' 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 5 hours ago Fresno MLS last checked for updates 22 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.
