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/239441/1502-W-Tulare-Ave/Visalia/https://www.londonproperties.com/images/props/tulare/full/239441.jpgLondon Properties Visalia Real Estate | 1502 W Tulare Ave
This well built home has been beautifully remodeled and is move-in ready. Features include a large covered patio and a huge backyard. Plenty of parking with a two car garage and two car driveway with room to the side for additional parking. Kitchen has been fully made over with new cabinets, counter tops, dishwasher, disposal and range/oven. All new paint inside and out and all new flooring within. Very clean and very nice. A must see and priced to sell.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1961
Year Built Source
Public Records
Days On London
39
Cumulative Days On London
39
County
Tulare
Property Condition
Updated/Remodeled
New Construction
No
Stories
1
Current Use
Vacant, Single Family
Directions to Property
From S Mooney Blvd proceed East On west Tulare Avenue to the property. Property is on the North side of the street.
Construction Materials
Brick, Stucco
Roof
Composition, Shingle
Heating
Central, Natural Gas
Cooling
Ceiling Fan(s), Central Air, Electric
Laundry Features
In Garage
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Direction Faces
South
Interior Features
Ceiling Fan(s), Open Floorplan, Remodeled, Stone Counters
Bathrooms Total (Integer)
2
Full Baths
1.75
Full Baths
1
Three Quarter Baths
1
Appliances
Built-In Range, Dishwasher, Disposal, Gas Range, Microwave, Range
Fireplace Y/N
Yes
Fireplace Features
Living Room
Flooring
Hardwood, Laminate, Wood
Common Walls
No Common Walls
Spa
No
Patio and Porch Features
Covered, Patio
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Concrete
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
096 083 026 000
Lot Features
Fencing, Front Yard
Lot Dimensions
70 X 137
Horse Property
No
Zoning Description
R 1-6
Additional Parcels Y/N
No
Waterfront Y/N
No
Road Surface Type
Asphalt
Subdivision
West Fini Tract
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 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) >= 1141 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1641 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` = 1715154 OR `props-main`.`id` = 1715095 OR `props-main`.`id` = 1633263 OR `props-main`.`id` = 1714973 OR `props-main`.`id` = 1715281 OR `props-main`.`id` = 1708042 OR `props-main`.`id` = 1702391 OR `props-main`.`id` = 1714910 OR `props-main`.`id` = 1716332 OR `props-main`.`id` = 1711524 OR `props-main`.`id` = 1713902 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1713945 OR `props-main`.`id` = 1713397 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1710092 OR `props-main`.`id` = 1715343 OR `props-main`.`id` = 1708062 OR `props-main`.`id` = 1715051 OR `props-main`.`id` = 1712611 OR `props-main`.`id` = 1715387 OR `props-main`.`id` = 1702854 OR `props-main`.`id` = 1716569 OR `props-main`.`id` = 1704617 OR `props-main`.`id` = 1713336 OR `props-main`.`id` = 1710056 OR `props-main`.`id` = 1698087 OR `props-main`.`id` = 1698128 OR `props-main`.`id` = 1694547 OR `props-main`.`id` = 1712564 OR `props-main`.`id` = 1716396 OR `props-main`.`id` = 1705113 OR `props-main`.`id` = 1705141 OR `props-main`.`id` = 1704880 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1702973 OR `props-main`.`id` = 1710216 OR `props-main`.`id` = 1709998 OR `props-main`.`id` = 1710182 OR `props-main`.`id` = 1715945 OR `props-main`.`id` = 1715962 OR `props-main`.`id` = 1715946 OR `props-main`.`id` = 1712874 OR `props-main`.`id` = 1713292 OR `props-main`.`id` = 1712574 OR `props-main`.`id` = 1704197 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1714942 OR `props-main`.`id` = 1714960 OR `props-main`.`id` = 1716021 OR `props-main`.`id` = 1708037 OR `props-main`.`id` = 1708015 OR `props-main`.`id` = 1698498 OR `props-main`.`id` = 1702527 OR `props-main`.`id` = 1701524 OR `props-main`.`id` = 1701520 OR `props-main`.`id` = 1713431 OR `props-main`.`id` = 1713600 OR `props-main`.`id` = 1713432 OR `props-main`.`id` = 1715854 OR `props-main`.`id` = 1705155 OR `props-main`.`id` = 1716046 OR `props-main`.`id` = 1715987 OR `props-main`.`id` = 1713675 OR `props-main`.`id` = 1716515 OR `props-main`.`id` = 1696665 OR `props-main`.`id` = 1696658 OR `props-main`.`id` = 1704417 OR `props-main`.`id` = 1700934 OR `props-main`.`id` = 1713893 OR `props-main`.`id` = 1715901 OR `props-main`.`id` = 1712888 OR `props-main`.`id` = 1716393 OR `props-main`.`id` = 1716524 OR `props-main`.`id` = 1712416 OR `props-main`.`id` = 1712389 OR `props-main`.`id` = 1716129 OR `props-main`.`id` = 1701825 OR `props-main`.`id` = 1701822 OR `props-main`.`id` = 1701824 OR `props-main`.`id` = 1715476 OR `props-main`.`id` = 1703197 OR `props-main`.`id` = 1703196 OR `props-main`.`id` = 1714848 OR `props-main`.`id` = 1703212 OR `props-main`.`id` = 1703487 OR `props-main`.`id` = 1704478 OR `props-main`.`id` = 1703198 OR `props-main`.`id` = 1715818 OR `props-main`.`id` = 1715424 OR `props-main`.`id` = 1715423 OR `props-main`.`id` = 1715536 OR `props-main`.`id` = 1715541 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1704261 OR `props-main`.`id` = 1713909 OR `props-main`.`id` = 1715066 OR `props-main`.`id` = 1713907 OR `props-main`.`id` = 1713924 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1704533 OR `props-main`.`id` = 1713898 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1712365 OR `props-main`.`id` = 1713929 OR `props-main`.`id` = 1716584 OR `props-main`.`id` = 1703702 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1715538 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1716319 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1713712 OR `props-main`.`id` = 1715366 OR `props-main`.`id` = 1702780 OR `props-main`.`id` = 1716031 OR `props-main`.`id` = 1715964 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1711298 OR `props-main`.`id` = 1711291 OR `props-main`.`id` = 1711300 OR `props-main`.`id` = 1711292 OR `props-main`.`id` = 1715079 OR `props-main`.`id` = 1715935 OR `props-main`.`id` = 1706794 OR `props-main`.`id` = 1712593 OR `props-main`.`id` = 1715126 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1707093 OR `props-main`.`id` = 1678402 OR `props-main`.`id` = 1707025 OR `props-main`.`id` = 1704319 OR `props-main`.`id` = 1704216 OR `props-main`.`id` = 1702293 OR `props-main`.`id` = 1712887 OR `props-main`.`id` = 1715871 OR `props-main`.`id` = 1713918)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239441' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-17' 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 Derek Williams, American Discount Realty Serv
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.
