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 = 3296 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 = 3296 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 = 3296 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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;

23175 Ne Ridge Rd
Gaston, OR 97119
Tyler Horst with Summa Real Estate Group, original listing - (503) 906-2606

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 3152 Square Feet
Agency: Summa Real Estate Group
Agency Phone: (503) 906-2606

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Don't miss this opportunity of a lifetime to purchase 27 level acres in the heart of Yamhill County wine county at the base of the Chehalem Mountain Range & turn key tomato farm business with 40+ years of experience growing exceptionally high quality & sustainably grown produce in the Willamette Valley. This opportunity includes a well maintained home in great condition perfect for an owner occupant & making this easily financeable, yurt, greenhouses & all existing farm infrastructure, equipment, machinery, vehicles, licensing, rare genetics & existing customer list. Owner has decades of experience & knowledge, great reputation in the agricultural & produce community & strong customer base going back 40+ years. Well known for his high quality & sustainably grown Oregon Star tomatoes & romaine lettuce! Owner is retiring, is willing to stay on for agreed upon transitionary & mentorship period and is ready to pass on the fruits of his labor & vast knowledge to the next generation who plan to foster this beautiful property. Lots of versatile options & expansion opportunities with this property including renovating the existing home into your dream home and enjoying this beautiful serene & secluded setting with mountain views, other agricultural applications and other commercial uses. Potential to modify yurt for the purpose of utilizing as short term rental for additional income but buyer to do due diligence. Home includes central heating & cooling, newer plumbing & electrical, large deck, hot tub, main level laundry, fireplace insert & potential for converting basement into additional living space. Come check out this beautiful property & turn key farm while it's still available!
MlsNumber: --
ListingId: 24007125


Listing Provided By: Summa Real Estate Group, original listing
Phone: (503) 906-2606
Office Phone: (503) 906-2606
Agent Name: Tyler Horst
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. 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