Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and Adriana Bourdeau and Orlando Hernandez will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.abluxuryrealestate.com/agent/30838/adrianabourdeau-andorlandohernandez/property/link/fresno/636268/410-S-Hughes-Ave/Fresno/https://www.abluxuryrealestate.com/images/props/fresno/full/636268.jpgLondon Properties Fresno Real Estate | 410 S Hughes Ave
Do not miss out on this property. Looking for larger family or even investor to rent out. Two dwellings on the property accommodate any size family or multifamily living. Main house features three bed and one bath. Accessory building separate features its own kitchen, living, and bed bath. There is additional space in back that can allow for another ADU to be built or some pace to have a vegetable garden. Close proximity to 180 freeway can take you to Fresno or to Kerman. Schedule your showing with agent.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1950
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$181
Price Per Acre
$1,217,812
Days On Market
8
Cumulative Days On Market
8
County
Fresno
REO / Bank Owned
No
Cross Street Address
Roeding Ave
Directions
Off Marks and 180. North on Marks. Right on Ray Johnson Rd around bend and left on Hughes.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 597550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 660450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3219 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3719 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` = 1660692 OR `props-main`.`id` = 1679771 OR `props-main`.`id` = 1680569 OR `props-main`.`id` = 1678893 OR `props-main`.`id` = 1666477 OR `props-main`.`id` = 1651756 OR `props-main`.`id` = 1679412 OR `props-main`.`id` = 1666004 OR `props-main`.`id` = 1681261 OR `props-main`.`id` = 1664684 OR `props-main`.`id` = 1664635 OR `props-main`.`id` = 1663617 OR `props-main`.`id` = 1680817 OR `props-main`.`id` = 1655543 OR `props-main`.`id` = 1664573 OR `props-main`.`id` = 1666312 OR `props-main`.`id` = 1679392 OR `props-main`.`id` = 1664505 OR `props-main`.`id` = 1667374 OR `props-main`.`id` = 1683717 OR `props-main`.`id` = 1674219 OR `props-main`.`id` = 1671333 OR `props-main`.`id` = 1678535 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` = 1678672 OR `props-main`.`id` = 1676898 OR `props-main`.`id` = 1666101 OR `props-main`.`id` = 1666227 OR `props-main`.`id` = 1668403 OR `props-main`.`id` = 1683229 OR `props-main`.`id` = 1673836 OR `props-main`.`id` = 1661987 OR `props-main`.`id` = 1666293 OR `props-main`.`id` = 1658369 OR `props-main`.`id` = 1681487 OR `props-main`.`id` = 1665859 OR `props-main`.`id` = 1609082 OR `props-main`.`id` = 1656582 OR `props-main`.`id` = 1656572 OR `props-main`.`id` = 1654282 OR `props-main`.`id` = 1666331 OR `props-main`.`id` = 1679054 OR `props-main`.`id` = 1642729 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1680575 OR `props-main`.`id` = 1661123 OR `props-main`.`id` = 1679247 OR `props-main`.`id` = 1679804 OR `props-main`.`id` = 1677651 OR `props-main`.`id` = 1677185 OR `props-main`.`id` = 1671129 OR `props-main`.`id` = 1648888 OR `props-main`.`id` = 1675273 OR `props-main`.`id` = 1665592 OR `props-main`.`id` = 1655930 OR `props-main`.`id` = 1655921 OR `props-main`.`id` = 1653008 OR `props-main`.`id` = 1653014 OR `props-main`.`id` = 1662072 OR `props-main`.`id` = 1681852 OR `props-main`.`id` = 1680405 OR `props-main`.`id` = 1683023 OR `props-main`.`id` = 1669711 OR `props-main`.`id` = 1622544 OR `props-main`.`id` = 1596001 OR `props-main`.`id` = 1613690 OR `props-main`.`id` = 1678047 OR `props-main`.`id` = 1668261 OR `props-main`.`id` = 1668125 OR `props-main`.`id` = 1665833 OR `props-main`.`id` = 1676578 OR `props-main`.`id` = 1683908 OR `props-main`.`id` = 1683608 OR `props-main`.`id` = 1671589 OR `props-main`.`id` = 1674995 OR `props-main`.`id` = 1681271 OR `props-main`.`id` = 1678765 OR `props-main`.`id` = 1679662 OR `props-main`.`id` = 1679418 OR `props-main`.`id` = 1679202 OR `props-main`.`id` = 1679996 OR `props-main`.`id` = 1627834 OR `props-main`.`id` = 1680707 OR `props-main`.`id` = 1662301 OR `props-main`.`id` = 1652427 OR `props-main`.`id` = 1656512 OR `props-main`.`id` = 1656506 OR `props-main`.`id` = 1679615 OR `props-main`.`id` = 1666130 OR `props-main`.`id` = 1665593 OR `props-main`.`id` = 1684396)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636268' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-07' 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 Jason Lai, RE/MAX Gold - Clovis - jasonlregold@gmail.com Last modified 1 week ago Fresno MLS last checked for updates 50 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.
