Please provide the following information and Jasmin Quintana will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.quintanahomes.com/agent/19708/jasmin-quintana/property/link/fresno/643468/8020-N-Angus-St/Fresno/Woodward-Park/https://www.quintanahomes.com/images/props/fresno/full/643468.jpgLondon Properties Fresno Real Estate | 8020 N Angus St
This home offers immense potential in a highly desirable location near the River Park Shopping Center. Featuring a flexible floor plan with multiple living spaces, the layout lends itself well to a variety of lifestyleswhether you need room to spread out, work from home, or create separate entertaining areas. The expansive primary suite includes a private en suite bathroom and generous space to unwind. Situated on a large lot, the property provides abundant parking and convenient access to the backyard, making it ideal for trailers, recreational vehicles, or additional outdoor uses. Located within the award-winning Clovis Unified School District, this property presents a rare opportunity to customize and add value in a location that offers both convenience and long-term appeal.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Urban
# of Stories
Two
Price Per Square Foot
$228
Price Per Acre
$3,122,731
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Nees/ Fresno
Directions
From Nees and Fresno. East on Nees. Left on Angus. Left on Nees, Right on Angus.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1638 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2138 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` = 1706099 OR `props-main`.`id` = 1704798 OR `props-main`.`id` = 1706039 OR `props-main`.`id` = 1697378 OR `props-main`.`id` = 1703850 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1689192 OR `props-main`.`id` = 1689729 OR `props-main`.`id` = 1704420 OR `props-main`.`id` = 1696769 OR `props-main`.`id` = 1704511 OR `props-main`.`id` = 1680269 OR `props-main`.`id` = 1698732 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1696507 OR `props-main`.`id` = 1696615 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1702619 OR `props-main`.`id` = 1701476 OR `props-main`.`id` = 1698752 OR `props-main`.`id` = 1705576 OR `props-main`.`id` = 1697718 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1696465 OR `props-main`.`id` = 1702968 OR `props-main`.`id` = 1703769 OR `props-main`.`id` = 1701542 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1703344 OR `props-main`.`id` = 1688322 OR `props-main`.`id` = 1706790 OR `props-main`.`id` = 1678582 OR `props-main`.`id` = 1660905 OR `props-main`.`id` = 1702438 OR `props-main`.`id` = 1674615 OR `props-main`.`id` = 1706872 OR `props-main`.`id` = 1701234 OR `props-main`.`id` = 1688764 OR `props-main`.`id` = 1693642 OR `props-main`.`id` = 1694874 OR `props-main`.`id` = 1701233 OR `props-main`.`id` = 1702541 OR `props-main`.`id` = 1697236 OR `props-main`.`id` = 1706030 OR `props-main`.`id` = 1690962 OR `props-main`.`id` = 1702063 OR `props-main`.`id` = 1703107 OR `props-main`.`id` = 1705061 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1704227 OR `props-main`.`id` = 1693947 OR `props-main`.`id` = 1671794 OR `props-main`.`id` = 1702464 OR `props-main`.`id` = 186738 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 1703333 OR `props-main`.`id` = 1704139 OR `props-main`.`id` = 1705386 OR `props-main`.`id` = 1704570 OR `props-main`.`id` = 1696501 OR `props-main`.`id` = 1707179 OR `props-main`.`id` = 1704852 OR `props-main`.`id` = 1696890 OR `props-main`.`id` = 1697786 OR `props-main`.`id` = 1688804 OR `props-main`.`id` = 1703409 OR `props-main`.`id` = 1703509 OR `props-main`.`id` = 1705441 OR `props-main`.`id` = 1691565 OR `props-main`.`id` = 1679036 OR `props-main`.`id` = 1706667 OR `props-main`.`id` = 1706855 OR `props-main`.`id` = 1679646 OR `props-main`.`id` = 1698489 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1696173 OR `props-main`.`id` = 1697196 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1704485 OR `props-main`.`id` = 1697072 OR `props-main`.`id` = 1702373 OR `props-main`.`id` = 1707183 OR `props-main`.`id` = 1692080 OR `props-main`.`id` = 1702844 OR `props-main`.`id` = 1703048 OR `props-main`.`id` = 1703130 OR `props-main`.`id` = 1703141 OR `props-main`.`id` = 1703118 OR `props-main`.`id` = 1703440 OR `props-main`.`id` = 1703833 OR `props-main`.`id` = 1703689 OR `props-main`.`id` = 1706657 OR `props-main`.`id` = 1689221 OR `props-main`.`id` = 1702701 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1706703 OR `props-main`.`id` = 1706079 OR `props-main`.`id` = 1705083 OR `props-main`.`id` = 1684568 OR `props-main`.`id` = 1703827 OR `props-main`.`id` = 1688809 OR `props-main`.`id` = 1695971 OR `props-main`.`id` = 1705110 OR `props-main`.`id` = 1702544 OR `props-main`.`id` = 1702470 OR `props-main`.`id` = 1694626 OR `props-main`.`id` = 1707031 OR `props-main`.`id` = 1702376 OR `props-main`.`id` = 1665746 OR `props-main`.`id` = 1698125 OR `props-main`.`id` = 1704349 OR `props-main`.`id` = 1700078 OR `props-main`.`id` = 1695705 OR `props-main`.`id` = 1703612 OR `props-main`.`id` = 1699131 OR `props-main`.`id` = 1703683 OR `props-main`.`id` = 1699973 OR `props-main`.`id` = 1696124 OR `props-main`.`id` = 1695976 OR `props-main`.`id` = 1664386 OR `props-main`.`id` = 1664016 OR `props-main`.`id` = 1663479 OR `props-main`.`id` = 1704613 OR `props-main`.`id` = 1704973 OR `props-main`.`id` = 1699179 OR `props-main`.`id` = 1706797 OR `props-main`.`id` = 1684858 OR `props-main`.`id` = 1698783 OR `props-main`.`id` = 1698764 OR `props-main`.`id` = 1701265 OR `props-main`.`id` = 1665791 OR `props-main`.`id` = 1707035 OR `props-main`.`id` = 1706860 OR `props-main`.`id` = 1685253 OR `props-main`.`id` = 1685217 OR `props-main`.`id` = 1692235 OR `props-main`.`id` = 1702799 OR `props-main`.`id` = 1705583 OR `props-main`.`id` = 1693659 OR `props-main`.`id` = 1691903 OR `props-main`.`id` = 1683361 OR `props-main`.`id` = 1667858 OR `props-main`.`id` = 1678833 OR `props-main`.`id` = 1698509 OR `props-main`.`id` = 1698512 OR `props-main`.`id` = 1698504 OR `props-main`.`id` = 1690755 OR `props-main`.`id` = 1703260 OR `props-main`.`id` = 1697037 OR `props-main`.`id` = 1705879 OR `props-main`.`id` = 1678412 OR `props-main`.`id` = 1696533 OR `props-main`.`id` = 1703290)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643468' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-10' 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
$427,500
3
2.75
1,811
0.12
364 E Marwood Ln
Fresno, CA 93720
Courtesy of Karen Johnson, Realty Concepts, Ltd. - Clovis - karen@realtyconcepts.com Last modified 4 days ago Fresno MLS last checked for updates 45 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.
