Our mobile site is optimized for smaller screens.

TRY IT NO THANKS
MORE SEARCH OPTIONS
      PrintSave Favorite
      Price Down Payment Interest Rate Years
      %

      Est. Mortgage: $/month

      Federal 30-year interest rate: 6.79% last updated on 2023-06-01

      This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

      Active
      42 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 0265342 S Orleans Road Orleans MA 02653
      QR Code
      • 1,555Square Feet
      • 0.34Acreage
      • 1911Year Built
      • 341160Parcel Number
      Listed on the Inventory of Historic Assets of the Commonwealth, the Edgar H. Upham House was built in 1911 and is a lovely one-of-a-kind antique Queen Anne-styled Victorian Cottage, close to town amenities with lovely water views of the Town Cove. Highlights include: original hardwood floors, stained-glass windows, handsome oversized Victorian rosettes, plinth blocks, decorative moldings that frame the oversized new windows, doorways and antique plaster walls. Renovated in 2006, this beauty was used as a commercial spa with five treatment rooms; then changed to Mixed use with commercial space on the main floor. The first floor features a spacious living area with a wet bar, a galley kitchen and dining area, and a full bath. A gorgeous ornate staircase leads up to the 2nd floor residential space with three bedrooms and a full bath. There is also finished bonus space in the tongue and groove attic.The outside includes a stunning porch, a good size fenced in front yard, a two-car detached garage, and ample parking for customers or family. There are deeded easements to a panhandle piece of the property.All information to be verified by Buyer or Buyer's representation.
      Listed by Jacquelyn Tellier of William Raveis Real Estate & Home Services

      Ask A Question

      Call: 774-994-1900

      Do not fill in this field:

      Driving Directions

      Buyers Brokers of Cape Cod, McKenna Associates

      Your Local Office

      Buyers Brokers of Cape Cod, McKenna Associates
      116 Route 6A
      Sandwich MA, 02563

      Office: 774-994-1900

      More Info

      Location Information

      • Directions Corner of South Orleans Road (Rte 28) and Cove Road.Please enter via driveway entrance on Rte 28.

      School Information

      • High School DistrictNauset

      Basic Information

      • List Price$1,250,000
      • MLS Number22301629
      • Modification Date06/03/2023
      • Property SubTypeMixed Use

      Property

      • Acreage0.34

      Interior

      • Flooring Hardwood

      Utilities

      • Cooling Central Air
      • Cooling YN Yes
      • Heating Forced Air
      • Heating YN Yes
      • Sewer Septic Tank
      • Water Source Public

      Other

      • Date Listed05/01/2023
      • View Count4

      Basic Information

      • Lot Features
        • Corner Lot
        • Gentle Sloping
        • House of Worship
        • In Town Location
        • Level
        • Marina
        • Medical Facility
        • Public Tennis
        • School
        • Shopping
        • Views
      • Parcel Number 341160

      Location

      • Address42 S Orleans Road
      • Building Number42
      • CountyBarnstable
      • StateMA
      • StreetS Orleans Road
      • TownOrleans
      • Zip02653

      Exterior

      • Exterior Features Other, Yard
      • Fencing Fenced
      • RoofAsphalt, Pitched, Shingle

      Amenities

      • Appliances IncludedGas Water Heater, Water Heater
      • Other AmenitiesBasement, Tennis, Water View

      Tax Information

      • Tax Assessed Value $856,200
      • Tax Year 2023
      • Taxes$5,334

      Parking

      • Open Parking YN Yes
      • Parking Features Off Street, Paved
      • Parking Spaces10

      Building

      • BasementBulkhead Access, Full
      • Building Area Units Square Feet
      • Construction Materials Shingle Siding, Plaster
      • FoundationBrick/Mortar, Stone
      • Rooms6
      • Year Built1911

      Property Information

      • Living Area Units Square Feet
      • Lot Size Square Feet 14,810
      • Lot Size Units Acres
      • Property Condition Updated/Remodeled
      • Square Feet1,555

      broker reciprocity The data relating to real estate for sale on this site comes from the Broker Reciprocity (BR) of the Cape Cod & Islands Multiple Listing Service, Inc. Summary or thumbnail real estate listings held by brokerage firms other than Buyer Brokers of Cape Cod are marked with the BR Logo and detailed information about them includes the name of the listing broker. Neither the listing broker nor Buyer Brokers of Cape Cod shall be responsible for any typographical errors, misinformation, or misprints and shall be held totally harmless.

      This site was last updated June 4, 2023 1:21 PM EDT. All properties are subject to prior sale, changes, or withdrawal.

      Buyer Brokers of Cape Cod has chosen to display only certain towns and/or types or styles of properties. This site may not show all listings that are available through the Cape Cod & Islands Multiple Listing Service, Inc.

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      Do not fill in this field:

      $

      Do not fill in this field:

      Testimonials

      We had dreamed of owning a summer cottage on Cape Cod and contacted Ed to see if he wouldhelp in our search.  Ed was professional, persistent, and good humored from our initial meeting to the day of the closing.  His extensive knowledge of Cape Cod and the local real estate market turned our dream into a reality.  Ed, we can’t thank you enough for all the work you did and support you gave us! [...]

      Open Houses

      TIME TO TAKE A LOOK

      Browse the open house schedule today.

      View
      Blog

      STAY CURRENT

      Read about local area info.

      View