Welcome to 1623 Hudson Ave, a charming and move-in ready 3-bedroom, 2-bath home offering 1,128 Sq ft of well-designed living space on a 6,001 Sq ft lot. The functional kitchen features granite countertops and pantry all arranged for everyday comfort and convenience. Additional highlights include, laminate and tile flooring throughout, attached garage and a 2-year-old central air conditioning system for year-round comfort. Outside, enjoy a large backyard with potential RV parking ideal for outdoor living. Don't miss this opportunity schedule your showing today!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2006
Year Built Source
Public Records
Days On London
3
Cumulative Days On London
3
County
Tulare
New Construction
No
Stories
1
Directions to Property
From West, go West on Tulare south American, east on Cumberland, West on Hudson.
Construction Materials
Stone, Stucco
Foundation Details
Slab
Roof
Shingle
Heating
Forced Air
Cooling
Ceiling Fan(s), Central Air, Gas
Laundry Features
In Garage
Security Features
Closed Circuit Camera(s), Smoke Detector(s)
Direction Faces
Southwest
Other Structures
Outbuilding, Shed(s), Storage
Interior Features
Ceiling Fan(s), High Ceilings, Stone Counters, Vaulted Ceiling(s), Pantry
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Dishwasher, Free-Standing Range, Gas Oven, Gas Range, Gas Water Heater, Hot Water Circulator, Range, Range Hood, Water Heater
Fireplace Y/N
No
Flooring
Ceramic Tile, Laminate, Wood
Common Walls
No Common Walls
Spa
No
Patio and Porch Features
Patio
Utilities
Electricity Connected, Phone Connected, Sewer Connected, Water Connected
Electric
220 Volts in Garage
Water Source
Public
Sewer
Public Sewer
Green Energy Efficient
HVAC
Parking Features
Attached, Garage Door Opener, RV Access/Parking
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
168 310 013 000
Lot Dimensions
Irregular
Horse Property
No
Additional Parcels Y/N
No
Waterfront Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 303050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 334950 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) >= 878 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1378 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` = 1698936 OR `props-main`.`id` = 1715215 OR `props-main`.`id` = 1713293 OR `props-main`.`id` = 1706149 OR `props-main`.`id` = 1705819 OR `props-main`.`id` = 1704487 OR `props-main`.`id` = 1704488 OR `props-main`.`id` = 1715540 OR `props-main`.`id` = 1715542 OR `props-main`.`id` = 1715539 OR `props-main`.`id` = 1706853 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1712901 OR `props-main`.`id` = 1715910 OR `props-main`.`id` = 1715900 OR `props-main`.`id` = 1713953 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1713948 OR `props-main`.`id` = 1713369 OR `props-main`.`id` = 1713922 OR `props-main`.`id` = 1713916 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1686171 OR `props-main`.`id` = 1703243 OR `props-main`.`id` = 1681737 OR `props-main`.`id` = 1705026 OR `props-main`.`id` = 1702082 OR `props-main`.`id` = 1716346 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1712881 OR `props-main`.`id` = 1712883 OR `props-main`.`id` = 1715733 OR `props-main`.`id` = 1683997 OR `props-main`.`id` = 1715992)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240294' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-15' 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();
1
Similar Properties
$325,000
3
2
1,343
0.13
428 Napa St
Tulare, CA 93274
Courtesy of Marie Alafa, Century 21 Jordan-Link & Company
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.
