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/652176/905-S-Leila-St/Visalia/https://www.londonproperties.com/images/props/fresno/full/652176.jpgLondon Properties Visalia Real Estate | 905 S Leila St
Courtesy of Amanda Miller, eXp Realty of Northern California, Inc. - [email protected]
Welcome to 905 S Leila St, a 3-bedroom, 2-bath home situated on a desirable corner lot in Visalia. Thoughtfully renovated from top to bottom, this home combines contemporary finishes with an exceptionally convenient location. Extensive updates include fresh interior and exterior paint, new flooring throughout, as well as modern cabinetry, countertops, appliances, and fixtures in the kitchen and bathrooms. These improvements give the home a clean, polished feel inside and out. The open floor plan is complemented by a 2-car attached garage and potential RV parking. A new roof and new HVAC system add long-term value to the home. Conveniently located near schools, including College of the Sequoias, this home offers easy access to campus. Shopping, dining, and everyday amenities are also just minutes away. 905 S Leila St offers the rare combination of a fully refreshed home, flexible parking, and everyday convenience.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1972
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$321
Price Per Acre
$2,087,054
Days On London
0
Cumulative Days On London
0
County
Tulare
REO / Bank Owned
No
Cross Street Address
Demaree St
Directions
From Highway 198, take the exit for Akers Street and head south. Turn left onto Walnut Avenue, then right onto Leila Street. Continue to 905 S Leila St, located in Visalia.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
095 271 017
School District
Visalia Schools
School Type 1
High School
School Name 1
Mt. Whitney
School Type 2
Junior High School
School Name 2
Green Acres
School Type 3
Grade School
School Name 3
Royal Oaks
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 839 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1339 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` = 1746506 OR `props-main`.`id` = 1747809 OR `props-main`.`id` = 1737941 OR `props-main`.`id` = 1744777 OR `props-main`.`id` = 1744776 OR `props-main`.`id` = 1744800 OR `props-main`.`id` = 1747158 OR `props-main`.`id` = 1728228 OR `props-main`.`id` = 1746493 OR `props-main`.`id` = 1724525 OR `props-main`.`id` = 1745597 OR `props-main`.`id` = 1745743 OR `props-main`.`id` = 1739207 OR `props-main`.`id` = 1739210 OR `props-main`.`id` = 1749649 OR `props-main`.`id` = 1749080 OR `props-main`.`id` = 1727448 OR `props-main`.`id` = 1721330 OR `props-main`.`id` = 1747752 OR `props-main`.`id` = 1737676 OR `props-main`.`id` = 1737654 OR `props-main`.`id` = 1747571 OR `props-main`.`id` = 1745594 OR `props-main`.`id` = 1747728 OR `props-main`.`id` = 1748887 OR `props-main`.`id` = 1744361 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1749868 OR `props-main`.`id` = 1746864 OR `props-main`.`id` = 1749375 OR `props-main`.`id` = 1722713 OR `props-main`.`id` = 1710092 OR `props-main`.`id` = 1720113 OR `props-main`.`id` = 1725644 OR `props-main`.`id` = 1713368 OR `props-main`.`id` = 1713389 OR `props-main`.`id` = 1719584 OR `props-main`.`id` = 1713350 OR `props-main`.`id` = 1717921 OR `props-main`.`id` = 1748467 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1745938 OR `props-main`.`id` = 1748983 OR `props-main`.`id` = 1735179 OR `props-main`.`id` = 1720925 OR `props-main`.`id` = 1721635 OR `props-main`.`id` = 1720924 OR `props-main`.`id` = 1721631 OR `props-main`.`id` = 1749688 OR `props-main`.`id` = 1729947 OR `props-main`.`id` = 1729968 OR `props-main`.`id` = 1729983 OR `props-main`.`id` = 1729940 OR `props-main`.`id` = 1710056 OR `props-main`.`id` = 1744300 OR `props-main`.`id` = 1749932 OR `props-main`.`id` = 1725248 OR `props-main`.`id` = 1716112 OR `props-main`.`id` = 1737808 OR `props-main`.`id` = 1727248 OR `props-main`.`id` = 1727238 OR `props-main`.`id` = 1737703 OR `props-main`.`id` = 1733286 OR `props-main`.`id` = 1730862 OR `props-main`.`id` = 1718626 OR `props-main`.`id` = 1736041 OR `props-main`.`id` = 1746861 OR `props-main`.`id` = 1740022 OR `props-main`.`id` = 1748985 OR `props-main`.`id` = 1748579 OR `props-main`.`id` = 1728452 OR `props-main`.`id` = 1741078 OR `props-main`.`id` = 1745596 OR `props-main`.`id` = 1719621 OR `props-main`.`id` = 1741960 OR `props-main`.`id` = 1746655 OR `props-main`.`id` = 1735832 OR `props-main`.`id` = 1728873 OR `props-main`.`id` = 1745876 OR `props-main`.`id` = 1745878 OR `props-main`.`id` = 1702399 OR `props-main`.`id` = 1702407 OR `props-main`.`id` = 1692035 OR `props-main`.`id` = 1722801 OR `props-main`.`id` = 1719622 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1737629 OR `props-main`.`id` = 1706994 OR `props-main`.`id` = 1706995 OR `props-main`.`id` = 1722782 OR `props-main`.`id` = 1737437 OR `props-main`.`id` = 1746917 OR `props-main`.`id` = 1741450 OR `props-main`.`id` = 1724438 OR `props-main`.`id` = 1727907 OR `props-main`.`id` = 1750084 OR `props-main`.`id` = 1750098 OR `props-main`.`id` = 1722778 OR `props-main`.`id` = 1726485 OR `props-main`.`id` = 1744299 OR `props-main`.`id` = 1726986 OR `props-main`.`id` = 1722779 OR `props-main`.`id` = 1735853 OR `props-main`.`id` = 1748526 OR `props-main`.`id` = 1736949 OR `props-main`.`id` = 1745749 OR `props-main`.`id` = 1725159 OR `props-main`.`id` = 1739307 OR `props-main`.`id` = 1741076 OR `props-main`.`id` = 1747189 OR `props-main`.`id` = 1732341 OR `props-main`.`id` = 1737665 OR `props-main`.`id` = 1741087 OR `props-main`.`id` = 1727558 OR `props-main`.`id` = 1749368 OR `props-main`.`id` = 1720484 OR `props-main`.`id` = 1720505 OR `props-main`.`id` = 1720472 OR `props-main`.`id` = 1749373 OR `props-main`.`id` = 1731846 OR `props-main`.`id` = 1721652 OR `props-main`.`id` = 1738869 OR `props-main`.`id` = 1732771 OR `props-main`.`id` = 1722813 OR `props-main`.`id` = 1744749 OR `props-main`.`id` = 1737699 OR `props-main`.`id` = 1744767 OR `props-main`.`id` = 1722976 OR `props-main`.`id` = 1737673 OR `props-main`.`id` = 1728430 OR `props-main`.`id` = 1728416 OR `props-main`.`id` = 1728422 OR `props-main`.`id` = 1728426 OR `props-main`.`id` = 1722824 OR `props-main`.`id` = 1723816 OR `props-main`.`id` = 1744748 OR `props-main`.`id` = 1746826 OR `props-main`.`id` = 1744778 OR `props-main`.`id` = 1726328 OR `props-main`.`id` = 1715538 OR `props-main`.`id` = 1743708 OR `props-main`.`id` = 1726163 OR `props-main`.`id` = 1726156 OR `props-main`.`id` = 1726138 OR `props-main`.`id` = 1739495 OR `props-main`.`id` = 1719198 OR `props-main`.`id` = 1715964 OR `props-main`.`id` = 1734725 OR `props-main`.`id` = 1713659 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1749175 OR `props-main`.`id` = 1749240 OR `props-main`.`id` = 1725944 OR `props-main`.`id` = 1745412 OR `props-main`.`id` = 1739525 OR `props-main`.`id` = 1727517 OR `props-main`.`id` = 1748885 OR `props-main`.`id` = 1747462 OR `props-main`.`id` = 1729187 OR `props-main`.`id` = 1717383 OR `props-main`.`id` = 1706794 OR `props-main`.`id` = 1736104 OR `props-main`.`id` = 1722604 OR `props-main`.`id` = 1728949 OR `props-main`.`id` = 1724376 OR `props-main`.`id` = 1725472 OR `props-main`.`id` = 1725449 OR `props-main`.`id` = 1725450 OR `props-main`.`id` = 1749799 OR `props-main`.`id` = 1727128 OR `props-main`.`id` = 1725417 OR `props-main`.`id` = 1749331 OR `props-main`.`id` = 1749325 OR `props-main`.`id` = 1726133 OR `props-main`.`id` = 1728812 OR `props-main`.`id` = 1728230 OR `props-main`.`id` = 1740017 OR `props-main`.`id` = 1740015 OR `props-main`.`id` = 1748011 OR `props-main`.`id` = 1725167 OR `props-main`.`id` = 1747272 OR `props-main`.`id` = 1723513 OR `props-main`.`id` = 1740230 OR `props-main`.`id` = 1745428 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1737710 OR `props-main`.`id` = 1745714 OR `props-main`.`id` = 1744965 OR `props-main`.`id` = 1742109 OR `props-main`.`id` = 1742129 OR `props-main`.`id` = 1742113 OR `props-main`.`id` = 1743965 OR `props-main`.`id` = 1731294 OR `props-main`.`id` = 1731293 OR `props-main`.`id` = 1731292 OR `props-main`.`id` = 1743941)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652176' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-16' 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();
2
Similar Properties
$359,000
4
2
1,161
0.19
4222 W Victor Ave
Visalia, CA 93277
$335,000
3
2
1,327
0.21
1336 W Paradise Ave
Visalia, CA 93277
Last modified 2 hours ago Fresno MLS last checked for updates 20 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.
