Does it look weird?

I, personally, would not want it there. The entry gate gives me Condo, Assisted Living or Country Club vibes.

I think it would look great at Tail’s End, the lot next door. But you may already have ruled that out.