HUD Home! Spacious 4 bedroom home with living room and family room. Beautiful kitchen and dining room has a built in hutch. Lots of possibilities.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1966
Year Built Source
Public Records
Days On London
1
Cumulative Days On London
1
County
Kings
New Construction
No
Stories
1
Directions to Property
South on 10th Ave, East on Orchard Dr., and South on 4th Pl. House is located on right hand side.
Roof
Composition, Shingle
Heating
Central
Cooling
Central Air
Bathrooms Total (Integer)
3
Full Baths
2.75
Full Baths
2
Three Quarter Baths
1
Fireplace Y/N
No
Spa
No
Utilities
Other
Water Source
Other
Sewer
Other
Garage
No
APN
016 173 041 000
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 365750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 404250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2161 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2661 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` = 1709982 OR `props-main`.`id` = 1709999 OR `props-main`.`id` = 1709979 OR `props-main`.`id` = 1694201 OR `props-main`.`id` = 1715144 OR `props-main`.`id` = 1702190 OR `props-main`.`id` = 1702702 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1717313 OR `props-main`.`id` = 1714018 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1713213 OR `props-main`.`id` = 1713212 OR `props-main`.`id` = 1713223 OR `props-main`.`id` = 1708194 OR `props-main`.`id` = 1706685 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1715046 OR `props-main`.`id` = 1717493 OR `props-main`.`id` = 1717496 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1717067 OR `props-main`.`id` = 1717090 OR `props-main`.`id` = 1715435 OR `props-main`.`id` = 1715434 OR `props-main`.`id` = 1703994 OR `props-main`.`id` = 1715433 OR `props-main`.`id` = 1715432 OR `props-main`.`id` = 1715203 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1712806 OR `props-main`.`id` = 1715202 OR `props-main`.`id` = 1709682 OR `props-main`.`id` = 1716139 OR `props-main`.`id` = 1713398 OR `props-main`.`id` = 1713391 OR `props-main`.`id` = 1713396 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1709887 OR `props-main`.`id` = 1701340 OR `props-main`.`id` = 1714618 OR `props-main`.`id` = 1713905 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1715168 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1716731 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1714894 OR `props-main`.`id` = 1707996 OR `props-main`.`id` = 1708247 OR `props-main`.`id` = 1702360 OR `props-main`.`id` = 1712814 OR `props-main`.`id` = 1696094 OR `props-main`.`id` = 1696112 OR `props-main`.`id` = 1696509 OR `props-main`.`id` = 1712816 OR `props-main`.`id` = 1712810 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1712808 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1715312 OR `props-main`.`id` = 1715129 OR `props-main`.`id` = 1702263 OR `props-main`.`id` = 1711264 OR `props-main`.`id` = 1705552 OR `props-main`.`id` = 1703271 OR `props-main`.`id` = 1708500 OR `props-main`.`id` = 1709171 OR `props-main`.`id` = 1709168 OR `props-main`.`id` = 1715635)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240506' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-20' 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 Melinda Moyes, Melson Realty, Inc.
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.
