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
1
Cumulative Days On London
1
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` = 1681156 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1706700 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1702618 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1701596 OR `props-main`.`id` = 1701109 OR `props-main`.`id` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1704547 OR `props-main`.`id` = 1705084 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1702737 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1704483 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1703280 OR `props-main`.`id` = 1706078 OR `props-main`.`id` = 1703352 OR `props-main`.`id` = 1704909 OR `props-main`.`id` = 1704814 OR `props-main`.`id` = 1705575 OR `props-main`.`id` = 1704904 OR `props-main`.`id` = 1704883 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1701631 OR `props-main`.`id` = 1702212 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1703671 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1696246 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1706921 OR `props-main`.`id` = 1679265 OR `props-main`.`id` = 1705158 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` = 1695575 OR `props-main`.`id` = 1701895 OR `props-main`.`id` = 1701896 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1701891 OR `props-main`.`id` = 1701892 OR `props-main`.`id` = 1705219 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1705383 OR `props-main`.`id` = 1701882 OR `props-main`.`id` = 1701873 OR `props-main`.`id` = 1701901 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1702838 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1701880 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1704030 OR `props-main`.`id` = 1704217 OR `props-main`.`id` = 1704441 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1704440 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1704442 OR `props-main`.`id` = 1653256 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-02-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
Courtesy of Sarah Hedrick, Realty Concepts, Ltd. - Fresno - sarahhedrickrealtor@gmail.com Last modified 1 week ago Fresno MLS last checked for updates 18 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.
