$1,100,000
bedrooms
2
bathrooms
2
square feet
2,272
Acreage
0.05
Open Houses
-
year built
1900
Full Baths
0
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
Find out more
Tell us who you are, and we will have someone reach out to you.
MLS number: 156298
Listing agent:
Pamela King-Belfor
Listing broker:
Gary Dimauro Real Estate, Inc. - Hudson
8220800
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: Wednesday, April 2 2025 at 9:57 a.m. EDT
Kotohomes National
Other listings you might be interested in
$1,000,000
3 Bed •
2 Bath •
2,300 ft²
17395 Floral Avenue W
San Joaquin, CA 93660
$1,159,000
3 Bed •
2 Bath •
3,130 ft²
15664 Mills
Visalia, CA 93292
$950,000
3 Bed •
2 Bath •
2,024 ft²
9010-9080 El Dorado Tr.
Mountain Ranch, CA 95246
$1,199,000
3 Bed •
3 Bath •
2,140 ft²
1551 John Dear Road
Mountain Ranch, CA 95246
$1,225,000
4 Bed •
2 Bath •
2,001 ft²
54813 Willow Cv
Bass Lake, CA 93604
$899,000
3 Bed •
3 Bath •
2,764 ft²
969 Hiawatha
Camp Connell, CA 95223
$1,499,500
3 Bed •
3 Bath •
2,956 ft²
2283 Courtside Drive E
Fresno, CA 93730
$980,000
3 Bed •
4 Bath •
3,140 ft²
4045 Red Hill Road
Vallecito, CA 95251
$970,000
4 Bed •
3 Bath •
3,255 ft²
911 Highland Road
Madera, CA 93636
$949,000
3 Bed •
4 Bath •
3,546 ft²
8908 Lakeside Drive
Mountain Ranch, CA 95246
$1,450,000
4 Bed •
3 Bath •
2,400 ft²
39266 Lupine
Bass Lake, CA 93604
$2,350,000
3 Bed •
3 Bath •
4,735 ft²
1333 Vineyard Terrace
Murphys, CA 95247