Given the lack of mains power at the remote location, I’d consider a conventional RF solution. LoRa offers excellent receiver sensitivity and good range at low power, but it isn’t necessarily the only option. A simple battery-powered RF transmitter, sending a short burst only when the contact changes state, could be very energy-efficient.
With a suitable receiver and a directional antenna at the house, a conventional RF link might also work over 500 m. The lack of line of sight makes both solutions more challenging, so the actual terrain and antenna placement will be decisive.
Obviously, LoRa offers more flexibility and built-in communication features, while a simple RF system could be much cheaper and less complex. I’d compare both based on the required reliability, battery life and ease of integration with the iHost/Node-RED.
However, I’m not aware of a straightforward, off-the-shelf kit that I could confidently recommend for your exact requirements: 500 m without line of sight, battery operation and integration with iHost. There are no obvious plug-and-play solutions here, and modifying an existing RF sensor with a power amplifier and a suitable antenna is possible.
SONOFF has also offered RF-based sensors, which could provide a starting point. If you have the necessary RF expertise, modifying the transmitter with an additional power stage and a suitable antenna may be an option. Alternatively, someone with the right experience could help with that. Either way, this is no longer a simple plug-and-play project, particularly given the 500 m distance and lack of line of sight.
That said, this is probably beyond the scope of the eWeLink forum. People here may be able to point you in the right direction, but for detailed technical guidance on designing a long-range RF or LoRa link, you’d be better off asking in a specialist radio communications or LoRa community. There are probably several suitable forums where people discuss exactly these kinds of projects.