cmds.buyhouse = function(playerid)
    playername = GetPlayerName(playerid);
    if (IsPlayerConnected(playerid)) and (PlayerInfo[playerid].Logined == false) then return SendMessageToPlayer(playerid, "~r~You Must Be Logged In To Use Commands!") end;
        local houses = SendQueryToMySQL("SELECT * FROM houses");
        for key, value in pairs(houses) do
            local hX = value["hx"]
            local hY = value["hy"]
            local hZ = value["hz"]
            if (IsPlayerInRangeOfPoint(playerid, 2, hX, hY, hZ)) then
                local houseid = value["houseid"]
                if value["owner"] == GetPlayerName(playerid) then return SendMessageToPlayer(playerid, "~r~This Property Is Already Been Owned ") end;
                if(PlayerInfo[playerid].pHouse == 1) then return SendMessageToPlayer(playerid, "~r~You Can Only Buy One Property!") end;

                if(PlayerInfo[playerid].Money > 1500000) then

                    SendQueryToMySQL("UPDATE houses SET  owner='" ..PlayerInfo[playerid].Name.. "' WHERE houseid='" ..value["houseid"].."'");
                    SendQueryToMySQL("UPDATE users SET  houseowned='" ..PlayerInfo[playerid].pHouse.. "' WHERE name='" ..PlayerInfo[playerid].Name.."'");

                    PlayerInfo[playerid].Money = PlayerInfo[playerid].Money -1500000;
                    SendMessageToPlayer(playerid, "~y~Property Bought!")
                    SendMessageToPlayer(playerid, "~b~Congradulations ~w~You Just Bought Yourself A Place To Live!")
                    PlayerInfo[playerid].pHouse = 1;

                    PlayerInfo[playerid].Score = PlayerInfo[playerid].Score +2;

                    GivePlayerScore(playerid, 2);
                    PlayerInfo[playerid].IsAtHouse = true;

                end
            end
        end

        if (PlayerInfo[playerid].IsAtHouse == false) then
            return SendMessageToPlayer(playerid,"You are not at any house!");
        end
    end