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/tulare/241023/141-N-Waukesha-St/Porterville/https://www.londonproperties.com/images/props/tulare/full/241023.jpgLondon Properties Porterville Real Estate | 141 N Waukesha St
Exit Olive Ave from State Route 65. Turn West onto Olive Ave. Turn right onto N. Prospect St., and then Left onto Tomah Ave. Then turn Right onto Waukesha St. home will be located on the lefthand side
Roof
Metal
Heating
Natural Gas
Cooling
Evaporative Cooling
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Common Walls
No Common Walls
Private Pool
No
Spa
No
Utilities
Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
1.0
APN
251 271 016 000
Lot Dimensions
48ft x 138ft
Horse Property
No
Zoning Description
RS-2
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 123499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 136498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 500 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1000 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` = 1751661 OR `props-main`.`id` = 1770795 OR `props-main`.`id` = 1766150 OR `props-main`.`id` = 1719879 OR `props-main`.`id` = 1766145 OR `props-main`.`id` = 1766276 OR `props-main`.`id` = 1753740 OR `props-main`.`id` = 1766295 OR `props-main`.`id` = 1771136 OR `props-main`.`id` = 1767139 OR `props-main`.`id` = 1767329 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1766279 OR `props-main`.`id` = 1766141 OR `props-main`.`id` = 1749496 OR `props-main`.`id` = 1727490 OR `props-main`.`id` = 1755418 OR `props-main`.`id` = 1752325 OR `props-main`.`id` = 1750991 OR `props-main`.`id` = 1726363 OR `props-main`.`id` = 1755398 OR `props-main`.`id` = 1750558 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1755427 OR `props-main`.`id` = 1755407 OR `props-main`.`id` = 1735547 OR `props-main`.`id` = 1755478 OR `props-main`.`id` = 1755470 OR `props-main`.`id` = 1755473 OR `props-main`.`id` = 1757747 OR `props-main`.`id` = 1769740 OR `props-main`.`id` = 1736980 OR `props-main`.`id` = 1751773 OR `props-main`.`id` = 1721490 OR `props-main`.`id` = 1764621 OR `props-main`.`id` = 1720077 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1720203 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1764611 OR `props-main`.`id` = 1764625 OR `props-main`.`id` = 1761670 OR `props-main`.`id` = 1760038 OR `props-main`.`id` = 1757653 OR `props-main`.`id` = 1737434 OR `props-main`.`id` = 1770891 OR `props-main`.`id` = 1725194 OR `props-main`.`id` = 1759374 OR `props-main`.`id` = 1744548 OR `props-main`.`id` = 1719985 OR `props-main`.`id` = 1719922 OR `props-main`.`id` = 1769309 OR `props-main`.`id` = 1767800 OR `props-main`.`id` = 1719132 OR `props-main`.`id` = 1760760 OR `props-main`.`id` = 1754737 OR `props-main`.`id` = 1754841 OR `props-main`.`id` = 1748218 OR `props-main`.`id` = 1761692 OR `props-main`.`id` = 1770597 OR `props-main`.`id` = 1767715 OR `props-main`.`id` = 1725621 OR `props-main`.`id` = 1725624 OR `props-main`.`id` = 1723215 OR `props-main`.`id` = 1764190 OR `props-main`.`id` = 1742830 OR `props-main`.`id` = 1763830 OR `props-main`.`id` = 1720053 OR `props-main`.`id` = 1755413 OR `props-main`.`id` = 1764249 OR `props-main`.`id` = 1736979 OR `props-main`.`id` = 1720259 OR `props-main`.`id` = 1759008 OR `props-main`.`id` = 1752340 OR `props-main`.`id` = 1748876 OR `props-main`.`id` = 1720016 OR `props-main`.`id` = 1747247 OR `props-main`.`id` = 1719020 OR `props-main`.`id` = 1759077 OR `props-main`.`id` = 1720082 OR `props-main`.`id` = 1726904 OR `props-main`.`id` = 1747016 OR `props-main`.`id` = 1709760 OR `props-main`.`id` = 1725690 OR `props-main`.`id` = 1770453 OR `props-main`.`id` = 1721391 OR `props-main`.`id` = 1719968 OR `props-main`.`id` = 1768474 OR `props-main`.`id` = 1742217 OR `props-main`.`id` = 1722185 OR `props-main`.`id` = 1736884 OR `props-main`.`id` = 1736891 OR `props-main`.`id` = 1736894 OR `props-main`.`id` = 1718153 OR `props-main`.`id` = 1769387 OR `props-main`.`id` = 1752895 OR `props-main`.`id` = 1756897 OR `props-main`.`id` = 1770807 OR `props-main`.`id` = 1719499 OR `props-main`.`id` = 1720149 OR `props-main`.`id` = 1727594 OR `props-main`.`id` = 1322227)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare241023' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-03' 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 Brian Dombroski, Dombroski Realty
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.
