Title Page Background
DEBUG FN args: Array ( [0] => 1212 [1] => [2] => [3] => agent ) BEFORE: Site: 1212 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1212 Igate: njhud LocID: 1212 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 = 1212 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1212 [1] => [2] => [3] => lender ) BEFORE: Site: 1212 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1212 Igate: njhud LocID: 1212 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 = 1212 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1212 [1] => [2] => [3] => other ) BEFORE: Site: 1212 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1212 Igate: njhud LocID: 1212 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 = 1212 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4 Boulder Cove Road
Bremen, ME 04551

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 407 Square Feet
Agency: Better Homes & Gardens Real Estate/The Masiello Group
Agency Phone: 2075966095

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Dryer
Architectural Style: Cottage
Construction Materials: Frame, Shingle Siding
Heating: Space Heater, Stove
Interior Features: 1st Floor Bedroom, Shower, One-floor Living
Rooms: Bathroom 1, Bedroom 1, Kitchen

Window Features

Exterior Features: Level, Rural, Open Lot
Roof: Shingle
Waterfront Features: Pond

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Good things do come in small packages! Welcome to the epitome of small-scale luxury! Crafted in 2021 by the skilled hands of Terry Ryan, this petite haven boasts an unbeatable combination of location, charm, and sophistication. Step inside this adorable abode, spanning just over 400 sq. ft., and be greeted by lofty ceilings and soft pickled pine interiors infused with a modern twist. The heart of the home unfolds before you in the form of a seamlessly integrated kitchen/living room area, offering a contemporary ambiance that beckons relaxation. Choose your cozy spot and bask in the warmth emanating from either the Jotul wood stove or the Rennai heater, surrounded by carefully selected furnishings that effortlessly blend style with comfort. Indulge your culinary desires in the well-appointed kitchen, equipped with modern conveniences such as a refrigerator, electric range, dishwasher, wooden countertops, and a charming farm sink. Retreat to the inviting bedroom adorned with wood floors and complemented by an electric wall heater for those brisk evenings. Pamper yourself in the full bathroom featuring a walk-in shower, pedestal sink, and the added convenience of a stackable washer & dryer, all meticulously arranged for your comfort. Outside, savor seasonal waterviews and picturesque sunsets over McCurdy Pond, or embrace nature's embrace at nearby Pemaquid Pond and Pemaquid Pond Preserve. For outdoor enthusiasts, a small public beach and excellent swimming spot at Biscay Pond await, along with opportunities for kayaking and winter ice fishing. Conveniently nestled near Damariscotta, relish in a wealth of amenities including top-tier restaurants, quaint boutiques, grocery stores, a health food haven, and essential services like the library and post office. Embrace the essence of refined living in this idyllic retreat, where every detail is tailored to elevate your lifestyle.
MlsNumber: --


Listing Provided By: Better Homes & Gardens Real Estate/The Masiello Group, original listing
Phone: (207) 706-6242
Office Phone: (207) 596-6095
Agent Name: Meriwether Gill
Disclaimer: Copyright © 2024 Maine Real Estate Information System, Inc. 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