Skip main navigation
Active
  • $1,100,000

    2666 New York 23, Hillsdale, NY 12529

    3beds
    4baths
    2,880sqft
    Loading
    Mixed Use
    Built in 1880
    0.5 Acres Lot
    $1,065,000 Zestimate®
    $382/sqft
    $-- HOA

    What's special

    Unique investment opportunity in the hamlet of Hillsdale. This new-to-the-market commercial/residential property has been meticulously renovated by the current owner, a commercial builder, who over-engineered the project with high-end features throughout. The property consists of four distinct rental units: 2666 Route 23, Main (Blue) Building - First-Floor Commercial Unit Right Side: 360 sq. ft. (currently Antique Shop) - Second-Floor Residential Apartment: Two bedrooms, 737 sq. ft. (currently VERY LUCRATIVE AirBnB) - Two-Story Commercial Unit Left Side: 766 sq. ft. (currently leased 12+/- mo. to State) Red Barn Building - Two-Story Barn Renovation: Two bedrooms, one bath, 791 sq. ft. (currently VERY LUCRATIVE AirBnB) Main Building: Circa 1880 3 Units ~ 2 Commercial Retails and a Fully Furnished turn key AirBnB/Apartment In the Berkshire/Taconic Mtn area, main building was fully renovated creating retail shops and a sophisticated but casually comfortable 2 BR apt. saving many of the original building features. Efficiency kitchen (convention microwave, cooktop, Mr. Coffee, all utensils, cookware, DW) with a W/D, marble bath, sleeps 4 , cable TV and internet. Bright and airy, full AC. Children friendly with tamper proof outlets, central station fire alarm system, CO detector. Offered Fully Furnished. The Carriage House ~ Private Residence AirBnB This structure was built around 1845 as a carriage house for the main building. The building's structure was completely reconstructed with great sensitivity to the unique features of the original use. The hay loft floor remains as a ceiling for the 1st floor although it is now 11 ft high. The 1st floor consists of an open plan living space with a washer/dryer combo tucked tastefully in the utility space. The 2nd floor has 2 bedrooms and a bathroom highlighted by the exposed timber roof framing. The space; the effort to maintain the 1845 appeal of the space is very successful with finishes utilizing reclaimed materials from the main house renovation as well as much from the original carriage house. The original siding has been incorporated into the interior walls abutting the timber framed structure. The bathroom is finished with Carrera marble tile shower walls and floor. Five panel mahogany doors complete the charming ambiance of the space. The Barn is highly energy efficient with spray foam insulation, new Pella windows and heat pump supplying environmental comfort. Immediately outside the entrance is a blue-stone paver patio with dining table chairs, Adirondack seating and gas grill. This overlooks a calming view of gardens and neighboring backyards. Offered Fully Furnished. Five Start AirBnB stats upon request. Purchased in 2012, transformed into sophisticated retail/residential, vacation getaway spaces, while preserving many original architectural features - see list of improvements. Basement of main building could easily be converted into additional living space. Features include high ceilings, water already hooked up etc. The location is ideal for a four-season destination, situated near Catamount Ski and Adventure Park, the Copake-Hillsdale Farmers Market, the Harlem Valley Rail Trail (goes all the way to NYC now!), and Taghkanic State Park. It also offers easy access to the dining and entertainment options in Hudson and the Berkshires. This is an exceptional multi-use property for anyone seeking a high-quality investment in Columbia County.
    82 days
    |
    206
    |
    3
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Columbia County RE Specialist 518-325-9784,

    Margaret Bower Avenia 518-697-9865,

    John Avenia 518-567-4404,

    Columbia County RE Specialist

    Source: HVCRMLS,MLS#: 20262449MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 4
      Heating
      • Baseboard, Electric, Varies by Unit
      Appliances
      • Included: Washer/Dryer, Refrigerator, Range, Microwave, Dishwasher
      • Laundry: In Basement
      Features
      • Cathedral Ceiling(s), Ceiling Fan(s), Eat-in Kitchen, High Speed Internet, Kitchen Island, Pantry, Walk-In Closet(s)
      • Flooring: Ceramic Tile, Combination, Concrete, Hardwood, Varies, Wood
      • Basement: Apartment,Full,Walk-Out Access,Walk-Up Access
      • Has fireplace: No
      Interior area
      • Total structure area: 2,880
      • Total interior livable area: 2,880 sqft
      • Finished area above ground: 2,880
      • Finished area below ground: 2,880

      Property

      Parking
      • Parking features: Private, Driveway
      • Has uncovered spaces: Yes
      Features
      • Levels: Bi-Level
      • Stories: 2
      • Patio & porch: Deck, Patio, Porch
      • Exterior features: Balcony, Courtyard, Private Entrance, Private Yard, Rain Gutters
      • Fencing: Back Yard
      • Has view: Yes
      • View description: Mountain(s), Neighborhood
      Lot
      • Size: 0.5 Acres
      • Features: Few Trees, Front Yard, Near Golf Course, Paved, Rectangular Lot, Views
      Details
      • Additional structures: Guest House, Residence, Second Residence, Workshop
      • Parcel number: 145.4132
      • Zoning: Residential/Com
      • Zoning description: Multi Use
      • Other equipment: Varies by Unit

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cottage,Farmhouse,Gothic Revival
      • Property subtype: Mixed Use
      Materials
      • Frame
      • Foundation: Block, Brick/Mortar
      • Roof: Shingle
      Condition
      • Updated/Remodeled
      • New construction: No
      • Year built: 1880

      Utilities & green energy

      • Electric: 220 Volts in Kitchen
      • Sewer: Public Sewer
      • Water: Well
      • Utilities for property: Electricity Available, Sewer Available, Water Connected
      Green energy
      • Energy efficient items: Insulation

      Community & HOA

      Community
      • Features: Clubhouse, Fishing, Golf, Lake, Park, Playground, Racquetball, Restaurant, Sidewalks, Street Lights
      • Security: Carbon Monoxide Detector(s), Smoke Detector(s)
      HOA
      • Has HOA: No
      Location
      • Region: Hillsdale

      Financial & listing details

      • Price per square foot: $382/sqft
      • Tax assessed value: $250,000
      • Annual tax amount: $7,314
      • Date on market: 5/16/2026
      • Listing terms: Contract
      • Total actual rent: 30600
      • Electric utility on property: Yes
      • Road surface type: Paved

        Estimated market value

        $1,065,000

        $1.01M - $1.12M

        $6,850/mo

        Price history

        DateEventPrice
        5/16/2026Listed for sale$1,100,000$382/sqft
        Source: HVCRMLS #20262449 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 12529

        Getting around

        38 / 100
        Car-Dependent
        35 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes