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

23 Warren St
Georgetown, MA 01833

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 4
Baths:
Status: Active
SqFt: 3841 Square Feet
Agency: NextHome Luxury Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Stunning 4-bedroom, 4-bath retreat nestled on a sprawling 3 acres with built-in pool and dual garages Perfect for entertaining and any business owner or tradesman. This home offers a harmonious blend of elegance, comfort, and functionality. It's 4 spacious bedrooms provide ample space for relaxation and privacy. Each bedroom features large windows that invite natural light and offer picturesque views of the surrounding landscape. The primary bedroom includes a fireplace, walk-in closet, oversized bathroom with jetted tub and separate shower and a private balcony to enjoy your morning coffee. The gourmet kitchen is the heart of this home, equipped with high-end appliances, granite countertops, and custom cabinetry. Whether you’re a seasoned chef or just love to entertain, this kitchen will inspire your creativity. The living and dininig areas flow seamlessly, creating an ideal space for gatherings and celebrations. The 5 fireplaces adds warmth and charm to the home. The four season sunroom includes a gas fireplace for those chilly nights. Descend to the lower level, where you’ll find a finished basement with custom built bar and plenty of space for your family gatherings. The additional kitchen on this level makes it perfect for hosting game nights, movie marathons, or even as a separate living space for extended family. Outside you will find your private paradise with an expansive backyard that boasts over three acres of greenery, perfect for gardening, play, or simply enjoying nature. Enjoy lounging by the sparkling pool on hot summer days, or host memorable barbecues on the spacious patio with your own tiki bar.<br /> <br /> If it is space you need, this home has garages to spear! You have an attached two-car garage which provides convenience for everyday use. Plus a remarkable detached oversized six-car garage deemed “the barn”. It is heated and air conditioned. The second level of the barn includes an office and a workshop area. This space is perfect for any car enthusiast, business owner or tradesman. The possibilities are endless!<br /> <br /> All this is situated in a peaceful neighborhood 35 miles from Boston. This home offers tranquility while still being close to amenities, schools, and major highways. Don’t miss the opportunity to make this dream home yours. Contact us today to schedule a private tour!
MlsNumber: --


Listing Provided By: NextHome Luxury Realty, original listing
Phone: (978) 432-9488
Office Phone: (617) 826-1166
Agent Name: Jennifer McQuarrie
Disclaimer: Copyright © 2024 NextHome, 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