Courtesy of Jason Gobeli, Solid Real Estate Solutions - [email protected]
One-bedroom, one-bath condominium offering 696 square feet on Huntington Boulevard, with a patio overlooking one of Fresno's most recognizable corridors. The open floor plan creates a comfortable and efficient layout, and recent updates include new interior paint, new dishwasher, new garbage disposal, new digital thermostat, updated lighting, and electrical updates. The kitchen includes the range and refrigerator. Additional features include on-site storage, assigned parking space #123, and a nearby gate for convenient street access. Set within a gated community featuring a pool, gym, laundry room, picnic areas, all in a park-like setting. The property also offers convenient access to Downtown Fresno, including nearby business, entertainment, and event venues, while enjoying the character of Huntington Boulevard
Pool, Spa, Club House, Exercise Room, Green Area, Landscape Maint, Gated Community
HOA Dues
320.00
School District
Fresno Unified
School Type 1
High School
School Name 1
Roosevelt
School Type 2
Junior High School
School Name 2
Tehipite
School Type 3
Grade School
School Name 3
Jefferson
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 135850 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 150150 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 446 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 946 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` = 1755892 OR `props-main`.`id` = 1705462 OR `props-main`.`id` = 1724114 OR `props-main`.`id` = 1756210 OR `props-main`.`id` = 1756164 OR `props-main`.`id` = 1721861 OR `props-main`.`id` = 1737101 OR `props-main`.`id` = 1742774 OR `props-main`.`id` = 1684372 OR `props-main`.`id` = 1750468 OR `props-main`.`id` = 1736617 OR `props-main`.`id` = 1755391 OR `props-main`.`id` = 1749538 OR `props-main`.`id` = 1726601 OR `props-main`.`id` = 1744671 OR `props-main`.`id` = 1744963 OR `props-main`.`id` = 1727875 OR `props-main`.`id` = 1761046 OR `props-main`.`id` = 1752148 OR `props-main`.`id` = 1750692 OR `props-main`.`id` = 1739640 OR `props-main`.`id` = 1739638 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1749524 OR `props-main`.`id` = 1726672 OR `props-main`.`id` = 1708219 OR `props-main`.`id` = 1756223 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1735399 OR `props-main`.`id` = 1723668 OR `props-main`.`id` = 1726805 OR `props-main`.`id` = 1758695 OR `props-main`.`id` = 1723354 OR `props-main`.`id` = 1705358 OR `props-main`.`id` = 1757474 OR `props-main`.`id` = 1625610 OR `props-main`.`id` = 1694336 OR `props-main`.`id` = 1756104 OR `props-main`.`id` = 1717138 OR `props-main`.`id` = 1747282 OR `props-main`.`id` = 1755459 OR `props-main`.`id` = 1754429 OR `props-main`.`id` = 1712861 OR `props-main`.`id` = 1729146 OR `props-main`.`id` = 1744670 OR `props-main`.`id` = 1733312 OR `props-main`.`id` = 1726239 OR `props-main`.`id` = 1733117 OR `props-main`.`id` = 1759619 OR `props-main`.`id` = 1758994 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1725809 OR `props-main`.`id` = 1730779 OR `props-main`.`id` = 1760689 OR `props-main`.`id` = 1712377 OR `props-main`.`id` = 194016 OR `props-main`.`id` = 1734718 OR `props-main`.`id` = 1753340 OR `props-main`.`id` = 1718865 OR `props-main`.`id` = 1745524 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1720737 OR `props-main`.`id` = 1738366 OR `props-main`.`id` = 1724053 OR `props-main`.`id` = 1725987 OR `props-main`.`id` = 1755464 OR `props-main`.`id` = 1738717 OR `props-main`.`id` = 1741480 OR `props-main`.`id` = 1665713 OR `props-main`.`id` = 1690346 OR `props-main`.`id` = 1724477 OR `props-main`.`id` = 1725582 OR `props-main`.`id` = 1726084 OR `props-main`.`id` = 1726092 OR `props-main`.`id` = 1726049 OR `props-main`.`id` = 1757407 OR `props-main`.`id` = 1749199 OR `props-main`.`id` = 1724454 OR `props-main`.`id` = 1731476 OR `props-main`.`id` = 1709914 OR `props-main`.`id` = 1742153 OR `props-main`.`id` = 1742181 OR `props-main`.`id` = 1752075 OR `props-main`.`id` = 1738017 OR `props-main`.`id` = 1649227 OR `props-main`.`id` = 232302 OR `props-main`.`id` = 232595 OR `props-main`.`id` = 1755655 OR `props-main`.`id` = 1742836 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1724782 OR `props-main`.`id` = 1719012 OR `props-main`.`id` = 1713995 OR `props-main`.`id` = 1733061 OR `props-main`.`id` = 1752720 OR `props-main`.`id` = 1729269 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1746164 OR `props-main`.`id` = 1723971 OR `props-main`.`id` = 1708178 OR `props-main`.`id` = 1733501 OR `props-main`.`id` = 1726224 OR `props-main`.`id` = 1729481 OR `props-main`.`id` = 1744757 OR `props-main`.`id` = 1746591 OR `props-main`.`id` = 1722408 OR `props-main`.`id` = 1739448 OR `props-main`.`id` = 1746528 OR `props-main`.`id` = 1746588 OR `props-main`.`id` = 1746590 OR `props-main`.`id` = 1753090 OR `props-main`.`id` = 1738719 OR `props-main`.`id` = 1748330 OR `props-main`.`id` = 1745312 OR `props-main`.`id` = 1746172 OR `props-main`.`id` = 1728443 OR `props-main`.`id` = 1743425 OR `props-main`.`id` = 1761494 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1727685 OR `props-main`.`id` = 1732705 OR `props-main`.`id` = 1733497 OR `props-main`.`id` = 1717911 OR `props-main`.`id` = 1685273 OR `props-main`.`id` = 1719404 OR `props-main`.`id` = 1706890 OR `props-main`.`id` = 1706889 OR `props-main`.`id` = 1761812 OR `props-main`.`id` = 1706897 OR `props-main`.`id` = 1748961 OR `props-main`.`id` = 1725079 OR `props-main`.`id` = 1741737 OR `props-main`.`id` = 1694096 OR `props-main`.`id` = 1722624 OR `props-main`.`id` = 1759435 OR `props-main`.`id` = 1684123 OR `props-main`.`id` = 1742027 OR `props-main`.`id` = 1754594 OR `props-main`.`id` = 1725017 OR `props-main`.`id` = 1727820 OR `props-main`.`id` = 1724993 OR `props-main`.`id` = 1725016 OR `props-main`.`id` = 1725745 OR `props-main`.`id` = 1685894 OR `props-main`.`id` = 1749109 OR `props-main`.`id` = 1757889 OR `props-main`.`id` = 1725483 OR `props-main`.`id` = 1744867 OR `props-main`.`id` = 52454 OR `props-main`.`id` = 1724588 OR `props-main`.`id` = 133282 OR `props-main`.`id` = 1673606 OR `props-main`.`id` = 361177 OR `props-main`.`id` = 282686 OR `props-main`.`id` = 1710167 OR `props-main`.`id` = 1749882 OR `props-main`.`id` = 1758779 OR `props-main`.`id` = 1751298 OR `props-main`.`id` = 1720440 OR `props-main`.`id` = 1724030 OR `props-main`.`id` = 1693965 OR `props-main`.`id` = 1711068 OR `props-main`.`id` = 1736766 OR `props-main`.`id` = 1725584 OR `props-main`.`id` = 1759588 OR `props-main`.`id` = 1746239 OR `props-main`.`id` = 1756986 OR `props-main`.`id` = 1694338 OR `props-main`.`id` = 1725353 OR `props-main`.`id` = 1758323 OR `props-main`.`id` = 1758772 OR `props-main`.`id` = 1696772 OR `props-main`.`id` = 1709480 OR `props-main`.`id` = 1748669 OR `props-main`.`id` = 1724907 OR `props-main`.`id` = 1725175 OR `props-main`.`id` = 1680474 OR `props-main`.`id` = 1751346 OR `props-main`.`id` = 1740444 OR `props-main`.`id` = 1705882 OR `props-main`.`id` = 1728504 OR `props-main`.`id` = 1728477 OR `props-main`.`id` = 1723524 OR `props-main`.`id` = 1719417 OR `props-main`.`id` = 1755288 OR `props-main`.`id` = 1724476 OR `props-main`.`id` = 1723372 OR `props-main`.`id` = 1755621 OR `props-main`.`id` = 1755669 OR `props-main`.`id` = 1755611 OR `props-main`.`id` = 1755653 OR `props-main`.`id` = 1723982 OR `props-main`.`id` = 1725991 OR `props-main`.`id` = 1723234 OR `props-main`.`id` = 1683477 OR `props-main`.`id` = 1701990 OR `props-main`.`id` = 1728761 OR `props-main`.`id` = 1739456 OR `props-main`.`id` = 1742136 OR `props-main`.`id` = 1629624 OR `props-main`.`id` = 1728776 OR `props-main`.`id` = 1665854 OR `props-main`.`id` = 1681870 OR `props-main`.`id` = 1716988 OR `props-main`.`id` = 1717071 OR `props-main`.`id` = 1734762 OR `props-main`.`id` = 1748663 OR `props-main`.`id` = 1701932 OR `props-main`.`id` = 1731218 OR `props-main`.`id` = 1726190 OR `props-main`.`id` = 1758206 OR `props-main`.`id` = 1726804)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652558' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-13' 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
Last modified 3 days ago Fresno MLS last checked for updates 15 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.
