Please provide the following information and Leo Estrada will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.leoestrada.com/agent/10384/leo-estrada/property/link/fresno/640465/33238-W-Hidalgo-Ave/Cantua-Creek/https://www.leoestrada.com/images/props/fresno/full/640465.jpgLondon Properties Cantua Creek Real Estate | 33238 W Hidalgo Ave
Leo Estrada559.260.1856lestrada@londonproperties.comEmail Agent
Property Description
Beautifully Updated 3-Bedroom Home on an Oversized Lot. Step into comfort with this freshly renewed 3-bedroom, 2-bath home offering 1,008 sq ft of bright, welcoming living space. Situated on a spacious 10,125 sq ft lot, this property features brand-new interior and exterior paint, modern appliances, redone kitchen and bathrooms, updated flooring and fixtures throughout. This property offers flexibility for outdoor living, gardening, or future additions. Its functional layout and generous space make it an ideal choice for buyers looking for value, comfort, and potential. Don't miss your chance to make this delightful property your own! Bathroom count is different than tax records, if important buyer to verify.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1969
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$248
Price Per Acre
$1,075,301
Days On Market
0
Cumulative Days On Market
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
S Derrick / W Clarkson
Directions
From Derrick/Clarkson, head north on Derrick Ave. Make a Left onto El Progresso Ave. and follow the road until it turns into W Hidalgo. Home will be on the right hand side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 758 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1258 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` = 1685012 OR `props-main`.`id` = 1696217)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640465' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-28' 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 Juan Estrada, London Properties, Ltd. - lestrada@londonproperties.com Last modified 1 day ago Fresno MLS last checked for updates 11 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.
