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/646995/5558-Lake/Alpaugh/https://www.londonproperties.com/images/props/fresno/full/646995.jpgLondon Properties Alpaugh Real Estate | 5558 Lake
Recently remodeled 3-bedroom, 2-bath home featuring a 1-car garage. This single-story ranch-style property offers a spacious front patio and a large backyard with plenty of room to plant fruit trees or create your ideal outdoor space.
The home has been freshly updated throughout, including new interior and exterior paint, new lighting fixtures in all bedrooms and kitchen, and updated vinyl flooring in the kitchen, living room, and hallway. The kitchen features new countertops and freshly painted cabinets.
The primary suite has been remodeled with new tile in the shower, a new vanity, mirror, and updated lighting. Both bathrooms have been upgraded with new flooring, vanities, mirrors, and lighting. Bedrooms feature new carpet, and all interior and closet doors have been replaced. Great opportunity for First Time Home Buyers
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1975
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$216
Days On London
20
Cumulative Days On London
20
County
Tulare
REO / Bank Owned
No
Cross Street Address
Tule rd / Wilbur Rd
Directions
From Tulare CA-99 go North toward Fresno. Exit onto CA 137 West toward Corcoran. Continue on CA 137and turn onto CA-43 North.Then turn left onto Alpaugh Rd and continue into Alpaugh then turn left onto Lake until you find the property.Use google Map.
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Evaporative Cool, Floor or Wall Unit
Laundry
Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Other
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
1
APN
311 173 001
School District
Alpaugh
School Type 1
High School
School Name 1
Aplaugh
School Type 2
Junior High School
School Name 2
Aplaugh
School Type 3
Grade School
School Name 3
Aplaugh
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 251750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 278250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 978 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1478 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` = 1709577 OR `props-main`.`id` = 1712889 OR `props-main`.`id` = 1654589 OR `props-main`.`id` = 1654584 OR `props-main`.`id` = 1674748 OR `props-main`.`id` = 1654593 OR `props-main`.`id` = 1720124 OR `props-main`.`id` = 1714513 OR `props-main`.`id` = 1721436 OR `props-main`.`id` = 1712916 OR `props-main`.`id` = 1719949 OR `props-main`.`id` = 1719950)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646995' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-01' 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 Maria Luisa De Pano, Realty Essentials Group Inc - [email protected] Last modified 1 week ago Fresno MLS last checked for updates 5 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.
