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/239816/43788-Northfork-Dr/Three-Rivers/https://www.londonproperties.com/images/props/tulare/full/239816.jpgLondon Properties Three Rivers Real Estate | 43788 Northfork Dr
Discover your peaceful retreat in this picturesque home, with additional separate studio currently used as a Airbnb for additional income on your investment. Both nestled amidst the tranquil sounds of nature. Surrounded by majestic native oak, sycamore, and redbud trees, you can enjoy the gentle melody of the river while basking in the serenity of your private backyard oasis. This property has an elevation certificate determining it is not located in the flood plain, which is a definite insurance savings. This exceptional 2200 square foot residence was thoughtfully remodeled and upgraded in 2005 The open floor plan seamlessly blends indoor and outdoor living, offering breathtaking natural views from every window. Experience a harmonious balance of comfort and elegance in this truly unique home. True river frontage delivers soothing water sounds and direct access for kayaking, fishing, or simply unwinding on your own shoreline. Don't miss the chance to make it yours! Additional unit on property used as Airbnb.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1964
Year Built Source
Owner
Days On London
11
Cumulative Days On London
11
County
Tulare
Property Condition
Updated/Remodeled
New Construction
No
Stories
2
Current Use
Residential
Directions to Property
East on Sierra dr turn left on NorthFork to property on right side
Construction Materials
Stucco
Foundation Details
Slab
Roof
Composition
Heating
Central, Wood Stove
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Inside
Interior Features
Open Floorplan, Tile Counters, Vaulted Ceiling(s)
# of Main Level Bathrooms
2
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Dishwasher, Electric Oven, Electric Range, Microwave, Oven, Refrigerator
Fireplace Y/N
Yes
Fireplace Features
Fire Pit, Great Room, Kitchen, Living Room, Patio, Propane, Raised Hearth, Wood Burning, Wood Burning Stove
Exterior Features
Awning(s)
Spa
No
Patio and Porch Features
Deck
Utilities
Propane
Water Source
Private, Well
Sewer
Septic Tank
Garage
No
APN
670 500 380 00
Lot Features
Back Yard
Lot Dimensions
Irregular
Additional Parcels Y/N
No
Waterfront Y/N
No
Road Surface Type
Concrete
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 854050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 943950 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) >= 1950 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2450 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` = 1701930 OR `props-main`.`id` = 1587884 OR `props-main`.`id` = 1696367 OR `props-main`.`id` = 1696327 OR `props-main`.`id` = 1696341 OR `props-main`.`id` = 1708241 OR `props-main`.`id` = 1709190 OR `props-main`.`id` = 1703957 OR `props-main`.`id` = 1709949 OR `props-main`.`id` = 1648076 OR `props-main`.`id` = 1648109 OR `props-main`.`id` = 1708466 OR `props-main`.`id` = 1708244)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239816' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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 Gregory Lockhart, Sequoia Pacific Realty Three R
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.
