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

457 Greenwood Drive
Point Roberts, WA 98281
Greg Heppner with National Real Estate Point Roberts, original listing - (360) 945-1011

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $589,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2002 Square Feet
Agency: National Real Estate Point Roberts
Agency Phone: (360) 945-1011

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Stunning Rancher on Expansive Double Lot with Mature Landscaping - A Hidden Gem in Point Roberts! Nestled on a tranquil street in the coveted Point Roberts area, this meticulously maintained rancher sits on a rare 0.43-acre double lot, offering a blend of privacy, serenity, and natural beauty. This four-season home is designed with elegance and functionality in mind, boasting impressive architectural features such as four striking barrel ceilings, abundant skylights, and expansive wood-framed windows that invite the outdoors in. The sunken living and family rooms, each graced with cozy propane fireplaces, create inviting spaces for both relaxation and entertaining. The spacious en-suite bathroom is a true retreat, featuring a luxurious sunken jetted tub and a rejuvenating sauna-perfect for unwinding after a long day. Recent updates ensure the home is move-in ready, including a new furnace, modern flooring, upgraded kitchen appliances (fridge, dishwasher), a new washer and dryer, as well as fresh bathroom fixtures, including sinks, faucets, and toilets. The newly painted interiors and stylish new baseboards add a contemporary touch to the home's timeless charm. From the charming breakfast nook, step outside onto a large, private deck-an ideal setting for family BBQs, evening cocktails, or simply soaking in the afternoon sun. The peaceful surroundings of this spacious yard are enhanced by an array of mature fruit trees, including Granny Smith apples, pears, cherries, and Asian pears, along with sweet table grapes, making it a gardener's paradise. For added convenience, the property includes a double garage and two additional outbuildings-one large enough to accommodate a car or your boat, offering plenty of space for storage and hobbies. This unique property offers unparalleled value, exceptional privacy, and an unbeatable location-all at an incredible price. Ready to move in and start living your dream lifestyle in Point Roberts! Don't forget to check out link to the online video tour.
MlsNumber: --
ListingId: 11474817


Listing Provided By: National Real Estate Point Roberts, original listing
Phone: (360) 945-1011
Office Phone: (360) 945-1011
Agent Name: Greg Heppner
Disclaimer: Copyright © 2025 My State MLS. 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 = 2964 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 JoEll Byrnes
JoEll Byrnes
ASCIIRe/Max Whatcom County
Call Today!: (360) 318-6956

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App