Wi-Fi is practical with the existing network, LoRa for small amounts of data and different radio design, and nRF24L01 for its own connection between compatible nodes. No choice guarantees universal reach.
A remote sensor that sends a few bytes per minute has different needs than a camera. For the sensor in the building, Wi-Fi can be the simplest if the connection at the location works reliably.
The codes 868 and 915 MHz are not automatically interchangeable. Even the stronger antenna does not solve the wrong frequency plan or unauthorised setting.
Select products according to the above criteria; the list is not a confirmation that they are all interchangeable.
ESP32 38 pin WIFI IoT Bluetooth
LORA32 Development Panel 868/915Mhz ESP32 with OLED display
Module for wireless data transmission 2.4GHz GT-24 NRF24L01