rage house load

namespace Crazy_CnR.House
{
    public class Houses : Script
    {
        List<HouseVar> HouseList = new List<HouseVar>();
        [ServerEvent(Event.ResourceStart)]
        public void OnResourceStart()
        {

            LoadAllHouses();

        }
        public void LoadAllHouses()
        {
            string houselabel;
            string s;
            string Query = "SELECT a.*, b.name FROM house a LEFT JOIN accounts b ON a.owner = b.id";
            using MySqlCommand command = new MySqlCommand(Query, Database.conn);
            {

                using (MySqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {

                        HouseVar House = new HouseVar();
                        House.HouseID = reader.GetInt32("id");
                        House.HouseOwner = reader.GetInt32("owner");
                        House.HouseTitle = reader.GetString("title");
                        House.HousePrice = reader.GetInt32("price");
                        House.HouseX = reader.GetFloat("x");
                        House.HouseY = reader.GetFloat("y");
                        House.HouseZ = reader.GetFloat("z");
                        House.HouseA = reader.GetFloat("a");
                        House.HouseLock = reader.GetInt32("privacy");


                        s = reader.GetString("name");

                        House.HouseMarker = NAPI.Marker.CreateMarker(1, new Vector3(House.HouseX, House.HouseY, House.HouseZ), new Vector3(), new Vector3(0, 0, House.HouseA), 1f, new Color(21, 0, 255), true, 0);
                        House.HouseCol = NAPI.ColShape.CreateCylinderColShape(new Vector3(House.HouseX, House.HouseY, House.HouseZ), 1f, 1f, 0);
                        if(House.HouseOwner == 0)
                        {
                            houselabel = "House ID: " + House.HouseID + "\n" + "For Sale" + "Price: " + House.HousePrice;
                            House.HouseBlip = NAPI.Blip.CreateBlip(350, new Vector3(House.HouseX, House.HouseY, House.HouseZ), 1f, 1, "House For Sale", 255, 1000, false, 0, 0);
                        }
                        else
                        {

                            houselabel = "House ID: " + House.HouseID + "\n" + "Owner:  " + s + "\n" + "House Title: " + House.HouseTitle + "\n" + "House Value: " + House.HousePrice;
                        }
                        House.HouseText = NAPI.TextLabel.CreateTextLabel(houselabel, new Vector3(House.HouseX, House.HouseY, House.HouseZ), 10f, 1f, 1, new Color(255, 255, 255), false, 0);

                        HouseList.Add(House);
                    }
                }
            }
        }
    }
}