From Golden West High School, head east on St. John's Parkway. Turn left (north) onto Rio Vista St. Then turn right (east) on Magnolia Ave. Turn Left on N Sol St and Left on Oakridge Ave.
Roof
Composition
Heating
Electric
Cooling
Central Air
# of Main Level Bathrooms
1
Bathrooms Total (Integer)
3
Full Baths
2.5
Full Baths
2
Half Baths
1
Fireplace Y/N
No
Private Pool
No
Spa
No
Utilities
Electricity Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
103 460 044
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417886 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461874 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) >= 1760 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2260 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` = 1739384 OR `props-main`.`id` = 1755485 OR `props-main`.`id` = 1729923 OR `props-main`.`id` = 1729967 OR `props-main`.`id` = 1729921 OR `props-main`.`id` = 1729912 OR `props-main`.`id` = 1746326 OR `props-main`.`id` = 1748889 OR `props-main`.`id` = 1720320 OR `props-main`.`id` = 1719633 OR `props-main`.`id` = 1760880 OR `props-main`.`id` = 1749804 OR `props-main`.`id` = 1746756 OR `props-main`.`id` = 1736560 OR `props-main`.`id` = 1746755 OR `props-main`.`id` = 1752052 OR `props-main`.`id` = 1759882 OR `props-main`.`id` = 1754767 OR `props-main`.`id` = 1751617 OR `props-main`.`id` = 1754802 OR `props-main`.`id` = 1762493 OR `props-main`.`id` = 1763167 OR `props-main`.`id` = 1763465 OR `props-main`.`id` = 1754520 OR `props-main`.`id` = 1697959 OR `props-main`.`id` = 1755436 OR `props-main`.`id` = 1729182 OR `props-main`.`id` = 1741374 OR `props-main`.`id` = 1741418 OR `props-main`.`id` = 1724526 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` = 1729120 OR `props-main`.`id` = 1729401 OR `props-main`.`id` = 1737248 OR `props-main`.`id` = 1697140 OR `props-main`.`id` = 1738145 OR `props-main`.`id` = 1726792 OR `props-main`.`id` = 1747464 OR `props-main`.`id` = 1719338 OR `props-main`.`id` = 1745245 OR `props-main`.`id` = 1740668 OR `props-main`.`id` = 1722867 OR `props-main`.`id` = 1753462 OR `props-main`.`id` = 1754828 OR `props-main`.`id` = 1719039 OR `props-main`.`id` = 1730795 OR `props-main`.`id` = 1749919 OR `props-main`.`id` = 1719026 OR `props-main`.`id` = 1719022 OR `props-main`.`id` = 1734073 OR `props-main`.`id` = 1712782 OR `props-main`.`id` = 1719010 OR `props-main`.`id` = 1762267 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 OR `props-main`.`id` = 1750569 OR `props-main`.`id` = 1758185 OR `props-main`.`id` = 1758175 OR `props-main`.`id` = 1758181 OR `props-main`.`id` = 1758186 OR `props-main`.`id` = 1728621)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240718' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-19' 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();
4
Similar Properties
$449,990
5
3
2,174
0.09
4009 E Oakridge Ave
Visalia, CA 93292
$445,990
4
3
2,010
0.09
3929 E Oakridge Ave
Visalia, CA 93292
$430,990
4
3
1,826
0.09
3945 E Oakridge Ave
Visalia, CA 93292
$430,000
4
3
2,116
0.11
549 S Elverta St
Visalia, CA 93292
Courtesy of Wesley Bennett, BMC Realty Advisors
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.
