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

4125 Green Mountain Dr
Mt Hood Prkdl, OR 97041

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 4
Baths: 5
Status: Active
SqFt: 5239
Agency: Don Nunamaker, Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1998
Notes: Step inside to your next new home and check it out! Welcome to this stunning custom-built home with an amazing Mt. Hood view and private wooded property. Cut down a few more trees to open up the amazing view even more. Something for every member of the family in this thoughtfully designed home on 2.51 acres. Collector car and mechanic enthusiast dream with collector car storage and workshops. One shop is 25'x35' and the second one is 40'x40'. Plenty of room for your dream car collection. Includes a custom car painting room. Both shops are 220v wired and each has a 25 gallon air compressor. Permanent steel airlines around main shop with custom steel top benches. Enjoy working year-round in the main shop with heat pump and air conditioning. Definitely a mechanics dream! Work from home with two full offices both large enough to convert to anything you desire. The large family recreation room would be great for your theater room or pool table and includes a large entertaining area with a bar. Your dream kitchen has granite countertops, stainless steel appliances, a custom backsplash, double ovens, and tons of storage. Home is large enough for multi-generational living with exterior access from every side of the home - bring your family over to view! Four bedrooms, three full bathrooms and two half bathrooms. Property includes four heat pumps, security system, motion sensors, darkness lights, fiber optic service and an inground sprinkler system. There is a large entertaining deck and a fully fenced back yard for your furry friends. Home also includes a second story 47'x36' terrace. House is serviced by public water system and property has a well for drinking water and/or outdoor watering. Also included is a 40' storage container and three tool sheds. Seller will consider offers with buyer concessions. Don't forget to see the virtual tour. Don't miss out on making an offer today and plan an hour to view as this property is expansive and lots to see!
MlsNumber: 24506979


Listing Provided By: Don Nunamaker, Realtors, original listing
Name: Don Nunamaker, Realtors
Phone: (541) 490-3109
Office Name: Don Nunamaker
Office Phone: (541) 386-4400
Agent Name: Teresa Martz
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