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/647523/11027-N-Stanford-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/647523.jpgLondon Properties Clovis Real Estate | 11027 N Stanford Ave
Beautiful and huge open design! Floating staircase with glass-view wine closet! Living room has 25 ft. ceilings and 16 foot glass wall that completely opens to the pool view patio. Linear gas fireplace presented in modern stone. Tile floors downstairs and hardwood upstairs. Gorgeous custom kitchen with Thermador and Signature appliances. Tons of storage in custom floor to ceiling cabinets that surround the stunning farm house sink. Clean mount single-hole kitchen faucet in front of full-cover Neo-style tile backsplash. Large island with one-piece quartz countertop and modern under-mounted sink adorned with beautiful single hole faucet. Floating grand staircase floored with hardwood leads upstairs to open-railed hall for access to the giant primary bedroom and three other large upstairs bedrooms, two of which have bay view windows. Master bedroom has another gas fireplace surrounded by stone. Bed wall has full stone wall with hotel bed lights. Primary bath is huge with dual separate vanities with incredible hammered sinks. Double rainfall shower is more than big enough for two and features frameless glass. Huge master dressing room has built in custom closet storage. Downstairs mother-in-law suite next to the guest bathroom. In the front there is a formal dining room and separate office complimenting the open design. All bathrooms are floor to ceiling tile. Ceiling pop-ups in most rooms. Crown moulding virtually everywhere. Walled and gated huge backyard with pool.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Rural
# of Stories
Two
Price Per Square Foot
$521
Price Per Acre
$817,623
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Isolated Bedroom, Security System, Security Gate, Built In Cabinets, Water Softener, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Copper
Directions
Friant, east on Copper to Stanford
Special Disclosure
Agent/Owner Related
Style
Spanish, Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Lower Level, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1895250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2094750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3582 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4082 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` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 1709662 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1709664 OR `props-main`.`id` = 1719460 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1721891 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1719512 OR `props-main`.`id` = 1704030 OR `props-main`.`id` = 1704441 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1704440 OR `props-main`.`id` = 820696 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1704442 OR `props-main`.`id` = 1722767 OR `props-main`.`id` = 1689446 OR `props-main`.`id` = 1722923 OR `props-main`.`id` = 1699972 OR `props-main`.`id` = 1696333)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647523' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-21' 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
Courtesy of Sean Stevens, Rod Aluisi Real Estate - [email protected] Last modified 4 hours ago Fresno MLS last checked for updates 46 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.
