This beautifully upgraded single story home offers an open floor plan with a great room, formal dining room and breakfast nook which creates a comfortable and cohesive living environment in a top-rated school district. Wood and tile flooring throughout with no carpet, ceiling fans in every room. Smart home items include apps for the entry/outside garage lights and an Ecobee thermostat. The kitchen showcases GE Monogram Series appliances to make gourmet meals with ease. Advantium microwave & convection oven, warming drawer and wine/beverage refrigerator. Retreat to the isolated owner's ensuite that has a sitting area, access to the back patio, his/hers walk-in closets, spa jacuzzi tub and stand alone shower.The backyard is a true standout- Expansive pergola with a large fan, extensive misting system, anda low-maintenance SynLawn for year-round enjoyment. Outdoor cooking enthusiasts will love the impressive set up with the FireMagic BBQ which has a rotisserie attachment and is also a smoker, the Memphis Pellet BBQ, EVO flattop grill and Big Green Egg Smoker. Included is a mini fridge, and storage in the outdoor kitchen. No propane needed as there is natural gas for the appliances.Rare opportunity to own a move-in ready home with exceptional amenities, indoor comfort, and outdoor entertaining appeal!https://visithome.ai/eXmY7A6gEnasJva5EyViBc?mu=ft
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$258
Price Per Acre
$3,293,886
Days On London
19
Cumulative Days On London
19
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Security Gate, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Herndon/Temperance
Directions
E on Herndon, right on McKelvy, follow until it turns into Magill.
Unit Description
Ground Floor
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Lower Level
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas 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) >= 634600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 701400 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) >= 2339 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2839 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` = 1739238 OR `props-main`.`id` = 1739294 OR `props-main`.`id` = 1770414 OR `props-main`.`id` = 1779351 OR `props-main`.`id` = 1762755 OR `props-main`.`id` = 1761281 OR `props-main`.`id` = 1761282 OR `props-main`.`id` = 1762766 OR `props-main`.`id` = 1762796 OR `props-main`.`id` = 1763606 OR `props-main`.`id` = 1754724 OR `props-main`.`id` = 1776402 OR `props-main`.`id` = 1728339 OR `props-main`.`id` = 1739538 OR `props-main`.`id` = 1763416 OR `props-main`.`id` = 1758313 OR `props-main`.`id` = 1750048 OR `props-main`.`id` = 1764347 OR `props-main`.`id` = 1764368 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1778416 OR `props-main`.`id` = 1770199 OR `props-main`.`id` = 1745482 OR `props-main`.`id` = 1744609 OR `props-main`.`id` = 1776705 OR `props-main`.`id` = 1742059 OR `props-main`.`id` = 1728554 OR `props-main`.`id` = 1765397 OR `props-main`.`id` = 1774616 OR `props-main`.`id` = 1774204 OR `props-main`.`id` = 1774225 OR `props-main`.`id` = 1774068 OR `props-main`.`id` = 1703700 OR `props-main`.`id` = 1776150 OR `props-main`.`id` = 1770908 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1760126 OR `props-main`.`id` = 1762270 OR `props-main`.`id` = 1768633 OR `props-main`.`id` = 1766943 OR `props-main`.`id` = 1754748 OR `props-main`.`id` = 1754671 OR `props-main`.`id` = 1761187 OR `props-main`.`id` = 1761216 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1775594 OR `props-main`.`id` = 1775596 OR `props-main`.`id` = 1775597 OR `props-main`.`id` = 1775757 OR `props-main`.`id` = 1774599 OR `props-main`.`id` = 1755156 OR `props-main`.`id` = 1770504 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1771441 OR `props-main`.`id` = 1760610 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1759363 OR `props-main`.`id` = 1759398 OR `props-main`.`id` = 1778114 OR `props-main`.`id` = 1779033 OR `props-main`.`id` = 1766614 OR `props-main`.`id` = 1749731 OR `props-main`.`id` = 1763066 OR `props-main`.`id` = 1763041 OR `props-main`.`id` = 1770964 OR `props-main`.`id` = 1746951 OR `props-main`.`id` = 1771194 OR `props-main`.`id` = 1749154 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1771017 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1769009 OR `props-main`.`id` = 1777769 OR `props-main`.`id` = 1770884 OR `props-main`.`id` = 1725062 OR `props-main`.`id` = 1766894 OR `props-main`.`id` = 1761810 OR `props-main`.`id` = 1757662 OR `props-main`.`id` = 1761462 OR `props-main`.`id` = 1769035 OR `props-main`.`id` = 1770257 OR `props-main`.`id` = 1770016 OR `props-main`.`id` = 1753004 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1774842 OR `props-main`.`id` = 1774926 OR `props-main`.`id` = 1774502 OR `props-main`.`id` = 1767577 OR `props-main`.`id` = 1751330 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1761852 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1774181 OR `props-main`.`id` = 1775074 OR `props-main`.`id` = 1736632 OR `props-main`.`id` = 1759439 OR `props-main`.`id` = 1761754 OR `props-main`.`id` = 1755862 OR `props-main`.`id` = 1771476 OR `props-main`.`id` = 1758747 OR `props-main`.`id` = 1763285 OR `props-main`.`id` = 1775041 OR `props-main`.`id` = 1771036 OR `props-main`.`id` = 1750648 OR `props-main`.`id` = 1750780 OR `props-main`.`id` = 1744938 OR `props-main`.`id` = 1730174 OR `props-main`.`id` = 1754527 OR `props-main`.`id` = 1752922 OR `props-main`.`id` = 1745339 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1773783 OR `props-main`.`id` = 1749995 OR `props-main`.`id` = 1739362 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1772093 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1735948 OR `props-main`.`id` = 1752236 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1746896 OR `props-main`.`id` = 1777077 OR `props-main`.`id` = 1775562 OR `props-main`.`id` = 1745941)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654549' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-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();
3
Similar Properties
$695,000
4
3
2,662
0.14
3036 Keats Ave
Clovis, CA 93619
$685,000
4
3
2,483
0.20
2055 Bedford Ave
Clovis, CA 93611
$674,900
5
3
2,738
0.18
2433 Twain Ave
Clovis, CA 93611
Last modified 3 days 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.
