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 = 240 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 = 240 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 = 240 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;

50 Cedar Rd & 270 Mary Ave
Trinity Center, CA 96091
Doren Morgan with California Outdoor Properties, Inc - Arcata, original listing - (619) 933-5504

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active Under Contract
SqFt: 3000 Square Feet
Agency: California Outdoor Properties, Inc - Arcata
Agency Phone: (619) 933-5504

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: THIS ESTATE IS OFFERED WITH OR WITHOUT BARN & PASTURE. Nothing makes a horse lover's soul shine more than irrigated pasture nestled in the mountains with a deluxe horse facility and an impeccable house to hang your hat. Situated between the Trinity Alps and Trinity Lake in the quaint little town where kids can be kids and everyone knows their neighbors. This luxury horse property has all the bells and whistles one could usually only find in your dreams. The main house is over 3,000 sq ft of a thoughtfully designed floor plan with top-of-the-line decor. This is a perfect 10 for the most discerning buyers with 3 bedrooms and 2.5 baths, a 7-car temperature-controlled garage, and a 60 x 48 custom barn. The interior of the house opens up with a dramatic entry into the massive gabled great room with a dramatic rock fireplace and artisan-quality stone flooring in the kitchen. Granite counters, custom cabinets, cooking island, breakfast bar, and dining nook all with views of the private backyard. The extensive covered outdoor patio is perfect for all seasons for entertaining, or just relaxing after a long trail ride on many local trails, some of which are right out your back door. Across the brick-paved driveway sits the meticulously kept and finished garage. There is plenty of room for the workshop, cars, trucks, and toys, and has its own 200 amp service. Above the garage sits a fully furnished 600 sq ft apartment tastefully decorated to compliment the house. On its own parcel, the barn sits between the riding arena and pasture. The irrigated pasture has 5 watering zones and 35 in-ground sprinklers. The 6" mainline is more than adequate to keep the pasture green and lush. Currently configured for 3 stalls, the barn also has 2 tack and feed rooms, a wash stall with bathroom and laundry area, a hay hoist, and plus a 12' x 48' storage area.Come experience a truly turn-key equestrian estate and small town America at its finest. The barn can be sold separately for $595,000, call for details.PROPERTY HIGHLIGHTS:Custom 3,000 sq. ft. home on 4.3 acres<br /> 3 Bedroom / 2 bath<br /> Open / Great room floor plan<br /> Vaulted ceiling<br /> Rock fireplace & mantle<br /> Granite counters & cooking island<br /> Recessed lighting with plenty of natural light<br /> Crown molding & custom cabinets<br /> Dual zone heating & cooling<br /> Some of the lowest electrical rates in the country<br /> Seven Car Temperature Controlled Garage<br /> Air-conditioned & heated<br /> 200 amp electric service<br /> Fully furnished 600 sq. ft apartment over garage with heat & A/C<br /> Workshop and attached carport<br /> Washer/dryer & bathroom<br /> Pull down the storage door & accessible from the stairwell<br /> 60' x 48' Barn made by Barn Pro<br /> Custom 3 stall barn (can be reconfigured to 7 stalls)<br /> Wash stall with full laundry area<br /> 2 tack & feed stalls<br /> 50 amp electric service<br /> Lift hay hoist (removable floor section for forklift)<br /> 12' x 48' equipment storage area<br /> Barn can be sold separately for $595,000 (call for details)<br /> Irrigation & 25' x 26' Pump House / Storage Barn<br /> 3 acres irrigated pasture<br /> 5 watering zones with 3" water lines<br /> 6' main water line<br /> 35 sprinklers + riding arena sprinklers<br /> 3 Fire plugs at barn and pump house<br /> 100 amp electric service to the pump house<br /> The "Extra" list:<br /> Riding arena<br /> Meticulous landscaping with auto sprinklers & drip<br /> End-of-road privacy<br /> Close to USFS / riding trails<br /> 2 parcel numbers with separate addresses<br /> The Barn can be sold separately for $595,000 (call for details)
MlsNumber: --
ListingId: 2111520


Listing Provided By: California Outdoor Properties, Inc - Arcata, original listing
Phone: (707) 613-0582
Office Phone: (619) 933-5504
Agent Name: Doren Morgan
Disclaimer: Copyright © 2024 LandLeader. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 240 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;
Real Estate Expert Photo for JAMI POOLE
JAMI POOLE
ASCIINorthstate Real Estate Professionals
Call Today!: (530) 227-4604

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App