Take a look at this beautiful completed remodeled home located at the Tradewinds neighborhood. Close to Sam's Club and all the shopping you can imagen. This move-in-ready property offers comfort, style, and modern upgrades throughout • 3 Bedrooms 2 Bathrooms Extra room for an office space or a bedroom • Stunning new quartz countertops • Spacious huge backyard & located on a corner lot. A lot more to see so schedule your private tour TODAY!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2005
Year Built Source
Public Records
Days On Market
26
Cumulative Days On Market
26
County
Kern
Property Condition
Updated/Remodeled
New Construction
No
Stories
1
Directions to Property
South on Gosford Rd, East on Harris Rd then Fiji Dr, house on the corner of Fiji Dr & Kabara Ct
Construction Materials
Stucco
Foundation Details
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Laundry Room
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Direction Faces
North
Interior Features
Ceiling Fan(s), High Ceilings, Kitchen Island, Kitchen Open to Family Room, Pantry, Remodeled
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Dishwasher, Disposal, Gas Range, Gas Water Heater, Microwave
Fireplace Y/N
No
Flooring
Carpet, Laminate
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
545 064 020 04
Lot Features
Corner Lot
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461895 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) >= 1605 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2105 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` = 1697868)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238810' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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 Teresa Valle, Five Star Realty
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.
