Title Page Background
DEBUG FN args: Array ( [0] => 2207 [1] => [2] => [3] => agent ) BEFORE: Site: 2207 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2207 Igate: njhud LocID: 2207 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2207 AND i.igate IN ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2207 [1] => [2] => [3] => lender ) BEFORE: Site: 2207 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2207 Igate: njhud LocID: 2207 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2207 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2207 [1] => [2] => [3] => other ) BEFORE: Site: 2207 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2207 Igate: njhud LocID: 2207 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2207 AND i.igate IN ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

487 Arkansas Ave
Vernonia, OR 97064
Melissa Welker with Stellar Realty Northwest, original listing - (971) 404-5630

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 6
Baths: Full: 6
Status: Active
SqFt: 3252 Square Feet
Agency: Stellar Realty Northwest
Agency Phone: (971) 404-5630

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1924
Notes: Rare opportunity to own a piece of Vernonia's history!Step into The Carpenter’s Guest House, a rare gem in Vernonia that blends history, charm, & exciting income potential! This extraordinary home isn’t just a place to live—it’s a turnkey business opportunity waiting for its next visionary owner.With four exquisite bedrooms, each with a private bath, your guests (or tenants!) will experience luxury & comfort. Plus, a separate 1-bedroom apartment with a kitchenette and private entrance offers bonus income or a perfect space for multi-generational living.Already operating as a thriving Bed & Breakfast, this property allows you to step into a profitable venture or create your own dream rental business. Be sure to ask for business details—this opportunity is too good to pass up!Outside, enjoy the perfectly situated corner lot with plenty of parking (including RV w/ hookup), lush cherry trees, & grapevines. Whether you’re hosting summer barbecues, sipping coffee in the morning sun, or unwinding under the stars in the 8-person hot tub, this home offers endless lifestyle perks.Lovingly restored in 2006/2007 with updated plumbing, electrical, a newer roof, and a standby generator, this property is move-in (or business-ready!). Plus, a security system with outdoor cameras & a brand-new gas fireplace insert ensures comfort and peace of mind.Just minutes from downtown Vernonia & scenic hiking trails, this stunning property is a must-see for entrepreneurs, investors, or anyone dreaming of a luxurious retreat. Book your tour today & turn this dream into reality!
MlsNumber: --
ListingId: 531975591


Listing Provided By: Stellar Realty Northwest, original listing
Phone: (971) 404-5630
Office Phone: (971) 404-5630
Agent Name: Melissa Welker
Disclaimer: Copyright © 2025 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