Welcome to 924 Palm Ave, a beautifully designed single-story home built in 2001, offering 4 bedrooms, 2 bathrooms, and 2,095 square feet of modern living space. This beautiful property also comes with a massive lot size of 9240 with 2 car garage! Garage also features an additional kitchen and storage cabinets! Backyard comes with 2 storage sheds 1 fully custom built. Property features a garden and fenced pet area. Property has a side gate for access to the backyard big enough to fit your RV! Kitchen comes with updated appliances as well as beautiful tile flooring. Home is beautifully landscaped from front to back! Not to mention energy efficent solar panelsThis home is a must-see! Schedule your private showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$219
Price Per Acre
$2,164,074
Days On Market
10
Cumulative Days On Market
10
County
Fresno
REO / Bank Owned
No
Cross Street Address
magnolia
Directions
EXIT 99 Pass Valero and left on first entrance then second house on the right
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 436050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 481950 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) >= 1845 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2345 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` = 1687668 OR `props-main`.`id` = 1674515 OR `props-main`.`id` = 1696878 OR `props-main`.`id` = 1638007 OR `props-main`.`id` = 1683529 OR `props-main`.`id` = 1696622 OR `props-main`.`id` = 1696610 OR `props-main`.`id` = 1691116 OR `props-main`.`id` = 1696626 OR `props-main`.`id` = 1690803 OR `props-main`.`id` = 1694210 OR `props-main`.`id` = 1695082 OR `props-main`.`id` = 1666367 OR `props-main`.`id` = 1691229 OR `props-main`.`id` = 1696125 OR `props-main`.`id` = 1654710 OR `props-main`.`id` = 1684419 OR `props-main`.`id` = 1694237 OR `props-main`.`id` = 1696165 OR `props-main`.`id` = 1684612 OR `props-main`.`id` = 1679530 OR `props-main`.`id` = 1697290 OR `props-main`.`id` = 1665590 OR `props-main`.`id` = 1681207 OR `props-main`.`id` = 1649065)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640023' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-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();
0
Courtesy of Mandesh Singh, Real Broker - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 17 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.
