For Sale For Rent
Advertise
bedrooms
bedrooms
2
bathrooms
bathrooms
2
square feet
square feet
2,272
acreage
Acreage
0.05
open houses
Open Houses
-
year built
year built
1900
full baths
Full Baths
0
half baths
Half Baths
1
Prime Mixed-Use Property on Warren Street. This exceptional property offers the perfect blend of commercial and residential space in a sought-after Warren Street location. The ground floor features a spacious, open-plan layout, currently serving as a real estate office. A well-equipped kitchen in the rear includes commercial under-counter refrigerators and a high-end dishwasher. Situated just steps from The Maker, Le Perche, and Feast & Floret, this vibrant block is a true destination. Upstairs, a stunning two-bedroom apartment boasts soaring 10-foot ceilings. The light-filled dining room, adorned with restored Tuscan columns and dentil molding, seamlessly connects to an elegant living area. The front bedroom, accessed through classic French doors, is bathed in natural light from the north and west and offers ample closet space. A well-appointed bathroom and an efficient kitchen sit off the dining room. Towards the rear, the second bedroom features a cozy gas fireplace and opens onto a private enclosed deck, overlooking the lush garden and neighboring park. Additional highlights include a private patio garden, off-street parking, and a dry basement with abundant storage space. Meticulously maintained by a professional property management team, this move-in-ready property has been fully upgraded for modern comfort and convenience.
Location
Subdivision -
County Columbia
Elementary School -
Middle School -
High School -
Exact location data not provided
no map
open houses Open houses
None scheduled.
Find out more
Tell us who you are, and we will have someone reach out to you.

By proceeding, you consent to receive calls, texts and voicemails at the number you provided (may be recorded and may be autodialed and use pre-recorded and artificial voices), and email, from Kotohomes, Pamela King-Belfor, and their network of service providers about your inquiry and other home-related matters.

Msg/data rates may apply. This consent applies even if you are on a do not call list and is not a condition of any purchase.

MLS number: 156540
Listing agent: Pamela King-Belfor
Copyright © 2025 Columbia Greene and Northern Dutchess MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.   [source]
Last update: Tuesday, April 22 2025 at 3:37 p.m. EDT
Kotohomes National