This two-story former model home offers a practical and well-designed layout with added designer details. The main floor features an open living, dining, and kitchen area that connects to a patio for indoor-outdoor flow, along with a bedroom and full bathroom near on the first floor for added convenience.Upstairs, three bedrooms are arranged around a flexible loft space, providing options for a family room or office. The primary suite includes a bathroom with a walk-in shower featuring tile to the ceiling, dual sinks, and Quartz countertops, as well as a large walk-in closet.The home comes with wood-look tile flooring, blinds and curtains, a fridge, washer and dryer, and completed backyard landscaping for outdoor enjoyment.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2024
Region
Urban
# of Stories
Two
Price Per Square Foot
$238
Price Per Acre
$5,958,365
Days On London
106
Cumulative Days On London
106
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
N/Shepherd & W/Sunnyside
Directions
From the intersection of Shepherd and Sunnyside, north on Sunnyside, around the traffic circle and exit west on Heirloom, right on Marion, left on Plum Tree Ave, left on Argyle, right on Springtime.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740952.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 818947.5 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) >= 3028 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3528 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` = 1726022 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1723131 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1727135 OR `props-main`.`id` = 1721072 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1720324 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1726694 OR `props-main`.`id` = 1725495 OR `props-main`.`id` = 1726921 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1726324 OR `props-main`.`id` = 1721190 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1726089 OR `props-main`.`id` = 1724857 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1722192 OR `props-main`.`id` = 1720820 OR `props-main`.`id` = 1720797 OR `props-main`.`id` = 1724652 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1726715 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1720903 OR `props-main`.`id` = 1722973 OR `props-main`.`id` = 1718204 OR `props-main`.`id` = 1723730 OR `props-main`.`id` = 1722958 OR `props-main`.`id` = 1712606 OR `props-main`.`id` = 1724300 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1725336 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1726815 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1721220 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1724842 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1726901 OR `props-main`.`id` = 1727188 OR `props-main`.`id` = 1722380 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` = 1725036 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1723135 OR `props-main`.`id` = 1719460 OR `props-main`.`id` = 1723137 OR `props-main`.`id` = 1726605 OR `props-main`.`id` = 1723138 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1721891 OR `props-main`.`id` = 1723136 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1723139 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1725140 OR `props-main`.`id` = 1708512 OR `props-main`.`id` = 1709953 OR `props-main`.`id` = 1704030 OR `props-main`.`id` = 1722767 OR `props-main`.`id` = 1722923 OR `props-main`.`id` = 1699972 OR `props-main`.`id` = 1696333)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642977' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-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();
1
Similar Properties
$799,950
5
3
3,501
0.16
1823 Houston Ave
Clovis, CA 93619
Courtesy of Sarah Hedrick, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 2 months ago Fresno MLS last checked for updates 58 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.
