"Through the front door you will find yourself welcomed by a two-story foyer with an exposed brick fountain and mahogany trim," says the listing agent.