This beautiful 4-bedroom, 2-bath home has been meticulously cared for and it truly shows. Featuring a wonderful, functional floor plan with inviting living spaces, this home is both comfortable and stylish. Step outside to a backyard oasisperfect for family gatherings, entertaining, or relaxingwhere lemon and mandarin trees are heavy with fruit for you to enjoy. Pride of ownership shines throughout. All financing welcome. Come see it in person before it flies off the market.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2016
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$242
Price Per Acre
$2,835,277
Days On Market
1
Cumulative Days On Market
1
County
Fresno
REO / Bank Owned
No
Cross Street Address
Academy and Fifth
Directions
From academy and 5th. head east on 5th. left on Gardenia. home will be on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 369550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 408450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1359 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1859 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` = 1662278 OR `props-main`.`id` = 1688130 OR `props-main`.`id` = 1695161 OR `props-main`.`id` = 1695830 OR `props-main`.`id` = 1695908 OR `props-main`.`id` = 1699001 OR `props-main`.`id` = 1699007 OR `props-main`.`id` = 1701798 OR `props-main`.`id` = 1689324 OR `props-main`.`id` = 1685678 OR `props-main`.`id` = 1698025 OR `props-main`.`id` = 1698026 OR `props-main`.`id` = 1686142 OR `props-main`.`id` = 1686143 OR `props-main`.`id` = 1697881 OR `props-main`.`id` = 1697882 OR `props-main`.`id` = 1702089)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642008' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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();
5
Similar Properties
$405,900
4
2
1,636
0.12
13343 Fifth St #Lot3
Parlier, CA 93648
$405,900
4
2
1,636
0.12
13379 5th St #Lot6
Parlier, CA 93648
$399,900
4
2
1,544
0.12
13379 Fifth St #Lot6
Parlier, CA 93648
$399,900
4
2
1,544
0.12
13367 5th St #Lot5
Parlier, CA 93648
Courtesy of Flor Gonzalez Espinoza, Realty Concepts, Ltd. - Clovis - [email protected] Last modified 23 hours ago Fresno MLS last checked for updates 56 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.
