52 Church Street, Philmont
MLS® # 20263799
Rare opportunity in one of the Hudson Valley's most sought-after markets: a single-family home offering built-in flexibility for investors and owner-occupants alike. The attached in-law suite opens the door to multiple income strategies -- long-term rental, short-term stay, or multigenerational living -- while the main residence delivers the character and comfort today's buyers expect. Just minutes from Hudson's renowned Warren Street corridor, this property combines strong rental fundamentals with the enduring appeal of one of New York's fastest-growing small-city markets. For investors looking to add a versatile, income-ready asset to their portfolio, 452 Columbia Street checks every box.
The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.
Copyright © 2026 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.
All information provided is deemed reliable but is not guaranteed and should be independently verified.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.