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` = 1774104 OR `props-main`.`id` = 1766150 OR `props-main`.`id` = 1777246 OR `props-main`.`id` = 1766145 OR `props-main`.`id` = 1777677 OR `props-main`.`id` = 1773985 OR `props-main`.`id` = 1777679 OR `props-main`.`id` = 1771136 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1777678 OR `props-main`.`id` = 1766141 OR `props-main`.`id` = 1777503 OR `props-main`.`id` = 1755418 OR `props-main`.`id` = 1774173 OR `props-main`.`id` = 1775970 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` = 1755478 OR `props-main`.`id` = 1755470 OR `props-main`.`id` = 1755473 OR `props-main`.`id` = 1769740 OR `props-main`.`id` = 1779925 OR `props-main`.`id` = 1777547 OR `props-main`.`id` = 1773141 OR `props-main`.`id` = 1721490 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` = 1777338 OR `props-main`.`id` = 1725262 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1764611 OR `props-main`.`id` = 1764625 OR `props-main`.`id` = 1764621 OR `props-main`.`id` = 1761670 OR `props-main`.`id` = 1774626 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` = 1777303 OR `props-main`.`id` = 1777273 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` = 1777746 OR `props-main`.`id` = 1774725 OR `props-main`.`id` = 1748218 OR `props-main`.`id` = 1778361 OR `props-main`.`id` = 1761692 OR `props-main`.`id` = 1767715 OR `props-main`.`id` = 1771323 OR `props-main`.`id` = 1723215 OR `props-main`.`id` = 1777663 OR `props-main`.`id` = 1742830 OR `props-main`.`id` = 1763830 OR `props-main`.`id` = 1777327 OR `props-main`.`id` = 1755413 OR `props-main`.`id` = 1764249 OR `props-main`.`id` = 1777546 OR `props-main`.`id` = 1777421 OR `props-main`.`id` = 1759008 OR `props-main`.`id` = 1776668 OR `props-main`.`id` = 1752340 OR `props-main`.`id` = 1748876 OR `props-main`.`id` = 1777314 OR `props-main`.`id` = 1777600 OR `props-main`.`id` = 1719020 OR `props-main`.`id` = 1759077 OR `props-main`.`id` = 1777340 OR `props-main`.`id` = 1776947 OR `props-main`.`id` = 1709760 OR `props-main`.`id` = 1770453 OR `props-main`.`id` = 1777291 OR `props-main`.`id` = 1778058 OR `props-main`.`id` = 1768474 OR `props-main`.`id` = 1742217 OR `props-main`.`id` = 1777446 OR `props-main`.`id` = 1777544 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` = 1774613 OR `props-main`.`id` = 1770807 OR `props-main`.`id` = 1719499 OR `props-main`.`id` = 1777362 OR `props-main`.`id` = 1727594 OR `props-main`.`id` = 1773117 OR `props-main`.`id` = 1775758 OR `props-main`.`id` = 1772847 OR `props-main`.`id` = 1322227)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare241023' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-23' 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.
