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/239244/2546-S-Woodland-St/Visalia/https://www.londonproperties.com/images/props/tulare/full/239244.jpgLondon Properties Visalia Real Estate | 2546 S Woodland St
Great opportunity to own a beautiful home in a desirable location with incredible upside. This spacious 4-bedroom, 2 bath home offers plenty of room for a growing family to live and entertain comfortably. Situated on a generous lot just under a quarter acre, the property provides ample outdoor space and future potential. This home has the potential for you to add your personal touch and build instant equity. If you're looking for your next project or want to add this to your portfolio then look no further.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1964
Year Built Source
Public Records
Days On Market
1
Cumulative Days On Market
1
County
Tulare
New Construction
No
Stories
1
Directions to Property
Take Whittendale Ave to Woodland st and go North. Once on Woodland st the home is on the east side of the street.
Roof
Composition
Heating
Other
Cooling
Evaporative Cooling
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Fireplace Y/N
Yes
Fireplace Features
Other
Common Walls
2+ Common Walls
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
Yes
# of Garage Spaces
2.0
APN
121 142 019 000
Lot Dimensions
81'X130'
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 289750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 320250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1742 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2242 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` = 1648135 OR `props-main`.`id` = 1569638 OR `props-main`.`id` = 1651484 OR `props-main`.`id` = 1683411 OR `props-main`.`id` = 1701500 OR `props-main`.`id` = 1702730 OR `props-main`.`id` = 1690834 OR `props-main`.`id` = 1696538 OR `props-main`.`id` = 1700154 OR `props-main`.`id` = 1688752 OR `props-main`.`id` = 1685040 OR `props-main`.`id` = 1696672 OR `props-main`.`id` = 1696990 OR `props-main`.`id` = 1696539 OR `props-main`.`id` = 1696545 OR `props-main`.`id` = 1696537 OR `props-main`.`id` = 1549450 OR `props-main`.`id` = 1648185 OR `props-main`.`id` = 1616928 OR `props-main`.`id` = 1690720 OR `props-main`.`id` = 1549555 OR `props-main`.`id` = 1684180 OR `props-main`.`id` = 1681202 OR `props-main`.`id` = 1648449 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1698846 OR `props-main`.`id` = 1633263 OR `props-main`.`id` = 1691065 OR `props-main`.`id` = 1691073 OR `props-main`.`id` = 1691075 OR `props-main`.`id` = 1691082 OR `props-main`.`id` = 1698166 OR `props-main`.`id` = 1702651 OR `props-main`.`id` = 1702391 OR `props-main`.`id` = 1694481 OR `props-main`.`id` = 1632306 OR `props-main`.`id` = 1698493 OR `props-main`.`id` = 1698550 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1702083 OR `props-main`.`id` = 1701521 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1689737 OR `props-main`.`id` = 1702119 OR `props-main`.`id` = 1648093 OR `props-main`.`id` = 1694031 OR `props-main`.`id` = 1702963 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1690044 OR `props-main`.`id` = 1702042 OR `props-main`.`id` = 1694024 OR `props-main`.`id` = 1702011 OR `props-main`.`id` = 1696748 OR `props-main`.`id` = 1698087 OR `props-main`.`id` = 1698128 OR `props-main`.`id` = 1694547 OR `props-main`.`id` = 1701354 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1698494 OR `props-main`.`id` = 1693637 OR `props-main`.`id` = 1696175 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1694782 OR `props-main`.`id` = 1695064 OR `props-main`.`id` = 1702849 OR `props-main`.`id` = 1702855 OR `props-main`.`id` = 1702846 OR `props-main`.`id` = 1698043 OR `props-main`.`id` = 1702896 OR `props-main`.`id` = 1702953 OR `props-main`.`id` = 1696665 OR `props-main`.`id` = 1696658 OR `props-main`.`id` = 1698686 OR `props-main`.`id` = 1695906 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1698520 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1701222 OR `props-main`.`id` = 1701929 OR `props-main`.`id` = 1698676 OR `props-main`.`id` = 1697316 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1691899 OR `props-main`.`id` = 1691904 OR `props-main`.`id` = 1694231 OR `props-main`.`id` = 1694457 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1701825 OR `props-main`.`id` = 1701822 OR `props-main`.`id` = 1701824 OR `props-main`.`id` = 1701688 OR `props-main`.`id` = 1701267 OR `props-main`.`id` = 1702583 OR `props-main`.`id` = 1702629 OR `props-main`.`id` = 1701270 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1702729 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1692210 OR `props-main`.`id` = 1698537 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1687117)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239244' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-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();
0
Courtesy of Christopher Harris, Realty Concepts, Ltd. - Fresno
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.
