Write an engaging and detailed description for a real estate listing that highlights the property's key features and selling points.