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` = 1774104 OR `props-main`.`id` = 1783388 OR `props-main`.`id` = 1782866 OR `props-main`.`id` = 1783282 OR `props-main`.`id` = 1785618 OR `props-main`.`id` = 1773985 OR `props-main`.`id` = 1783284 OR `props-main`.`id` = 1790537 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1783283 OR `props-main`.`id` = 1791302 OR `props-main`.`id` = 1789701 OR `props-main`.`id` = 1781353 OR `props-main`.`id` = 1783111 OR `props-main`.`id` = 1788327 OR `props-main`.`id` = 1755418 OR `props-main`.`id` = 1774173 OR `props-main`.`id` = 1775970 OR `props-main`.`id` = 1785709 OR `props-main`.`id` = 1726363 OR `props-main`.`id` = 1755398 OR `props-main`.`id` = 1777021 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1755427 OR `props-main`.`id` = 1755407 OR `props-main`.`id` = 1789168 OR `props-main`.`id` = 1791297 OR `props-main`.`id` = 1755478 OR `props-main`.`id` = 1755470 OR `props-main`.`id` = 1789076 OR `props-main`.`id` = 1790381 OR `props-main`.`id` = 1769740 OR `props-main`.`id` = 1779925 OR `props-main`.`id` = 1783154 OR `props-main`.`id` = 1773141 OR `props-main`.`id` = 1791398 OR `props-main`.`id` = 1790846 OR `props-main`.`id` = 1773529 OR `props-main`.`id` = 1773530 OR `props-main`.`id` = 1780351 OR `props-main`.`id` = 1778362 OR `props-main`.`id` = 1775551 OR `props-main`.`id` = 1782953 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1780781 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1764611 OR `props-main`.`id` = 1764625 OR `props-main`.`id` = 1764621 OR `props-main`.`id` = 1784771 OR `props-main`.`id` = 1761670 OR `props-main`.`id` = 1760038 OR `props-main`.`id` = 1757653 OR `props-main`.`id` = 1737434 OR `props-main`.`id` = 1725194 OR `props-main`.`id` = 1759374 OR `props-main`.`id` = 1744548 OR `props-main`.`id` = 1782919 OR `props-main`.`id` = 1782893 OR `props-main`.`id` = 1769309 OR `props-main`.`id` = 1767800 OR `props-main`.`id` = 1719132 OR `props-main`.`id` = 1777746 OR `props-main`.`id` = 1785868 OR `props-main`.`id` = 1767715 OR `props-main`.`id` = 1771323 OR `props-main`.`id` = 1723215 OR `props-main`.`id` = 1783268 OR `props-main`.`id` = 1742830 OR `props-main`.`id` = 1782942 OR `props-main`.`id` = 1791428 OR `props-main`.`id` = 1755413 OR `props-main`.`id` = 1764249 OR `props-main`.`id` = 1783153 OR `props-main`.`id` = 1759008 OR `props-main`.`id` = 1752340 OR `props-main`.`id` = 1748876 OR `props-main`.`id` = 1782928 OR `props-main`.`id` = 1783206 OR `props-main`.`id` = 1782955 OR `props-main`.`id` = 1776947 OR `props-main`.`id` = 1790648 OR `props-main`.`id` = 1709760 OR `props-main`.`id` = 1770453 OR `props-main`.`id` = 1778058 OR `props-main`.`id` = 1788812 OR `props-main`.`id` = 1768474 OR `props-main`.`id` = 1742217 OR `props-main`.`id` = 1785410 OR `props-main`.`id` = 1789143 OR `props-main`.`id` = 1783390 OR `props-main`.`id` = 1783057 OR `props-main`.`id` = 1783151 OR `props-main`.`id` = 1736891 OR `props-main`.`id` = 1736894 OR `props-main`.`id` = 1774200 OR `props-main`.`id` = 1718153 OR `props-main`.`id` = 1776268 OR `props-main`.`id` = 1791368 OR `props-main`.`id` = 1774613 OR `props-main`.`id` = 1770807 OR `props-main`.`id` = 1719499 OR `props-main`.`id` = 1782977 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-10-15' 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.
