Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

41761 N Fork Drive
Three Rivers, CA 93271
Todd Renfrew with California Outdoor Properties, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $15,000,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3681 Square Feet
Agency: California Outdoor Properties
Agency Phone: (707) 455-4444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5,176 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: An exceptional opportunity to acquire an expansive 5,176.13-acre ranch, featuring over one mile of Kaweah River frontage, complete with deeded water rights, and over half a mile of Kaweah Lake shoreline, all conveniently located just a 5-minute drive from the charming Three Rivers town. The D-K Ranch spans from an initial elevation of 800 feet, gradually ascending to a peak of 3,200 feet, revealing stunning mountain vistas and offering absolute seclusion. <br /> <br /> Currently, the ranch is used for cattle and can comfortably support over 300 cow/calf pairs year- round. The expansive 5,000+ acre property is a haven for outdoor enthusiasts. It features prime Kaweah River and lake frontage, perfect for fishing and swimming, along with stocked ponds for anglers. Wildlife abounds teeming with deer, dove, quail, pigs, and turkey, making it a paradise for hunting. Whether you prefer horseback riding in the large arena or trails, ATV adventures, hunting expeditions, fishing, or hiking along scenic trails, you'll find it all within the ranch's boundaries. <br /> <br /> The ranch boasts a range of impressive improvements, including a newer four-bedroom, four-and-a-half- bathroom ranch home with an attached guest quarters and den along with a pool and spa. Additionally, there is an original ranch home which has recently been updated. The three-bedroom, two-bathroom ranch home offers versatile options for guest accommodations, vacation rental potential (VRBO), or ranch staff housing. For added entertainment value, the western-themed barn provides a spacious setting with a well-equipped chef 's kitchen, a redwood bar, a game room, an office, a comfortable bedroom, and more, making it an ideal space for hosting guests and creating lasting memories. <br /> <br /> Encompassed by breathtaking mountain vistas and offering complete seclusion, the D-K Ranch provides a serene and picturesque retreat.
MlsNumber: --
ListingId: 228041


Listing Provided By: California Outdoor Properties, original listing
Phone: (707) 455-4444
Office Phone: (707) 455-4444
Agent Name: Todd Renfrew
Disclaimer: Copyright © 2024 Tulare County MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App