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 one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/651512/820-S-Bradley-St/Visalia/https://www.londonproperties.com/images/props/fresno/full/651512.jpgLondon Properties Visalia Real Estate | 820 S Bradley St
Courtesy of Diana Picazo, Century 21 Select Real Estate - [email protected]
Don't miss this beautifully updated home featuring an open-concept floor plan designed for comfortable living and entertaining. The remodeled kitchen boasts stunning granite countertops, stainless steel appliances, and ample cabinet space. Enjoy the cozy fireplace in the living room, updated bathroom, and newer windows that add both style and energy efficiency. The spacious bedrooms provide plenty of room to relax, while the large backyard offers endless possibilities with plenty of fruit trees, complete with abundant storage. A detached 1-bedroom, 1-bath ADU adds incredible value and flexibility for extended family, guests, or rental income potential. Solar helps with energy savings. Schedule your private showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1949
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$349
Price Per Acre
$2,111,260
Days On London
19
Cumulative Days On London
19
County
Tulare
REO / Bank Owned
No
Cross Street Address
E Laurel Ave
Directions
Head East on Tulare Ave, left onto S Burke St, right onto E Laurel Ave, left onto S Bradley St
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
Yes
Solar Type
Power Purchase AGMT
Are there garage spaces?
No
APN
097 152 017
School District
Visalia Schools
School Type 1
High School
School Name 1
Golden West
School Type 2
Junior High School
School Name 2
Valley Oak
School Type 3
Grade School
School Name 3
Pinkham
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 652 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1152 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` = 1737812 OR `props-main`.`id` = 1684940 OR `props-main`.`id` = 1740380 OR `props-main`.`id` = 1738751 OR `props-main`.`id` = 1727175 OR `props-main`.`id` = 1727209 OR `props-main`.`id` = 1727216 OR `props-main`.`id` = 1720054 OR `props-main`.`id` = 1753842 OR `props-main`.`id` = 1726961 OR `props-main`.`id` = 1728960 OR `props-main`.`id` = 1725694 OR `props-main`.`id` = 1746117 OR `props-main`.`id` = 1731803 OR `props-main`.`id` = 1743480 OR `props-main`.`id` = 1725220 OR `props-main`.`id` = 1744361 OR `props-main`.`id` = 1729257 OR `props-main`.`id` = 1733078 OR `props-main`.`id` = 1744542 OR `props-main`.`id` = 1744138 OR `props-main`.`id` = 1745938 OR `props-main`.`id` = 1744544 OR `props-main`.`id` = 1744541 OR `props-main`.`id` = 1744543 OR `props-main`.`id` = 1752196 OR `props-main`.`id` = 1736791 OR `props-main`.`id` = 1744539 OR `props-main`.`id` = 1752071 OR `props-main`.`id` = 1745040 OR `props-main`.`id` = 1709215 OR `props-main`.`id` = 1710056 OR `props-main`.`id` = 1715923 OR `props-main`.`id` = 1728961 OR `props-main`.`id` = 1705113 OR `props-main`.`id` = 1705141 OR `props-main`.`id` = 1704880 OR `props-main`.`id` = 1734271 OR `props-main`.`id` = 1713958 OR `props-main`.`id` = 1739449 OR `props-main`.`id` = 1726669 OR `props-main`.`id` = 1750723 OR `props-main`.`id` = 1728244 OR `props-main`.`id` = 1728437 OR `props-main`.`id` = 1702973 OR `props-main`.`id` = 1709611 OR `props-main`.`id` = 1727248 OR `props-main`.`id` = 1710216 OR `props-main`.`id` = 1737703 OR `props-main`.`id` = 1733286 OR `props-main`.`id` = 1747649 OR `props-main`.`id` = 1753876 OR `props-main`.`id` = 1718626 OR `props-main`.`id` = 1717668 OR `props-main`.`id` = 1746471 OR `props-main`.`id` = 1746462 OR `props-main`.`id` = 1746469 OR `props-main`.`id` = 1746457 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1714942 OR `props-main`.`id` = 1714960 OR `props-main`.`id` = 1732859 OR `props-main`.`id` = 1740777 OR `props-main`.`id` = 1751694 OR `props-main`.`id` = 1735836 OR `props-main`.`id` = 1722865 OR `props-main`.`id` = 1749604 OR `props-main`.`id` = 1753742 OR `props-main`.`id` = 1734489 OR `props-main`.`id` = 1748985 OR `props-main`.`id` = 1732387 OR `props-main`.`id` = 1737666 OR `props-main`.`id` = 1753371 OR `props-main`.`id` = 1751677 OR `props-main`.`id` = 1729842 OR `props-main`.`id` = 1730758 OR `props-main`.`id` = 1748356 OR `props-main`.`id` = 1753975 OR `props-main`.`id` = 1738870 OR `props-main`.`id` = 1728873 OR `props-main`.`id` = 1752915 OR `props-main`.`id` = 1734540 OR `props-main`.`id` = 1728698 OR `props-main`.`id` = 1732893 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1737629 OR `props-main`.`id` = 1746917 OR `props-main`.`id` = 1739384 OR `props-main`.`id` = 1746136 OR `props-main`.`id` = 1747020 OR `props-main`.`id` = 1747011 OR `props-main`.`id` = 1747014 OR `props-main`.`id` = 1747369 OR `props-main`.`id` = 1752681 OR `props-main`.`id` = 1752700 OR `props-main`.`id` = 1752703 OR `props-main`.`id` = 1752680 OR `props-main`.`id` = 1753741 OR `props-main`.`id` = 1729923 OR `props-main`.`id` = 1729967 OR `props-main`.`id` = 1729921 OR `props-main`.`id` = 1729912 OR `props-main`.`id` = 1727907 OR `props-main`.`id` = 1746081 OR `props-main`.`id` = 1746083 OR `props-main`.`id` = 1746151 OR `props-main`.`id` = 1724414 OR `props-main`.`id` = 1735853 OR `props-main`.`id` = 1748526 OR `props-main`.`id` = 1752490 OR `props-main`.`id` = 1748889 OR `props-main`.`id` = 1736949 OR `props-main`.`id` = 1752341 OR `props-main`.`id` = 1737702 OR `props-main`.`id` = 1720320 OR `props-main`.`id` = 1719633 OR `props-main`.`id` = 1728195 OR `props-main`.`id` = 1733869 OR `props-main`.`id` = 1737696 OR `props-main`.`id` = 1722154 OR `props-main`.`id` = 1749804 OR `props-main`.`id` = 1732301 OR `props-main`.`id` = 1736560 OR `props-main`.`id` = 1732341 OR `props-main`.`id` = 1737665 OR `props-main`.`id` = 1737698 OR `props-main`.`id` = 1741456 OR `props-main`.`id` = 1727558 OR `props-main`.`id` = 1749368 OR `props-main`.`id` = 1719888 OR `props-main`.`id` = 1737645 OR `props-main`.`id` = 1700903 OR `props-main`.`id` = 1732771 OR `props-main`.`id` = 1737699 OR `props-main`.`id` = 1737673 OR `props-main`.`id` = 1751617 OR `props-main`.`id` = 1744778 OR `props-main`.`id` = 1726328 OR `props-main`.`id` = 1742148 OR `props-main`.`id` = 1703300 OR `props-main`.`id` = 1697959 OR `props-main`.`id` = 1743708 OR `props-main`.`id` = 1737675 OR `props-main`.`id` = 1754121 OR `props-main`.`id` = 1741415 OR `props-main`.`id` = 1742515 OR `props-main`.`id` = 1729182 OR `props-main`.`id` = 1741374 OR `props-main`.`id` = 1741418 OR `props-main`.`id` = 1724526 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1741451 OR `props-main`.`id` = 1741481 OR `props-main`.`id` = 1744703 OR `props-main`.`id` = 1744661 OR `props-main`.`id` = 1719429 OR `props-main`.`id` = 1723428 OR `props-main`.`id` = 1753178 OR `props-main`.`id` = 1752735 OR `props-main`.`id` = 1729120 OR `props-main`.`id` = 1729401 OR `props-main`.`id` = 1697140 OR `props-main`.`id` = 1745412 OR `props-main`.`id` = 1727517 OR `props-main`.`id` = 1738145 OR `props-main`.`id` = 1749170 OR `props-main`.`id` = 1753177 OR `props-main`.`id` = 1727898 OR `props-main`.`id` = 1749133 OR `props-main`.`id` = 1715935 OR `props-main`.`id` = 1738746 OR `props-main`.`id` = 1726792 OR `props-main`.`id` = 1747464 OR `props-main`.`id` = 1719338 OR `props-main`.`id` = 1712593 OR `props-main`.`id` = 1741079 OR `props-main`.`id` = 1736104 OR `props-main`.`id` = 1736909 OR `props-main`.`id` = 1728949 OR `props-main`.`id` = 1745245 OR `props-main`.`id` = 1751443 OR `props-main`.`id` = 1740668 OR `props-main`.`id` = 1704319 OR `props-main`.`id` = 1753462 OR `props-main`.`id` = 1738468 OR `props-main`.`id` = 1738016 OR `props-main`.`id` = 1749528 OR `props-main`.`id` = 1752572 OR `props-main`.`id` = 1749919 OR `props-main`.`id` = 1728401 OR `props-main`.`id` = 1728399 OR `props-main`.`id` = 1704019 OR `props-main`.`id` = 1722452 OR `props-main`.`id` = 1749644 OR `props-main`.`id` = 1749798 OR `props-main`.`id` = 1745663 OR `props-main`.`id` = 1746521)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651512' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-26' 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 2 weeks 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.
