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 Subtype 1
Single Family Residence
Year Built
2006
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$283
Price Per Acre
$2,314,949
Days On London
1
Cumulative Days On London
1
County
Tulare
Reports Available
NHD
REO / Bank Owned
No
Cross Street Address
Cumberland
Directions
From West, go West on Tulare south American, east on Cumberland, West on Hudson.
Style
Bungalow
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Other
Foundation
Concrete
Kitchen
Gas Appliances, Dishwasher, Pantry
Dining Room Features
Living Room/Area
Primary Bedroom Level
Lower
Flooring
Laminate, Tile
Exterior
Stucco
Pool
No
Pool
No
Yard
Sprinklers Front
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
No
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
168 310 013
School District
Tulare Schools
School Type 1
High School
School Name 1
Tulare Western
School Type 2
Junior High School
School Name 2
Los Tules
School Type 3
Grade School
School Name 3
Maple
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` = 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`) != 'fresno645250' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-13' 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 - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 15 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.
