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

351 Cape Jellison Road
Stockton Springs, ME 04981

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1580
Agency: United Realty of Maine, LLC
Agency Phone: 2073237000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1880
Notes: Absolutely charming New England Jewel, within walking distance to ocean front park, public pier and yacht club. The covered front porch welcomes you and wraps around the front. This peaceful space will be hard to pass by without sitting a spell. Enjoy your outdoor grilling here too! This home has been conscientiously maintained by it's current and previous caretakers. It is always so wonderful to see a home with preserved, period details. This home offers so many, you must see it. I'll attempt to highlight some of the beautiful features. The front foyer leads into a lovely space with handsome staircase, and lovely display wall for your favorite art. To the right, flow into a front parlor. This room boasts lovely natural light, built ins and opens to the formal dining room. Sharing the same beautiful wood floors, built ins, this room overlooks the spacious and private back yard. Perhaps this becomes your library, music room or den. From here you flow into the dining area which opens to the kitchen. The eat-in kitchen and dining area feature lovely, exposed wood beams, ornate tin ceiling and of course, the brick hearth and fireplace. The laundry is on the first floor. Off the kitchen is a full bathroom, a wonderful wall of shelving for pantry items and an entrance to the side yard, leading to the detached garage. <br /> From the entrance off the kitchen to the front porch you will enjoy a nice coat room and yes, back stairway to the 2nd floor. <br /> Upstairs is the primary bedroom with wood floors, built in drawers, and access to the full bath with oversized shower. This bath also offers an entrance into the 2nd floor foyer, offering guest rooms a separate entrance. The 2 other bedrooms each have closets and average in size. The outdoors offers beautiful flowering shrubs and bushes throughout the seasons. A paved circular drive wraps around the front of the home and leads to the garage. Whole house generator. Town water, private septic. Stockton Harbor awaits
MlsNumber: 1588071


Listing Provided By: United Realty of Maine, LLC, original listing
Name: United Realty of Maine, LLC
Phone: (207) 323-7000
Office Name: United Realty
Office Phone: (207) 323-7000
Agent Name: Roland Littlefield
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