Courtesy of Linda Nielsen, Harness Realty - Kingsburg - [email protected]
A truly unique propertycome see it for yourself. Thoughtfully designed landscaping surrounds this home, creating a lush, private setting filled with a variety of distinctive plants and mature greenery in both the front and back yards.Inside, the spacious family/dining room is the heart of the home, anchored by a striking floor‑to‑ceiling rock fireplace. Three French doors open directly to the backyard, where an oversized pool offers the perfect backdrop for entertaining and large gatherings.The kitchen includes an upgraded gas range and dishwasher, with a generously sized laundry room conveniently located just off the kitchen area. Near the entry, a separate sitting room provides an ideal space for an office or reading room.The home currently features three bedrooms, with one bedroom opens to the primary suite to create a large craft or office area. This space can easily be converted back to a full bedroom if desired. The primary bathroom was remodeled to provide additional room and an expanded closet.Major system updates include a new roof and purchased solar installed approximately 10 years ago, a replaced A/C unit in 2013, and a new pool filtration system in 2024.This property is easy to showcall or text for access.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1973
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$245
Price Per Acre
$2,479,339
Days On London
40
Cumulative Days On London
40
County
Fresno
REO / Bank Owned
No
Cross Street Address
Winter Street
Directions
Sierra Street turn north on 18th turn right on Winter Street. Follow the curve, which is 23rd Avenue. House will be on your right.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 456000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 504000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1712 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2212 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` = 1657301 OR `props-main`.`id` = 1657541 OR `props-main`.`id` = 1680178 OR `props-main`.`id` = 1680173 OR `props-main`.`id` = 115916 OR `props-main`.`id` = 1713577 OR `props-main`.`id` = 1731496 OR `props-main`.`id` = 1001782 OR `props-main`.`id` = 1717517 OR `props-main`.`id` = 1731533 OR `props-main`.`id` = 1720109 OR `props-main`.`id` = 1707887 OR `props-main`.`id` = 1727283 OR `props-main`.`id` = 1727315 OR `props-main`.`id` = 1722843 OR `props-main`.`id` = 1715842 OR `props-main`.`id` = 1726540 OR `props-main`.`id` = 1731695 OR `props-main`.`id` = 1723472 OR `props-main`.`id` = 1725462 OR `props-main`.`id` = 1725480 OR `props-main`.`id` = 1726164 OR `props-main`.`id` = 1726129 OR `props-main`.`id` = 1722092 OR `props-main`.`id` = 1731609 OR `props-main`.`id` = 1728420 OR `props-main`.`id` = 1724795 OR `props-main`.`id` = 1731605 OR `props-main`.`id` = 1731745 OR `props-main`.`id` = 1689823 OR `props-main`.`id` = 1691739 OR `props-main`.`id` = 1727950 OR `props-main`.`id` = 1731731 OR `props-main`.`id` = 235510 OR `props-main`.`id` = 1732854 OR `props-main`.`id` = 1723882 OR `props-main`.`id` = 1728486 OR `props-main`.`id` = 1700911 OR `props-main`.`id` = 1721267 OR `props-main`.`id` = 1721274 OR `props-main`.`id` = 1717730 OR `props-main`.`id` = 1701998 OR `props-main`.`id` = 1724770 OR `props-main`.`id` = 1726652 OR `props-main`.`id` = 1731047 OR `props-main`.`id` = 1731159 OR `props-main`.`id` = 1708386 OR `props-main`.`id` = 1688521 OR `props-main`.`id` = 1726432 OR `props-main`.`id` = 1725565 OR `props-main`.`id` = 1728847 OR `props-main`.`id` = 1728921 OR `props-main`.`id` = 1721620 OR `props-main`.`id` = 1729394 OR `props-main`.`id` = 1731575 OR `props-main`.`id` = 1723198 OR `props-main`.`id` = 1716176 OR `props-main`.`id` = 1720412 OR `props-main`.`id` = 1724174)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647774' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-05' 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
$499,000
3
2
1,730
0.16
2952 25Th Ave
Kingsburg, CA 93631
Last modified 1 day 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.
