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

424 Winthrop Street
Hallowell, ME 04347

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 4
Baths:
Status: Active
SqFt: 3082 Square Feet
Agency: Transworld Commercial Real Estate of Maine
Agency Phone: 2078354770

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Construction Materials: Wood Siding, Frame
Cooling: Heat Pumps
Heating: Heat Pump, Forced Air, Radiant
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Laundry, Media Room, Living Room, Exercise Room

Window Features

Exterior Features: Patio, Deck, Corner Lot, Near Town
Parking Features: Paved or Surfaced
Patio and Porch Features: Patio, Deck
Roof: Shingle

Neighborhood/Schools

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

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1885
Notes: Discover a gem nestled on Winthrop Street - a residence that exemplifies modern living, infused with a touch of history. Behold this beautiful extended Cape boasting an array of coveted amenities that are sure to enchant even the most discerning of tastes. Step inside to uncover a captivating interior, offering four spacious bedrooms and two and a half bathrooms. Entertain guests effortlessly on the expansive patio or deck overlooking an inviting in-ground pool, perfect for indulging in moments of leisure and relaxation.<br /> <br /> Unique Character and Modern Comfort:<br /> <br /> Hand-Built Granite Walls and Walkways: The residence boasts a unique charm with walls and walkways meticulously crafted from local granite stones.<br /> <br /> New, High-Efficiency Boiler: Enjoy worry-free warmth with a recently replaced boiler.<br /> <br /> Radiant Heating and Geothermal Water Heater: Experience the ultimate in comfort and energy savings with radiant floor heating and a geothermal water heater.<br /> <br /> Heat Pump: Stay cool in the summer and warm in the winter with a versatile heat pump system.<br /> <br /> Insulated Basement: Enjoy a comfortable and versatile basement space thanks to added insulation.<br /> <br /> Unparalleled Location:<br /> <br /> Moments from Downtown Hallowell and Manchester: Enjoy the charm and convenience of nearby shops, restaurants, and cultural attractions.<br /> <br /> Easy Access to I-95: This residence offers a commuter's dream location with effortless access to I-95, perfect for those who work outside the area.<br /> <br /> Location: This peaceful haven is located on Winthrop Street on a dead-end road with only two other houses, offering tranquility and privacy. Plus, enjoy direct trail access to the Hallowell Reservoir trail system, perfect for nature lovers.<br /> <br /> Additional Highlights:<br /> <br /> This home has been meticulously designed for your utmost convenience and enjoyment. Don't miss this opportunity to own a piece of tranquility with easy access to everything you need, wrapped in a unique blend of historic charm and modern comfort.
MlsNumber: --


Listing Provided By: Transworld Commercial Real Estate of Maine, original listing
Phone: (207) 600-4252
Office Phone: (207) 835-4770
Agent Name: Beaux Vachon
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => kennebec [3] => ME [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: kennebec State: ME Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: kennebec State: ME 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 = 1210 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;
Gregory Roy
ASCIIeXp Realty
Call Today!: (207) 215-8548

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App