luxury real estate for sale Charleston, United States

Prime Investment Opportunity! Two-unit mixed-use property consisting of one office/retail space and one residential unit with a strong and consistent rental history. High-traffic location provides excellent exposure for commercial tenants, supporting long-term demand. Recent capital improvements include a new roof, driveway, and siding, reducing near-term maintenance expenses. Flexible layout allows for multiple business uses, including professional office, salon, or retail. Ideal asset for investors seeking stable income with owner-occupant or value-add potential.

Welcome to Lovelace Hollow, a private country retreat where space, nature, and tranquility come together on 10.49 acres of beautiful Schoharie County countryside. Set at the end of a peaceful, tree-lined driveway, this home offers a rare opportunity to enjoy sweeping views of rolling meadows, distant mountains, and the quiet beauty that surrounds this special property. Built in 1999 and lovingly maintained throughout the years, Lovelace Hollow offers over 4,300 square feet of flexible living space across three levels. Designed to embrace its natural surroundings, the main living level welcomes you with soaring ceilings, a dramatic wall of windows, and an abundance of natural light. The living room opens to an expansive deck where you can enjoy your morning coffee, watch the seasons change, and take in the peaceful views overlooking the landscape. The spacious kitchen features a large center island, generous workspace, and an inviting dining area with vaulted ceilings that flows seamlessly into the main living space. An open loft overlooking the great room creates the perfect setting for a home office, reading nook, or creative space, while an additional recreation room provides endless possibilities for hobbies, entertaining, or flexible living needs. The lower level offers even more room to gather and unwind, with two bedrooms, a family room, game room, and walkout access to the covered patio area. The private primary suite includes an en suite bath, while the thoughtful layout allows for privacy and versatility throughout the home. Beyond the residence, this property truly shines. Mature landscaping, perennial gardens, thoughtfully placed trees, open meadows, and wooded surroundings create a private sanctuary where nature is part of everyday life. A custom-built observatory offers the opportunity to enjoy unforgettable nights beneath the stars, while the detached garage and storage shed provide space for vehicles, equipment, and hobbies. To help maintain the beautiful grounds, the sale also includes a yard tractor, making it even easier to care for and enjoy the property's acreage. Improvements over time, including a generator, exterior updates, important mechanical and infrastructure upgrades, and the included yard tractor provide added peace of mind and practicality for the next owner. Whether you dream of creating a hobby farm, escaping the pace of everyday life, or simply finding a place where you can slow down and enjoy the beauty around you, Lovelace Hollow offers a setting that is truly one of a kind.