Please provide the following information and Eric McCormick will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/11119/eric-mccormick/property/link/fresno/640989/208-S-Hughes-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/640989.jpgLondon Properties Fresno Real Estate | 208 S Hughes Ave
A primary home, an ADU, a shop and plenty of free open space! If you're looking for a home that has some space between neighbors and room for your hobbies, this is your property! The main home features 2 bedrooms and 1 bathroom, the ADU is an updated 1 bedroom 1 bathroom unit with a full kitchen and mini split system. Towards the back there's a 2 story shop with electricity ready for a handyman to work or to be used as storage with still plenty of space to park multiple RV's!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1940
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$378
Price Per Acre
$584,110
Days On Market
1
Cumulative Days On Market
1
County
Fresno
Reports Available
Appraisal
Special Features
Security Gate, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
S Roeding Dr
Directions
From the 180, North on Marks, East on Nielsen, South on Hughes, house is on the right.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 676 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1176 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` = 1679412 OR `props-main`.`id` = 1696214 OR `props-main`.`id` = 1697080 OR `props-main`.`id` = 1697096 OR `props-main`.`id` = 1695178 OR `props-main`.`id` = 1696834 OR `props-main`.`id` = 1663617 OR `props-main`.`id` = 1680817 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1686096 OR `props-main`.`id` = 1697699 OR `props-main`.`id` = 1697772 OR `props-main`.`id` = 1697804 OR `props-main`.`id` = 1696042 OR `props-main`.`id` = 1674219 OR `props-main`.`id` = 1683931 OR `props-main`.`id` = 1683962 OR `props-main`.`id` = 1683964 OR `props-main`.`id` = 1681366 OR `props-main`.`id` = 1681364 OR `props-main`.`id` = 1683960 OR `props-main`.`id` = 1681362 OR `props-main`.`id` = 1683961 OR `props-main`.`id` = 1681344 OR `props-main`.`id` = 1681343 OR `props-main`.`id` = 1683963 OR `props-main`.`id` = 1681342 OR `props-main`.`id` = 1692397 OR `props-main`.`id` = 1666101 OR `props-main`.`id` = 1689996 OR `props-main`.`id` = 1668403 OR `props-main`.`id` = 1683609 OR `props-main`.`id` = 1691243 OR `props-main`.`id` = 1691248 OR `props-main`.`id` = 1697680 OR `props-main`.`id` = 1686728 OR `props-main`.`id` = 1666293 OR `props-main`.`id` = 1688344 OR `props-main`.`id` = 1693804 OR `props-main`.`id` = 1691862 OR `props-main`.`id` = 1681487 OR `props-main`.`id` = 1696428 OR `props-main`.`id` = 1609082 OR `props-main`.`id` = 1656582 OR `props-main`.`id` = 1690750 OR `props-main`.`id` = 1691220 OR `props-main`.`id` = 1654282 OR `props-main`.`id` = 1690827 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1689918 OR `props-main`.`id` = 1694277 OR `props-main`.`id` = 1661123 OR `props-main`.`id` = 1694902 OR `props-main`.`id` = 1677651 OR `props-main`.`id` = 1689173 OR `props-main`.`id` = 1675273 OR `props-main`.`id` = 1665592 OR `props-main`.`id` = 1696751 OR `props-main`.`id` = 1690951 OR `props-main`.`id` = 1687885 OR `props-main`.`id` = 1687886 OR `props-main`.`id` = 1696345 OR `props-main`.`id` = 1687883 OR `props-main`.`id` = 1687884 OR `props-main`.`id` = 1696344 OR `props-main`.`id` = 1669711 OR `props-main`.`id` = 1696436 OR `props-main`.`id` = 1697195 OR `props-main`.`id` = 1697197 OR `props-main`.`id` = 1668261 OR `props-main`.`id` = 1697109 OR `props-main`.`id` = 1690862 OR `props-main`.`id` = 1691617 OR `props-main`.`id` = 1674995 OR `props-main`.`id` = 1675319 OR `props-main`.`id` = 1695861 OR `props-main`.`id` = 1692051 OR `props-main`.`id` = 1690711 OR `props-main`.`id` = 1627834 OR `props-main`.`id` = 1690617 OR `props-main`.`id` = 1692177 OR `props-main`.`id` = 1692182 OR `props-main`.`id` = 1692187 OR `props-main`.`id` = 1692186 OR `props-main`.`id` = 1693560 OR `props-main`.`id` = 1693571 OR `props-main`.`id` = 1693564 OR `props-main`.`id` = 1693578 OR `props-main`.`id` = 1679615 OR `props-main`.`id` = 1666130 OR `props-main`.`id` = 1690615 OR `props-main`.`id` = 1690646)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640989' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-14' 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
$350,000
3
1.5
1,095
0.16
1335 N Esther Way
Fresno, CA 93728
Courtesy of Miguel Gonzalez, Park Place Real Estate - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 20 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.
