No. Your highlighted that-clause is not appositive. It's actually a content clause functioning as complement to the pro-form "one". A simple test for an appositive is to see if it can stand alone in place of the whole noun phrase. In your example that would yield the non-sensical *"My house is that you enter directly from the neighbourhood".